Subcategories
Packages
Provides soft-delete functionality for Django models, allowing objects to be masked from queries instead of permanently removed from the database.
However, the aging maintenance status (527 days since last release) and lack of explicit Python 3.12+ / Django 5.1+ support in the fact sheet warrant verification…
A Django model field that stores and retrieves JSON data with automatic serialization and deserialization, now deprecated in favor of Django's native JSONField.
Provides Django ORM integration for PostgreSQL's COPY command to rapidly import and export delimited data without loading everything into memory.
Install it if bulk operations speed is a requirement; skip it if you only work with small datasets or non-PostgreSQL databases.
Snowflake CLI is a command-line tool for developers to create, manage, and deploy applications on Snowflake, including Streamlit apps, native apps, Snowpark services, and SQL operations.
Provides Python bindings to the Rust-based Delta Kernel for reading and processing Delta Lake tables through a thin wrapper built with maturin and pyo3.
Shillelagh lets you query APIs, files, spreadsheets, and in-memory objects using SQL, with support for multiple data sources through pluggable adapters and both programmatic and CLI interfaces.
Install it if you need SQL access to APIs, spreadsheets, or files; skip it if you're working exclusively with traditional SQL databases.
Integrates psycopg2 with coroutine libraries (eventlet, gevent) by registering wait callbacks that allow asynchronous database operations within a blocking interface.
Provides type stubs for sqlalchemy-utils, enabling static type checking and IDE autocompletion when using that library in Python projects.
However, be aware that maintenance is dormant (last release 823 days ago), type coverage is partial, and stubs may not reflect the latest sqlalchemy-utils API—verify…
Provides Entra ID (Azure Active Directory) authentication for redis-py clients connecting to Azure Managed Redis and Azure Cache for Redis services.
Provides programmable access to a database of 42,724 US zipcodes with census demographics, geography, housing, employment, and income data.
Suitable for reference applications, historical analysis, or prototyping; not for production systems requiring fresh demographic data.
Snowflake ML Python provides SDKs and infrastructure to build, train, manage, and deploy machine learning models directly within Snowflake, covering data preprocessing, feature engineering, model development, experiment tracking, and model registry.
Prevents migration downtime by detecting and terminating blocking queries during Postgres migrations, or optionally showing them for manual inspection.
Install it if migration locking is a pain point; skip it if you use other databases or have short, non-blocking migrations.
Encodes and decodes BSON (Binary JSON) data independently of MongoDB, and can serialize BSON objects over network sockets.
No—not recommended for new projects.
PyAirbyte lets you run Airbyte data connectors directly from Python code, extracting and loading data from hundreds of sources without needing the full Airbyte platform.
However, verify the license terms first—the metadata does not specify one—and be aware that the 37 runtime dependencies may add setup complexity in constrained…
psycopg-c is an optional C-compiled optimization package for Psycopg 3 that speeds up database operations by replacing pure-Python components with compiled extensions.
Simplifies SQLAlchemy code with helper functions for credential management, bulk insert/update/upsert operations, and ORM extensions that reduce boilerplate.
Python client library for SpiceDB that enables applications to query and manage permissions through Authzed's gRPC API, supporting both core permission checks and materialized view operations.
Install it if you're using Authzed/SpiceDB for authorization; skip it if you don't need that specific service.
Writes data in Singer format from Python, enabling standardized data pipeline integration compatible with PipelineWise.
Cacheout provides in-memory caching with multiple eviction strategies (FIFO, LIFO, LRU, MRU, LFU, RR), TTL support, memoization decorators, and thread safety for Python applications.
asyncmy is an asyncio-native MySQL/MariaDB driver providing fast asynchronous database access with an aiomysql-compatible API, built on an optimized protocol core.
Python client library for connecting to and querying Couchbase Server, a NoSQL database, with support for key-value operations, queries, and document management.
However, be aware of one known vulnerability (PYSEC-2023-235) that needs verification for this release, and plan for medium install friction on platforms without…
Provides a generic transaction management system for Python, handling commit/abort cycles, data manager coordination, and transaction hooks.
However, verify that ZPL-2.1 licensing is compatible with your project, and confirm that this package (primarily designed for ZODB) is the right fit for your use case…
A dbt adapter that enables data transformation workflows on AWS Athena, supporting table and incremental models, snapshots, Python models, and integration with Iceberg and Hive table formats.
Install it if you're building dbt workflows on AWS Athena; the low dependency footprint and permissive license make adoption straightforward.
HTTP-based Redis client for Python that connects to Upstash Redis via REST API instead of TCP, designed for serverless environments like AWS Lambda and Google Cloud Functions.
Install it if you're building on serverless platforms and need Redis caching or data structures; skip it if you have persistent TCP connectivity and prefer the lower…
dbt adapter that enables data transformation workflows on Vertica databases, connecting dbt projects to Vertica via the vertica-python client.
Generates BigQuery table schemas from complete JSON or CSV datasets by analyzing all records, rather than relying on BigQuery's auto-detection which examines only the first 500 records.
However, dormant maintenance (944 days since last release) and high install friction are concerns.
Tracks all changes to Django models using PostgreSQL triggers, storing a complete audit trail without modifying application code.
FalkorDB Python client for querying and managing graph databases using Cypher queries, with support for both synchronous and asynchronous operations.
Async cache framework with decorator and direct API support for in-memory, Redis, and DiskCache backends, including TTL management, cache invalidation, and optional client-side caching.
Provides secure, IAM-based connections to Google Cloud AlloyDB instances from Python applications using TLS 1.3 encryption and automatic credential management, with support for sync and async drivers.
Install it if you are connecting Python to AlloyDB and want automatic TLS, IAM-based auth, and credential lifecycle management without manual certificate handling.
Django-MySQL extends Django's ORM with MySQL and MariaDB-specific features including QuerySet optimizations, specialized model fields, MySQL functions, and database utilities not available in Django's generic database layer.
fastlite wraps sqlite-utils to provide interactive SQLite database access with auto-complete, convenient table/column navigation, and dataclass generation for Jupyter and IPython environments.
Yoyo-migrations is a database schema migration tool that lets you write and manage migrations as SQL files or Python scripts, with command-line tools to apply, rollback, and track dependencies across PostgreSQL, MySQL, and SQLite databases.
However, be aware that the package is dormant (no releases for 734 days), so consider whether you need active maintenance for compatibility with newer database…
Provides a Python interface for SQLite databases using APSW, with support for table creation, querying, filtering, transactions, and default value handling.
Piccolo is an async-first ORM and query builder for Python that supports both sync and async workflows, with built-in migrations, a playground, and admin interface.
A Python client library for building and executing queries against OpenSearch using a domain-specific language interface built on top of opensearch-py.
Provides a SQLAlchemy dialect that enables you to use SAP HANA as a database backend, translating SQLAlchemy ORM and SQL expressions into HANA-compatible SQL via the hdbcli driver.
dag-factory builds Apache Airflow DAGs declaratively from YAML configuration files, eliminating the need to write Python code for DAG construction.
Install it if you manage multiple similar Airflow workflows or want to let non-Python developers define DAGs; skip it only if your DAGs are highly custom or require…
RocksDict provides a Python interface to RocksDB and Speedb, enabling persistent key-value storage on disk with support for multiple data types including Python objects via serialization.
However, the aging maintenance status (256 days since last release) and lack of recent activity mean you should verify ongoing compatibility with your Python version…
Provides Apache Airflow operators and hooks to execute SQL queries and commands against ClickHouse using the native ClickHouse TCP protocol via clickhouse-driver.
Install it if you run Airflow >=2.3.0 with Python >=3.10 and need to query or load ClickHouse from DAGs.