Packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
asyncpg is an asyncio-native PostgreSQL client library that executes queries asynchronously over the PostgreSQL binary protocol, enabling non-blocking database access in async Python applications.
Provides compiled C optimizations for the PostgreSQL database adapter, accelerating database operations when installed as an optional component.
SQLAlchemy dialect that enables you to use BigQuery as a database backend through SQLAlchemy's ORM and query interface.
Install it if you need to access BigQuery through SQLAlchemy's ORM or query interface.
Provides a unified, open()-compatible Python API for streaming large files from remote storage (S3, GCS, Azure, HDFS, SFTP, HTTP) and local filesystems, with transparent compression support.
Install it if you work with large files on cloud storage or remote systems and want to avoid writing boilerplate around multiple SDKs.
PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling thread-safe connections, cursors, and SQL execution with native support for PostgreSQL data types.
Official Python client library for connecting to and querying Elasticsearch clusters, handling connection management, load balancing, and translating Python data types to Elasticsearch API calls.
Python client library for connecting to and querying OpenSearch clusters, providing a high-level API for search, indexing, and cluster management operations.
Install it if you need to query or manage an OpenSearch cluster from a Python application.
redshift_connector is a Python database driver for Amazon Redshift that implements the DB-API 2.0 specification, enabling direct SQL queries and data operations against Redshift clusters.
Install it if you're building Redshift-integrated data pipelines, analytics tools, or applications requiring direct SQL access to Redshift.
Peewee is a lightweight ORM that maps Python classes to database tables and provides a query builder for SQLite, MySQL, MariaDB, and PostgreSQL, with optional asyncio support.
Provides pandas extension data types for SQL systems like BigQuery and Spanner, enabling native representation of database-specific types within pandas DataFrames.
Install it if you regularly work with SQL data in pandas and need type fidelity.
pg8000 is a pure-Python PostgreSQL driver that implements the DB-API 2.0 standard, allowing you to connect to and query PostgreSQL databases from Python code.
Provides Python DB-API and SQLAlchemy dialect support for querying Apache Pinot via its SQL API, supporting both synchronous and asynchronous operations.
Python client library for Supabase that provides unified access to PostgreSQL databases, authentication, real-time subscriptions, serverless functions, and file storage through a single API.
Provides a SQLAlchemy 2.0 dialect that bridges SQLAlchemy applications to Databricks SQL, enabling ORM and SQL expression language support for Databricks workspaces.
Install it if you need to use SQLAlchemy with Databricks.
An async Python client library that provides an ORM-like interface to PostgREST APIs, enabling CRUD operations and stored procedure calls against PostgreSQL databases exposed via PostgREST.
Provides a connection pool for Psycopg 3, managing reusable PostgreSQL database connections to reduce overhead and improve performance in applications that make frequent database queries.
Streamlit transforms Python scripts into interactive web applications with minimal code, enabling rapid development of data dashboards, reports, and chat interfaces without requiring web development expertise.
PyAthena is a Python DB API 2.0 client for Amazon Athena that lets you query data in S3 using SQL, with support for both synchronous and asynchronous execution.
Install it if you're already using Athena; skip it if you don't have AWS infrastructure or prefer direct boto3 calls.
Python client library for Trino, a distributed SQL engine, providing DBAPI 2.0 and SQLAlchemy adapter interfaces to query and manage big data clusters.
Install it if you need to query a Trino cluster from Python—it is the official client and supports both simple DBAPI workflows and complex SQLAlchemy integrations.
Provides a SQLAlchemy dialect that enables applications to use SQLAlchemy's ORM and query API against Google Cloud Spanner databases.
pyvespa provides a Python API to create, deploy, and interact with Vespa instances, enabling programmatic control over a scalable serving engine for storing, computing, and ranking data at query time.
Install it if Vespa is already part of your architecture or you are exploring it.
aiomysql provides async/await access to MySQL databases by wrapping PyMySQL with asyncio support, letting you query MySQL non-blockingly from async Python code.
Install it if you need non-blocking MySQL access in an asyncio application; the single dependency (PyMySQL) and pure-Python wheel keep setup simple.
Dash is a Python framework for building interactive web applications with reactive UI elements like dropdowns and graphs tied directly to analytical code, using Flask and Plotly for rendering.
Install it if you need to turn analytical Python code into interactive dashboards or data apps.
A PEP-249 compliant Python database driver that enables applications to connect to and query Teradata Database systems.
However, review the proprietary Teradata License Agreement before use in commercial or open-source redistribution contexts, and note that beta features carry no…
PyHive provides DB-API and SQLAlchemy interfaces to query Presto, Hive, and Trino clusters from Python, supporting both synchronous and asynchronous execution.
Native Python client library for connecting to and querying Vertica databases, implementing the DB-API v2.0 standard.
However, the aging maintenance status suggests it may not receive timely updates for new Vertica features or Python versions—verify compatibility with your specific…
Flask-Migrate handles SQLAlchemy database migrations for Flask applications using Alembic, exposing migration operations as `flask db` command-line commands.
Install it if you are building a Flask app with SQLAlchemy and need to manage schema changes over time.
Provides a SQLAlchemy dialect for Amazon Redshift, enabling ORM and SQL expression language support against Redshift clusters via psycopg2 or redshift_connector.
PubChemPy is a Python wrapper around the PubChem REST API that lets you search for chemical compounds by name, substructure, or similarity, retrieve their properties, and convert between chemical file formats.
Install it if you need programmatic access to PubChem data.
Provides a SQLAlchemy dialect that enables Python applications to connect to and query Teradata databases using SQLAlchemy's ORM and SQL expression language.
However, the proprietary license is unclear and maintenance is aging (241 days since last release).
Provides a Python DBAPI-compatible client to query Presto, a distributed SQL engine, executing SQL and retrieving results.
However, note the release gap since 2023-09-07—verify compatibility with your Presto version before adopting in new projects.
A Python DBAPI driver for YDB that provides sync and async database connections compliant with PEP 249, supporting parameterized queries with automatic type mapping.
However, verify the license terms (currently unclear in the metadata) before committing to production use, and note that the project is relatively young (first…
Python driver for connecting to IBM Db2 for LUW and IBM Db2 for z/OS databases, providing both a native interface and a DB-API 2.0-compliant wrapper.
HTTP client for submitting SQL queries to Yandex Query service and retrieving results with column metadata.
However, dormant maintenance means no active development; install it only if the current API surface meets your needs and you can tolerate no future updates.