Packages
Parses Presto SQL type annotations from rows returned by the Presto REST API into Python objects.
Paracelsus generates Entity Relationship Diagrams from SQLAlchemy models, outputting them as Mermaid or Dot format for visualization and documentation.
Install it if you want automated, version-controlled schema diagrams; skip it if your schema is trivial or you prefer manual diagram tools.
Python client library for TigerBeetle, a distributed financial accounting database, enabling creation and management of accounts and transfers with built-in batching and two-phase commit semantics.
Install it if you need a Python client for a distributed financial ledger; do not install if you are looking for a standalone accounting library without a separate…
SQLAlchemy dialect for BigQuery that enables SQL queries against BigQuery datasets using SQLAlchemy's ORM and expression language.
Provides a SQLAlchemy DateTime type that consistently handles timezone-aware datetimes across database vendors, storing all values in UTC and returning aware datetime objects regardless of whether the underlying database supports native timezone types.
However, it is abandoned (last commit August 2022, no activity for nearly four years) and only explicitly supports Python up to 3.9.
Provides a SQLAlchemy dialect for connecting to IOMETE data warehouses via Arrow Flight SQL, enabling standard SQLAlchemy operations and schema reflection on IOMETE clusters.
Provides a SQLAlchemy dialect for Vertica using the pure-Python vertica-python driver, enabling ORM and SQL expression language access to Vertica databases.
Provides both async and sync Python clients for the Meilisearch search API, enabling document indexing and full-text search operations.
Integrates Django applications with ClickHouse, a columnar database, providing ORM-like access and query tools for analytics and time-series data workloads.
However, verify that infi.clickhouse-orm is still maintained and that the package's dormant status does not hide unresolved compatibility issues with your Django…
Builds and validates Elasticsearch client connections with schema validation, version checking, and configuration file support.
Provides a SQLAlchemy dialect that enables Python applications to connect to and query RisingWave, a cloud-native streaming database, using SQLAlchemy's standard ORM and query APIs.
However, understand that RisingWave's streaming semantics diverge significantly from PostgreSQL OLTP assumptions—read the documentation on read-after-write visibility…
cqlsh is a command-line client for executing CQL queries against Cassandra clusters, packaged as a standalone Python module instead of requiring a full Cassandra installation.
Provides a Django database backend that connects Django ORM to Snowflake, allowing you to use Snowflake as your primary database for Django applications.
However, avoid it for high-concurrency web applications due to race conditions in ID retrieval, and be aware of constraints around JSONField queries, interval math,…
Adds filtering, sorting, and pagination capabilities to SQLAlchemy query objects via declarative specifications, designed for REST API exposure.
However, accept that maintenance is dormant: no updates since April 2023, and compatibility with newer SQLAlchemy versions is unverified.
Adds SQL execution to Jupyter and IPython notebooks via `%sql` and `%%sql` magic commands, letting you query databases directly in cells and integrate results with Python.
A Django database backend that lets you use Django ORM to query and manage ClickHouse tables directly, treating ClickHouse like any other Django-supported database.
However, carefully evaluate the limitations: no transaction support, missing constraint enforcement, and non-standard NULL semantics in joins and aggregations.
Pythena wraps AWS Athena queries in a Python interface that returns results as pandas DataFrames, requiring only a database name and SQL query string.
Official Python client for SurrealDB, supporting both remote (WebSocket/HTTP) and embedded (in-memory or file-based) database connections with synchronous and asynchronous APIs.
However, verify the license terms before use—the metadata does not specify a license, which is a blocker for some projects.
Provides a DBAPI 2.0 connection interface and SQLAlchemy dialects to query Databricks Workspace and SQL Analytics clusters using either pyhive or pyodbc backends.
No, not recommended for new projects.
Automatically optimizes GraphQL queries executed by graphene-django using Django QuerySet methods like select_related, prefetch_related, and only to reduce database round-trips.
However, be aware that maintenance is dormant—last release was 2023-08-05—so compatibility with newer Django or graphene versions is unverified.
A JupyterLab 4 extension that integrates JupySQL into the notebook environment, enabling SQL query execution and data exploration directly within JupyterLab.
However, proceed with caution: dormancy means the extension may not be compatible with very recent JupyterLab updates.
pymgclient is a Python adapter for Memgraph graph database, implementing the DB-API 2.0 specification to enable query execution and result fetching through a standard cursor interface.
Async MySQL database driver for Python asyncio applications, providing a non-blocking interface to MySQL and MariaDB servers.
However, the 381-day gap since the last release and aging maintenance status suggest it may not receive prompt updates for new MySQL/MariaDB features or Python versions.
Official Python API client for Autodesk Flow Production Tracking, enabling programmatic access to production tracking data and integration with external tools.
Install it if you need to integrate with or automate a Flow Production Tracking instance; it is the standard choice for that use case.
Pydoris is a Python client for Apache Doris that enables SQLAlchemy-based database connections and query execution against a Doris analytical database.
Install it if you need to query Apache Doris from Python—it's the standard SQLAlchemy dialect for that purpose.
mycli is a command-line client for MySQL and compatible databases (MariaDB, Percona, TiDB, Apache Doris) that provides auto-completion, syntax highlighting, and interactive query features.
Provides a SQLAlchemy 2.0+ dialect for connecting to and querying Firebird 3.0+ databases using the firebird-driver DB-API 2.0 driver.
h5grove provides building blocks for serving HDF5 file contents—attributes, metadata, and data—via web backends, handling common problems like external link resolution, dataset compression/slicing, and JSON-safe data encoding.
Python client library for the Sonic search backend, providing ingest, search, and control operations over a network connection.
However, the abandoned maintenance status means you should expect no updates for Python version compatibility or Sonic protocol changes, and you may need to fork or…
Adds HTTP Basic Authentication and OpenID Connect (OIDC) login to Dash applications, with support for public routes, user groups, and protected callbacks.
Reads MS Access database files (.mdb) into Pandas DataFrames by wrapping the MDBTools command-line utility via subprocess.
A high-level Python query builder for Elasticsearch that translates idiomatic Python expressions into Elasticsearch JSON DSL queries, plus optional document mapping and persistence.
Indexes Django model instances into OpenSearch and provides management commands and automatic signal handlers to keep indices synchronized with database changes.
A Python client library for querying dbt's Semantic Layer via REST APIs, supporting both synchronous and asynchronous workflows with results returned as PyArrow tables.
Python client library for querying and managing Stardog knowledge graph servers and Stardog Cloud instances.
ODMantic is an async-first Object Document Mapper for MongoDB that lets you define database models using Python type hints and Pydantic validation, then query and persist them with a functional API.
Install it if you need an async MongoDB ODM with strong type safety and Pydantic integration.
Adds automatic, human-readable repr() output to SQLAlchemy model instances by providing mixin base classes that format column data for display.
Query Amazon product data and pricing history from the Keepa API, with support for both synchronous and asynchronous requests, and optional visualization of price trends.
Python SDK for connecting to Oracle NoSQL Database (cloud service, simulator, or on-premise) to perform queries, reads, writes, and table operations.
An async HTTP client for ClickHouse that handles type conversion between ClickHouse and Python types, supports streaming and lazy decoding on SELECT queries, and provides a fully typed interface.