Subcategories
Packages
Python SDK for Aliyun Tablestore (OTS), a managed NoSQL database service, enabling read, write, batch operations, range scans, transactions, and full-text or vector search on structured data.
However, it is only useful if you have an Aliyun account and an active Tablestore instance; it is not a general-purpose database client.
Wraps SQLAlchemy and pyodbc to simplify connection and session management for Microsoft SQL Server databases.
No, not for new projects.
Constructs SQL queries programmatically using Python syntax instead of string concatenation, generating parameterized SQL and parameter tuples for safe database execution.
Install it if you're building dynamic queries and want type-safe, injection-proof SQL generation; skip it if you prefer raw SQL strings or a heavier ORM like SQLAlchemy.
Integrates dbt models with Cube's semantic layer by parsing dbt manifests and converting model definitions into Cube-compatible data model specifications.
However, the aging maintenance status (296 days since last release) means you should verify compatibility with your current dbt and Cube versions before relying on it…
Packages DuckDB core extensions as pip-installable Python modules, letting you add functionality like cloud storage, format support, and database connectors to DuckDB without leaving the Python ecosystem.
Install it if you use DuckDB and need any of its core extensions—the pip integration eliminates the friction of managing extension binaries separately.
Python driver for connecting to and querying Neo4j graph databases using the Bolt protocol, with support for both synchronous and asynchronous operations.
Builds DataFusion SQL queries programmatically with injection-safe value handling, emitting readable SQL text rather than requiring string concatenation or templates.
Embeddable graph database with Cypher query support, full-text search, vector indices, and columnar storage optimized for analytical workloads on large datasets.
Constructs, manipulates, and serializes time series data in JSON Time Series (JTS) specification format, with support for timestamped records containing values, quality codes, and annotations.
Configures and initializes LaminDB instances, handling database setup, credentials, and environment configuration for the LaminDB data management framework.
However, verify the license terms first, as they are not declared in the package metadata.
Provides Python bindings to connect to and interact with InterSystems IRIS databases, supporting both native object access and standard DB-API SQL queries.
PyPgConfig detects and exposes PostgreSQL configuration details from the system's pg_config tool, allowing Python code to query PostgreSQL version, library dependencies, and build settings.
However, the lack of updates since 2023-11-28 and alpha status mean you should verify it works with your PostgreSQL version and be prepared to maintain a fork if needed.
simplekv provides a unified key-value storage API that abstracts over multiple backends—filesystem, SQLAlchemy, MongoDB, Redis, S3, and Google Storage—letting you swap storage implementations without changing application code.
Provides a Model Context Protocol (MCP) server that enables AI assistants to discover, explore, and safely query Amazon Redshift clusters and serverless workgroups through a standardized interface.
Install it if you use Redshift and want MCP-compatible AI tooling; skip it if you have no Redshift clusters or do not use MCP clients.
A Python client library that provides nearly source-compatible access to Amazon DAX clusters using a Boto3-like interface for DynamoDB operations.
However, the high install friction (source distribution, compilation required) and aging maintenance status (290 days since last release) mean you should verify that…
klepto provides multiple caching algorithms (LRU, LFU, MRU, random-replacement) and persistent archiving to files, databases, or HDF5, with a dictionary-style interface and function decorator support.
Install it if you need caching beyond functools.lru_cache or persistent result archiving; skip it if simple in-memory caching suffices.
Parses, transpiles, and optimizes SQL across 23 different dialects without any runtime dependencies, enabling you to convert queries between systems like DuckDB, Presto, Spark, Snowflake, and BigQuery.
Install it if you need to work with SQL across multiple database systems or parse and analyze SQL programmatically.
Patroni orchestrates PostgreSQL high-availability clusters using distributed configuration stores like etcd, Consul, ZooKeeper, or Kubernetes to manage failover, replication, and cluster state.
Install it if you need automated failover and cluster coordination; skip it if you manage PostgreSQL replication manually or use a managed database service.
Enables DuckDB to query data over HTTP/HTTPS by providing the httpfs extension as a Python package, allowing direct access to remote files without downloading them locally first.
Install only if you have duckdb already in your environment and a concrete use case for remote file access.
Provides a Python interface for querying and manipulating Databricks SQL tables with chainable methods for select, insert, update, and delete operations.
Automatically reconnects Django database connections when the underlying TCP connection has been closed, retrying the failed operation instead of immediately raising an OperationalError.
Provides a lightweight wrapper around redis-py that simplifies initialization and connection management, exposing the underlying Redis client through a shared singleton instance.
PIconnect provides Python access to OSIsoft PI and PI-AF databases through their SDK, enabling extraction, interpolation, updates, and server-side filtering of time-series data.
pypyodbc provides a pure Python ODBC interface for connecting to databases like SQL Server and Microsoft Access without requiring compiled extensions, using ctypes to call ODBC drivers.
Python client library for connecting to Databend databases, supporting both local embedded in-process analytics and remote server connections with synchronous, asynchronous, and PEP 249 cursor interfaces.
Provides database schema migration management for SQLAlchemy projects, enabling version-controlled changesets and command-line tools to track and apply database schema changes.
Provides Python bindings to execute SQL scripts and procedural logic against Teradata databases with DevOps-focused features like query banding and logging.
Parses CREATE TABLE DDL statements from MySQL, MariaDB, PostgreSQL, Oracle, and Redshift, extracting table schema information and converting it to BigQuery JSON schema and DDL formats.
However, maintenance is dormant (last release July 2021); if you need support for newer SQL features or active bug fixes, verify that the package handles your…
Py2neo is a Python client library for Neo4j that provides Bolt and HTTP connectivity, a high-level API, an OGM, and Cypher tooling—though the project is now end-of-life with no further updates planned.
No—not for new projects.
A pytest plugin that provides fixtures for running tests against temporary, auto-cleaned PostgreSQL databases, with support for time freezing and common database operations.
However, adopt it only if you can accept that maintenance is minimal—the last release was 2020-05-13, and there is no active development roadmap.
Wraps Python database drivers to add Aurora failover support, topology caching, and enhanced failure monitoring without changing existing application code.
Reads and writes dBase III, FoxPro, Visual FoxPro, and Clipper .dbf database files, converting between legacy DBF formats and Python data types.
However, maintenance is aging (last release 346 days ago), so verify compatibility with your specific Python version and DBF variant before committing to production use.
Pins publishes and shares Python objects (data, models, etc.) to versioned pin boards stored locally, on cloud services (S3, GCS, Azure), or Posit Connect, with automatic versioning and cross-language (Python/R) compatibility.
Embeds a PostgreSQL database directly in Python with zero configuration, no Docker required, and built-in pgvector support for vector operations.
Parses Microsoft Access database files (.mdb and .accdb) in pure Python without external binary dependencies, extracting tables and their contents for programmatic access.
However, expect limited compatibility testing and slow response to new issues; verify it works with your specific database files before relying on it in production.
Reads and writes Delta Lake tables with native Python bindings backed by delta-rs, offering Pandas integration and HopsFS support for data lake operations.
Not recommended if you require other architectures or older Python versions.
Provides a command-line interface for managing database instances, enabling operations like saving and retrieving files within a workspace.
However, verify the license status before use in proprietary contexts, and confirm that your Python version is supported (currently unspecified in the metadata).
Provides SQLAlchemy dialects for connecting to Amazon RDS PostgreSQL instances using IAM authentication instead of passwords, with support for both psycopg2 and asyncpg drivers.
However, verify that it remains compatible with your SQLAlchemy, psycopg2/asyncpg, and boto3 versions before deploying to production.
Provides AWS CDK constructs to deploy Amazon Aurora Global Databases across multiple AWS regions, handling infrastructure setup that lacks native CloudFormation support.
No—not recommended for new projects.
Wraps PyMongo's Collection class to explain database operations without executing them, showing query plans and execution details instead.
However, verify PyMongo version compatibility first—the documented constraint is PyMongo>=3.10,<4, which may limit use in newer projects.