Database packages

Bioregistry provides a unified Python interface to query, normalize, and parse identifiers and CURIEs across life science databases, ontologies, and other biological resources.

Official Python client for Elasticsearch that handles connection management, node discovery, load balancing, and idiomatically translates Python data types to and from JSON for cluster operations.

Install it if you need to interact with Elasticsearch from Python—it is the standard choice for this task.

A lightweight SDK for self-hosted tasks to send status updates, logs, and outputs back to Orchestra via HTTP, with decorator support for automatic lifecycle management.

However, the aging maintenance status (261 days since last release) suggests you should verify that the SDK remains compatible with your Orchestra version and that…

Datasette is a web server and CLI tool that transforms SQLite databases into interactive, queryable websites with a REST API, designed for exploring and publishing data without writing custom code.

Adds multi-tenant database support to Django by automatically scoping queries to a tenant context, enabling efficient query routing in distributed databases like Postgres+Citus.

Install it if you are building a multi-tenant Django application on Postgres+Citus or similar distributed databases.

A pure-Python MySQL driver that implements the DB API v2.0 specification without requiring MySQL C client libraries.

PySide2 provides Python bindings to the Qt 5.12+ framework, enabling developers to build cross-platform desktop applications with a complete GUI toolkit.

Install only if maintaining existing PySide2 code or if you have specific Qt 5.12 compatibility constraints.

Connects SQLAlchemy models to Atlas to automatically generate and apply database schema migrations, eliminating manual migration writing.

However, the aging maintenance status (243 days since last release) and unclear license terms warrant verification before adopting in production or commercial projects.

Adds a `.to_dict()` method to SQLAlchemy model instances, converting them to dictionaries with support for nested relationships, custom field rules, and timezone handling.

Install it if you want to avoid the boilerplate of schema libraries for straightforward serialization tasks.

Provides a Python API to interact with GoodData Cloud or GoodData.CN installations, enabling inspection and consumption of semantic models, workspaces, data sources, visualizations, and computed analytics.

Provides a persistent base class built on ExtensionClass for object serialization and storage in Zope-based applications.

Load SQL queries from files and call them as Python methods, supporting both sync and async database drivers across SQLite, PostgreSQL, MySQL, MariaDB, DuckDB, and MS SQL Server.

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.

Parses OData v4 filter strings and transpiles them to Django QuerySets, SQLAlchemy queries, or raw SQL for database filtering.

However, verify compatibility with your specific ORM versions before relying on it in production, since the last release was 777 days ago and no updates are forthcoming.

Generates Tableau Hyper files directly from Apache Spark DataFrames and SQL queries, then publishes them to Tableau Server, bypassing slower ODBC-based extract workflows.

However, maintenance is aging (no releases since September 2023), so verify compatibility with your current versions of pyspark, tableauhyperapi, and Tableau Server…

An MCP server that exposes ClickHouse database operations—query execution, database and table listing—as tools for AI assistants and MCP clients, with optional embedded chDB support.

Install it if you need Claude or another MCP client to query ClickHouse databases.

Automatically collects and sends dbt run metadata—model lifecycle, inputs, and outputs—to an OpenLineage backend for data lineage tracking.

The main gotcha is the unclear license metadata—verify the Apache-2.0 claim before use in restricted contexts—and ensure your dbt adapter is in the supported list.

YORM maps Python object attributes bidirectionally to YAML files, automatically synchronizing changes between in-memory objects and text-based storage.

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.

Extends Alembic's autogenerate to detect and emit PostgreSQL enum value changes as ALTER TYPE ADD VALUE statements in migrations.

No, not recommended.

A pure Python client library for accessing memcached using the binary protocol with SASL authentication support, including distributed key hashing and TLS encryption.

Teradata ModelOps Client provides a CLI and SDK for managing machine learning model lifecycle—training, evaluation, deployment, and versioning—within Teradata's data platform.

However, the proprietary license restricts use to internal purposes tied to a Teradata database license, and Windows users must manually install OpenSSL.

Streams data in real-time into Snowflake tables via a Python SDK with a Rust-based core for high performance.

Install only if you have streaming requirements; it is not a general-purpose data tool.

Provides type stubs for influxdb-client, enabling static type checkers like mypy, pyright, and pytype to validate code using the InfluxDB client library.

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 PostgreSQL-backed key-value store integration for LlamaIndex, enabling persistent storage of indexed data and embeddings using a relational database backend.

Defines AWS Redshift clusters and database resources (users, tables) as CDK constructs, enabling infrastructure-as-code management of Redshift deployments with VPC integration and audit logging.

However, be aware that this library is experimental—expect potential breaking changes in future releases and review the release notes carefully when upgrading.

Adds CreateView and DropView SQL constructs to SQLAlchemy, enabling programmatic creation and removal of database views through SQLAlchemy's expression language.

sqltap hooks into SQLAlchemy to collect and report metrics on SQL queries—execution counts, timing, and call sites—helping you identify performance problems in ORM-heavy applications.

Generates marshmallow schemas automatically from mongoengine document models, enabling serialization and deserialization of MongoDB data with minimal boilerplate.

However, note that the last release was 2023-03-14; verify compatibility with your specific versions of mongoengine and marshmallow before adopting, and monitor the…

MySQL-python provides a Python 2 interface to MySQL databases, implementing the Python Database API specification for executing queries and managing connections.

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.

A command-line interface for running dbt commands against dbt Cloud development environments, enabling data transformation workflows from your local terminal.

However, the high install friction and unclear license require upfront investigation.

Provides a Postgres-backed document store integration for LlamaIndex, enabling persistent storage and retrieval of documents within LlamaIndex applications.

SpeeDict is a Python key-value storage library backed by RocksDB that persists arbitrary Python objects (via Pickle) or raw bytes to disk, supporting dictionary-like access with batch operations.

However, avoid it for mission-critical systems requiring active support or frequent updates.

Provides a DBAPI 2.0-compatible interface to Snowflake via the ADBC driver manager, enabling standard Python database operations against Snowflake warehouses.

Python client library for the Rockset API, enabling programmatic creation, management, and querying of Rockset resources.

Generates parameterized SQL queries from Jinja2 templates, automatically binding variables to prevent SQL injection while supporting conditional logic, macros, and multiple parameter styles.

Python client library for Turso, a SQLite-compatible database built on libSQL, enabling connection to and querying of Turso databases from Python applications.

LaminDB is a data management system for organizing, querying, and governing multimodal datasets across diverse storage formats with built-in lineage tracking, versioning, and ACID compliance.

However, the license status is unclear—verify the actual license terms before adopting in proprietary or regulated environments.