Subcategories
Packages
Provides Python bindings for PGVecto.rs, a PostgreSQL vector database extension, with support for multiple vector types and integration with SQLAlchemy, Psycopg3, and Django.
Install only if you can tolerate stalled upstream development and verify compatibility with your PostgreSQL and PGVecto.rs versions independently.
Builds and executes complex SQL queries dynamically in Django applications for database operations that Django's ORM doesn't handle well.
Sends data to Google BigQuery with minimal setup, providing a simplified interface for loading data into BigQuery tables.
PyMongoArrow converts MongoDB query results into Apache Arrow tables, Pandas DataFrames, or NumPy arrays for analytical processing.
Install it if you regularly need to move MongoDB query results into Arrow, Pandas, or NumPy for analysis.
An Object Graph Mapper (OGM) for Neo4j that lets you define graph database models as Python classes and query them with a class-based API, built on the neo4j driver.
Install it if you're building a graph application in Python and prefer declarative models over manual driver calls.
A Python client for pushing ML feature data from offline sources to Orion Feature Store and retrieving feature metadata via protobuf serialization and Kafka integration.
However, the aging maintenance status (343 days since last release) means you should verify that it remains compatible with your Spark, Kafka, and Orion versions…
Reads data from Excel spreadsheet files (.xls and .xlsx formats) and extracts cell values, sheet metadata, and row/column information for programmatic access.
Provides a ZODB-compatible pickle interface that handles cross-version serialization between Python 2 and 3, with support for protocol 3 opcodes and the noload() operation.
SQLAlchemy dialect for JDBC and ODBC database connections with support for PostgreSQL, Oracle, MySQL, MariaDB, SQL Server, DB2, SQLite, OceanBase, GBase 8s, IBM iSeries, MS Access, and Apache Phoenix.
However, maintenance is aging (268 days since last release), and the description explicitly requests community testing feedback, indicating some dialects may not be…
chdb-core is an in-process SQL OLAP engine powered by ClickHouse that runs SQL queries directly in Python without requiring a separate server, supporting multiple input/output formats and DB-API 2.0 compliance.
ZODB is an object-oriented database for Python that stores and retrieves Python objects directly without requiring a separate query language or object-relational mapping layer.
Provides unified Python access to multiple storage services (S3, GCS, Azure, local filesystem, and others) through a single API, abstracting away service-specific details.
Official Python client for Elasticsearch that handles connection management, load balancing, and API communication with Elasticsearch clusters.
Vortex-data provides Python bindings to work with Vortex, a columnar file format optimized for high-performance data processing with Apache Arrow compatibility and pluggable compression encodings.
A Model Context Protocol server that connects AI agents to PostgreSQL databases for analysis, tuning, and safe query execution with health checks and index optimization.
However, verify current maintenance status before relying on it in production—the package is aging with no recent commit history visible, and support clarity is needed.
Decorator-based caching for Python functions using Redis as the backend store, with support for TTL, cache invalidation, and Redis cluster compatibility.
However, maintenance is aging (507 days since last release); consider it for established, low-change codebases rather than projects requiring active upstream support.
Converts Pydantic class definitions to Apache Spark schemas and generates Python code from Spark schemas, bridging type validation and distributed data processing.
However, be aware that the project is dormant—no updates since late 2023—so you should verify compatibility with your current Pydantic and Spark versions before…
A Python Database API 2.0-compliant driver for Firebird 3+ that provides both standard DB API access and Firebird's interface-based client API with additional extensions.
Install it if you need to connect Python to Firebird 3+; it's the standard choice for that task.
Looks up Canadian postal codes to retrieve city, province, geographic coordinates, and timezone information, and finds postal codes within a specified radius.
However, if you require current postal code data or active maintenance, you should verify the database currency against Canada Post's current FSA assignments before…
Asyncio-based memcached client providing non-blocking get, set, delete, and multi-get operations with optional flag handling for callback-based value processing.
Install it if your async application needs non-blocking cache access; skip it only if you don't use asyncio or don't need memcached.
Deep Lake is a serverless database for storing, searching, and streaming multi-modal data (images, videos, text, embeddings) alongside vector search capabilities, designed for AI applications and deep learning workflows.
However, install it only after verifying the license terms directly in the repository (metadata is unclear) and confirming Python version compatibility for your…
A dbt adapter that enables data transformation and testing workflows on Microsoft SQL Server and Azure SQL services, integrating SQL Server as a dbt-supported data warehouse.
A Python client library for the Grafana HTTP API, supporting both synchronous and asynchronous operations to manage dashboards, users, teams, data sources, and other Grafana resources.
Install it if you need to programmatically manage Grafana resources.
Provides a Django model field that obfuscates integer IDs using the Hashids library, storing integers in the database while exposing them as encoded strings.
No—not for new projects.
Python client for the Keboola Storage API that provides methods to interact with buckets, tables, and workspaces—exporting table data to files, creating tables, and listing bucket contents.
However, note that maintenance is aging and the client does not yet cover the entire API surface, so verify that your required endpoints are implemented before…
Dask cuDF extends Dask DataFrame with a GPU-accelerated backend, enabling parallel and larger-than-memory data processing on NVIDIA GPUs using a pandas-like API.
Reads data from ODBC data sources directly into Apache Arrow record batches, enabling efficient columnar data access from databases, spreadsheets, and other ODBC-compatible sources.
Provides simplified APIs for Django querysets to generate optimized SQL, particularly for subquery-based aggregations and existence checks that are more performant than Django's default JOIN-based approaches.
However, verify compatibility with your Django version first—the package has been dormant since 2023-09-28 and may not work with very recent Django releases.
Executes bulk update and bulk create operations on PostgreSQL databases from Django, allowing efficient multi-record updates with conditional logic in a single query.
However, note that maintenance is dormant (last release 775 days ago)—verify compatibility with your Django version before committing, and be aware of the documented…
Provides a Repository pattern for MongoDB with Pydantic model integration, supporting both synchronous and asynchronous CRUD operations with built-in validation and serialization.
Ingest NDJSON data into Tinybird Data Sources and send requests to Tinybird APIs from Python, with support for both synchronous and asynchronous operations and logging integration.
However, verify the license terms before use—the package does not declare an SPDX license—and confirm minimum Python version compatibility with your environment.
Wraps SQL Server's BCP utility to transfer data between pandas DataFrames and SQL Server tables at high speed, with no BCP knowledge required.
Python client library for etcd v3 that provides key-value storage operations, distributed locks, transactions, and watch capabilities for monitoring key changes.
Extends Django's ORM to capture and return rows modified by PostgreSQL UPDATE, DELETE, and bulk CREATE operations, letting you retrieve database-computed values without extra queries.
dbstream is a meta package designed to provide unified connection and access to multiple database systems through a single interface.
dbt-dremio is a dbt adapter that enables data transformation workflows in Dremio Cloud and Dremio Software (versions 22.0 and later) using dbt's ELT practices.
Install it if you use Dremio (Cloud or Software 22.0+) and want to adopt dbt for data transformation.
Watches a local directory, indexes structured files into an in-memory SQLite database, and exposes a SQL query interface with real-time change tracking.
Performs streaming, partition-level upsert operations on Delta Lake tables with bounded memory usage, replacing delta-rs's SQL MERGE with a merge engine that scales with batch size rather than target table size.
Provides typed attribute classes for PynamoDB that extend DynamoDB's native types with Python-native serialization for enums, timestamps, UUIDs, timedeltas, and composite keys.
However, verify the license status before committing to production use, and be aware that maintenance is aging—last release was March 2024 with no activity since then.
Adds soft-deletion support to SQLAlchemy models with automatic query filtering and customizable mixin generation.