Subcategories
Packages
pgcli is a command-line interface for PostgreSQL that provides auto-completion for SQL keywords, table and column names, and syntax highlighting as you type.
Install it if you regularly work with PostgreSQL from the command line and value auto-completion and syntax highlighting.
Pony is an object-relational mapper that lets you write database queries using Python generator expressions and lambdas, which it translates to SQL for SQLite, MySQL, PostgreSQL, and Oracle.
Tortoise ORM is an async-native Object-Relational Mapper for Python that lets you define and query databases using high-level object-oriented code instead of raw SQL, with support for SQLite, MySQL, PostgreSQL, Microsoft SQL Server, and Oracle.
Install it if you are building async applications and prefer ORM abstraction over raw SQL; skip it if you need synchronous database access or prefer a different query…
aiopg provides asyncio-based access to PostgreSQL databases, wrapping psycopg2 to enable non-blocking queries and connection pooling in async Python applications.
However, the aging maintenance status (last release October 2022) means it may lag behind recent PostgreSQL or asyncio changes.
Disk-backed cache library that stores key-value pairs on disk and in files, providing a pure-Python alternative to in-memory caching systems like Memcached.
Generates parameterized SQL queries from Jinja2 templates, automatically binding variables to prevent SQL injection while supporting multiple parameter styles.
Not recommended if you require active maintenance, ongoing security updates, or support for cutting-edge Python versions—use an ORM or a maintained query builder…
Provides an asynchronous client for SQLite that works with any async framework via AnyIO, enabling non-blocking database access without thread pools.
A Python client library for NocoDB that provides CRUD operations, bulk operations, file management, and advanced querying against NocoDB REST API with support for both v2 and v3 API versions.
SQLMesh is a data transformation framework that lets you write, test, and deploy SQL or Python transformations with built-in change tracking, incremental processing, and virtual development environments.
Provides a SQLAlchemy dialect for connecting to and querying Trino databases, enabling ORM and SQL expression support for Trino as a backend.
sqloxide parses SQL queries into a typed abstract syntax tree (AST) using Rust bindings for sqlparser-rs, and can reconstruct or rewrite SQL from the AST.
Install it if you need fast, accurate SQL parsing for lineage, rewriting, or analysis; skip it only if you need extensive documentation or are locked to older Python…
Generates SQL queries programmatically for Tortoise ORM, providing a streamlined SQL builder tailored to that ORM's specific needs.
This package is deprecated as of v0.17.0; it provides a client for Databricks Feature Store but has been replaced by databricks-feature-engineering, which maintains backward compatibility with existing imports.
Manages Azure Kusto clusters, databases, and data connections through the Azure REST API, providing programmatic control over Kusto resources in Python.
Install it if you need to programmatically manage Kusto resources from Python.
HTTP client library for connecting to a Chroma server to store, query, and manage document embeddings and metadata.
geoh5py provides a Python API to read, write, and manipulate geoscientific data (points, curves, surfaces, grids) in the geoh5 file format, enabling interoperability with Geoscience ANALYST visualization software.
Install it if you work with geoh5 data or need to integrate geoscientific datasets with Geoscience ANALYST.
Whisper is a fixed-size time-series database library that stores numeric data at multiple resolutions, degrading older data from high to low resolution for long-term retention.
No, not recommended for new projects.
Provides persistent storage backends for pycrdt, a CRDT (Conflict-free Replicated Data Type) library, enabling state to be saved and retrieved across sessions.
However, verify that its storage model and API match your persistence requirements before committing to it in production, as it is still in Beta and documentation is…
Provides a DBAPI 2.0-compatible Python interface to Apache Arrow Flight SQL databases via the ADBC driver manager.
DiscoverX automates bulk administration tasks across Lakehouse assets by executing SQL templates or Python functions concurrently against multiple Delta tables matching selection patterns.
However, verify the license terms and test compatibility with your current Databricks and Python versions before production use, and understand that support is…
PgSanity validates PostgreSQL SQL syntax by wrapping the ecpg parser, reporting syntax errors with line numbers and exit codes suitable for CI/CD and pre-commit hooks.
A compatibility shim that re-exports the Migrations class from sqlite-utils so existing code can continue importing from sqlite_migrate instead of directly from sqlite-utils.
Integrates PostgreSQL with pgvector extension as a vector store backend for LlamaIndex, supporting multiple query modes including similarity search, hybrid retrieval, BM25 sparse search, full-text search, and maximal marginal relevance.
OpenMetadata Ingestion is a framework for building connectors and ingesting metadata from various systems into OpenMetadata via its APIs, typically integrated into orchestration tools like Apache Airflow.
However, be aware of the Collate Community License restrictions: you cannot use it to offer competing metadata management services.
Bundles PostgreSQL connectivity and schema support for the tentaclio data access framework, providing a ready-to-use PostgreSQL backend.
schemachange is a Python tool that manages Snowflake database schema changes through versioned SQL migration scripts, following an imperative database change management approach similar to Flyway.
Provides platform-specific Microsoft ODBC Driver 18 binaries for SQL Server connectivity as an internal implementation package.
Provides PEP 561 type stubs for SQLAlchemy, enabling type checkers like mypy, pyright, and pytype to validate code using SQLAlchemy.
rapids-logger provides a CMake-based framework to generate project-specific logger classes that wrap spdlog without exposing its symbols, enabling safe coexistence of different spdlog versions in the same environment.
Pulumi resource provider for declaring and managing PostgreSQL databases, users, roles, and other database objects as infrastructure code.
Install only if you have Pulumi CLI set up and a PostgreSQL server you can connect to.
Python client library for connecting to and querying Aerospike NoSQL database servers, supporting read, write, and data manipulation operations.
Connects Python notebooks to Power BI datasets and Microsoft Fabric workspaces, enabling data augmentation with Power BI measures and semantic propagation for data analysis.
However, the proprietary license and hard requirement to run only in Fabric (not locally) mean this is a specialized tool for Fabric users only—not a general-purpose…
libcudf-cu12 is a GPU-accelerated C++ library providing Apache Arrow-compliant data structures and fundamental algorithms for tabular data processing on NVIDIA CUDA 12 GPUs.
Provides a SQLAlchemy dialect that connects to Databricks workspaces and SQL analytics clusters using the official databricks-sql-connector driver.
oslo.db provides database connectivity and ORM utilities for OpenStack applications, abstracting backend differences and offering migration, session management, and database helper functions.
Install only if you need its specific patterns; it is not a general-purpose ORM replacement.
pylibmc is a Python client for memcached, the distributed memory-caching system, implemented in C for performance.
However, the aging maintenance status (last release 2022-08-30) means you should verify compatibility with your Python version and memcached deployment before…
Provides async operators and sensors for Apache Airflow that integrate Fivetran data pipeline jobs, allowing you to trigger syncs and monitor their completion without blocking worker slots.
Install it if you run apache-airflow and use Fivetran for data ingestion and need to orchestrate those pipelines reliably without blocking worker capacity.
Reads MySQL binary logs and streams replication events (inserts, updates, deletes) with their data and raw SQL queries to Python, enabling real-time capture of database changes.
Install it if you need to react to MySQL changes in real time; skip it if your use case does not require streaming binary log events or if you are not using MySQL.
Advanced Alchemy provides sync and async SQLAlchemy repositories with CRUD and bulk operations, plus integration with web frameworks like Litestar, FastAPI, and Starlette.
Install it if you're building a data-driven web application and want structured, tested patterns for database access; skip it if you prefer minimal abstractions over…
PyVO provides Python access to Virtual Observatory data archives, catalogs, and web services using standardized VO protocols, leveraging astropy and requests to query thousands of remote astronomical resources.