querysource
Aiohttp web service for querying several databases easily
Decision gist · record as of 2026-08-14
Yes, if you need to query multiple heterogeneous data sources (databases and APIs) in an async context and can absorb the 65-dependency footprint. The active maintenance, recent release, permissive license, and zero known vulnerabilities support adoption. No, if you only need a single database driver or want a minimal dependency footprint—the proxy abstraction is not worth the overhead for single-source use cases.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python >= 3.10.1 and < 3.14; async/await context required; database or API credentials must be configured separately.
- Medium install friction due to 65 runtime dependencies including database drivers (psycopg2-binary, sqlalchemy), web clients (selenium, playwright, httpx), and specialized connectors (hubspot-api-client, simple_salesforce).
- Recent release (9 days old) and active maintenance signal confidence in the codebase.
License · maintenance · safety
BSD-3-Clause (permissive) — BSD-3-Clause is permissive and imposes minimal restrictions; you may use, modify, and distribute QuerySource in commercial projects provided you retain the license notice and disclaimer.
last release 2026-08-05 (9 days) · last repo commit 2026-08-07 · 16 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 110,264 downloads/mo, #12,477 on PyPI
Alternatives
Verify before relying
from querysource.queries.qs import QS
query = QS(
query='SELECT * FROM tests',
output_format='pandas'
)
result, error = await query.query()- How to configure connections for specific databases or APIs (documentation link provided but content not verified).
- Whether all 65 runtime dependencies are always required or if they are optional per data source.
- Performance characteristics and query latency across different backend types.
- Extent of type hints coverage (marked 'Typed' but depth unknown).
What it is and what it does
QuerySource is an async Python library that abstracts away the complexity of connecting to and querying multiple databases and external APIs. Instead of writing separate connection logic for PostgreSQL, Redis, Salesforce, and other sources, you define a single QS object with your query and output format, then await the result. It uses the proxy design pattern to route queries to the appropriate backend handler.
The library carries substantial dependency weight—65 runtime packages including database drivers (psycopg2-binary, sqlalchemy), web automation tools (selenium, playwright), API clients (hubspot-api-client, simple_salesforce), and async utilities. This breadth reflects its goal to support many data sources out of the box, but means you inherit all those dependencies even if you only use a subset of backends. It targets Python 3.10.1 and above, is actively maintained (last commit 2026-08-07), and carries no known vulnerabilities.
Use it for
- Build a data pipeline that pulls from PostgreSQL, Redis, and Salesforce without managing separate connection pools.
- Create an async web service that queries multiple databases and APIs through a single unified interface.
- Prototype rapid data integrations by leveraging pre-built connectors for common sources like ShopperTrack and ZipCodeAPI.
- Extend QuerySource with custom data sources by inheriting BaseProvider or BaseAPI and registering the new handler.
- Execute parameterized queries across heterogeneous backends and normalize results into a common format (e.g., pandas).
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need to query multiple heterogeneous data sources (databases and APIs) in an async context and can absorb the 65-dependency footprint.
The active maintenance, recent release, permissive license, and zero known vulnerabilities support adoption. No, if you only need a single database driver or want a minimal dependency footprint—the proxy abstraction is not worth the overhead for single-source use cases.
Install
querysource on PyPI
Before you install
Medium install friction due to 65 runtime dependencies including database drivers (psycopg2-binary, sqlalchemy), web clients (selenium, playwright, httpx), and specialized connectors (hubspot-api-client, simple_salesforce). Recent release (9 days old) and active maintenance signal confidence in the codebase.
Requires Python >= 3.10.1 and < 3.14; async/await context required; database or API credentials must be configured separately.
License in practice
BSD-3-Clause is permissive and imposes minimal restrictions; you may use, modify, and distribute QuerySource in commercial projects provided you retain the license notice and disclaimer.
Quickstart
from querysource.queries.qs import QS
query = QS(
query='SELECT * FROM tests',
output_format='pandas'
)
result, error = await query.query()Verify before relying
- How to configure connections for specific databases or APIs (documentation link provided but content not verified).
- Whether all 65 runtime dependencies are always required or if they are optional per data source.
- Performance characteristics and query latency across different backend types.
- Extent of type hints coverage (marked 'Typed' but depth unknown).
Package facts
| License | BSD-3-Clause permissive |
| Python support | Supports the current Python release <3.14,>=3.10.1 |
| Install friction | Medium. Platform-specific wheel |
| Runtime dependencies | 65 packagesLivePopularTimeshubspot-api-clienthttpxh2oauth2clientgoogle-analytics-datagoogle-api-python-clientgoogle-auth-oauthlibsqloxideaiocsvlxmlxlsxwriterodswriterodfpyxlrdreportlabAPSchedulerbs4simple_salesforcepsycopg2-binarysqlalchemyseleniumsnapshot-seleniumwebdriver-managerplaywrightproxylistsasync-notifynavconfignavigator-apijsonschema |
| Maintenance | Actively maintained 9 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 110,264 / month, #12,477 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaEnvironment :: Web EnvironmentFramework :: AsyncIOIntended Audience :: DevelopersLicense :: OSI Approved :: BSD LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.9Topic :: Software Development :: Build ToolsTopic :: Software Development :: Libraries :: Application FrameworksTopic :: Software Development :: Libraries :: Python ModulesTyping :: Typed |
Evidence: querysource-4.5.11-cp310-cp310-manylinux_2_28_x86_64.whl; querysource-4.5.11-cp310-cp310-musllinux_1_2_x86_64.whl; querysource-4.5.11-cp311-cp311-manylinux_2_28_x86_64.whl; querysource-4.5.11-cp311-cp311-musllinux_1_2_x86_64.whl; querysource-4.5.11-cp312-cp312-manylinux_2_28_x86_64.whl; querysource-4.5.11-cp312-cp312-musllinux_1_2_x86_64.whl; querysource-4.5.11-cp313-cp313-manylinux_2_28_x86_64.whl; querysource-4.5.11-cp313-cp313-musllinux_1_2_x86_64.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “unified database query interface”
- querysourceQuerySource provides a unified async interface to query multiple…
- opentelemetry-instrumentation-dbapiAdds automatic tracing and observability instrumentation to Python…
- astroqueryAstroquery provides a Python interface to query and retrieve data…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also databases · dbstream · django-db-connection-pool · sqlalchemy-jdbcapi · pysqlsync · influxdb · postgres · CouchDB · cloudant · dj-database-url