Subcategories
Packages
Anonymizes Django model data in place using bulk operations, replacing sensitive fields with fake or static values to create safe development copies of production databases.
Provides an asynchronous SQLAlchemy adapter for PyCasbin, enabling policy-based access control rules to be loaded from and persisted to databases like PostgreSQL, MySQL, SQLite, Oracle, and others.
Install it if you need to persist Casbin policies in a database and are already using async SQLAlchemy; it is the standard adapter for that use case.
pymgclient is a Python adapter for Memgraph graph database, implementing the DB-API 2.0 specification to enable query execution and result fetching through a standard cursor interface.
pypgstac provides Python bindings and utilities for managing Spatio-Temporal Asset Catalog (STAC) data in PostgreSQL, including search, filtering, and schema management functions.
Provides AWS CDK constructs for defining and managing Amazon Neptune graph database clusters and instances in infrastructure-as-code Python.
Async MySQL database driver for Python asyncio applications, providing a non-blocking interface to MySQL and MariaDB servers.
However, the 381-day gap since the last release and aging maintenance status suggest it may not receive prompt updates for new MySQL/MariaDB features or Python versions.
A Python client library for connecting to and querying NebulaGraph v3 databases, supporting session pooling, parameterized queries, and result extraction for visualization.
Bundles Redis modules into distributable packages with metadata, similar to npm init for Node.js packages.
Install only if you actually need to package Redis modules; it is not a general-purpose tool.
A deprecated MCP server that previously integrated Snowflake Cortex AI services (Search, Analyst, Agent), object management, and SQL execution into the Model Context Protocol—no longer maintained; users should migrate to the official Snowflake MCP Server.
RLTest is a test framework for Redis and Redis modules that lets you write tests once and run them across multiple deployment environments (OSS, OSS cluster, enterprise, enterprise cluster) without rewriting test code.
mycli is a command-line client for MySQL and compatible databases (MariaDB, Percona, TiDB, Apache Doris) that provides auto-completion, syntax highlighting, and interactive query features.
Upserts pandas DataFrames into PostgreSQL, MySQL, and SQLite databases using primary or unique keys, with optional automatic table and schema creation.
Provides a Python client library for interacting with Azure Cognitive Search, enabling you to query and manage search indexes in Azure.
However, the beta status (1.0.0b2) and absence of releases since January 2021 raise questions about production readiness and whether newer stable alternatives exist…
Compares database schemas across two SQLAlchemy-connected databases, reporting structural differences in tables, columns, keys, indexes, constraints, and enums.
Shared provides a simple file-based data persistence layer that encodes Python dictionaries (including strings, scalars, dates, binary data, and nested collections) into human-readable files using the Paradict format.
Shiboken2 provides Python access to metadata and utilities for C++/Python bindings, letting you inspect binding validity and debug wrapper state after C++ object destruction.
pymetastore is a Python client for the Hive Metastore that provides a Thrift-based interface to query and manage metadata about databases, tables, and partitions in a Hive metastore service.
Provides a JSONField for Django models that stores JSON-encodable objects in the database and deserializes them on retrieval.
fudgeo creates and manages OGC GeoPackages—SQLite-based geospatial databases—allowing you to read and write geometries and attributes using Python objects and standard SQL syntax.
Install it if you need to create or manage GeoPackages programmatically in Python and prefer a lightweight, SQL-native approach over heavier GIS libraries.
Prevents Django database write operations by intercepting and blocking data modification queries, with the ability to selectively re-enable writes within a session.
Converts graphic-walker workflow definitions into SQL queries by parsing a DSL payload and generating executable SQL for the specified table.
However, maintenance is dormant (last release 2024-07-31), so verify that the DSL subset and SQL generation match your use case before committing to a dependency on it.
ingestr is a command-line tool that copies data from any source (databases, APIs, files) to any destination without writing code, supporting incremental loading modes like append, merge, and delete+insert.
The main gotcha is the Python 3.10+ requirement and the binary download on first SDK use.
Provides database backend implementations for ASE, supporting PostgreSQL, MySQL, and LMDB for storing and retrieving atomic structure data.
However, verify the license terms first, and be aware that the package is aging—last release was 275 days ago—so check whether it still supports your target database…
Provides type annotations for the peewee ORM library, enabling type checkers like mypy and pyright to validate code that uses peewee.
py-pglite provides a zero-config PostgreSQL testing environment for Python by wrapping PGlite, letting you run real PostgreSQL queries in tests without Docker or server setup.
Provides automatically generated Pydantic models for type-safe configuration and record handling across all Airbyte connectors, with nightly updates to stay synchronized with connector specifications.
Install it if you use Airbyte connectors in Python and want IDE support and static type checking; note that record models are marked as planned functionality, so…
Dask-ML provides distributed and parallel machine learning by integrating Dask with scikit-learn, XGBoost, and other ML libraries to scale training and inference across clusters.
However, note the aging maintenance status—last release was February 2025—so verify that the version meets your stability and security requirements before adopting in…
A Python client for the Definite API that provides key-value storage, SQL query execution, secrets management, messaging, and dlt pipeline integration with state persistence.
Python SDK for connecting to and querying libSQL databases, supporting both local SQLite files and remote libSQL servers via WebSockets or HTTP.
A command-line module for the Azure CLI that provides SQL database and server management commands, including operations on managed instances, elastic pools, databases, and data warehouses.
However, note that the latest release dates to 2019 and targets Python 2.7–3.6; verify compatibility with your current Azure CLI version and Python environment before…
Python client library for iRODS, a distributed data management system, enabling connections, authentication, queries, and management of collections, data objects, metadata, users, and resources.
Install it if you are building applications that must integrate with iRODS for data management or administration.
Provides a PyArrow filesystem interface for reading and writing Parquet datasets directly from Azure Data Lake Gen2 storage without local copying.
Emits telemetry data from Python UDFs, UDTFs, and Stored Procedures running in Snowflake, using the OpenTelemetry API and SDK.
Install only if you're already using Snowflake's Python compute—it has no value outside that context.
pyobvector is a Python SDK for OceanBase Vector Store that provides vector similarity search, full-text search, and JSON table operations through SQLAlchemy or a Milvus-compatible API.
Not recommended if you need a standalone vector database—pyobvector is a client for OceanBase, not a replacement for it.
vecs is a Python client for storing, indexing, and querying vectors in PostgreSQL using the pgvector extension, enabling semantic search and similarity operations on vector data.
However, the aging maintenance status (last commit 2025-04-09, no releases since 2024-12-13) and high install friction (requires external database setup) mean this is…
Official Python client for Dgraph, a distributed graph database, providing gRPC-based access to query, mutate, and manage graph data with transaction support.
Install only if you have a Dgraph cluster available and your use case aligns with graph database patterns; it is not useful as a standalone library.
ODMantic is an async-first Object Document Mapper for MongoDB that lets you define database models using Python type hints and Pydantic validation, then query and persist them with a functional API.
Install it if you need an async MongoDB ODM with strong type safety and Pydantic integration.
Flask-Alembic integrates Alembic database migrations into Flask applications, providing CLI commands and Python APIs to create, manage, and apply schema changes without writing raw SQL or configuration files.
CIRISPersist provides unified, versioned storage for CIRIS federation nodes—handling signed event logs, audit trails, memory graphs, secrets, and telemetry—via a single Python API backed by Postgres or SQLite.
Provides Protocol Buffer definitions and gRPC bindings for the Google Cloud Datastore API, enabling typed client communication with Google's datastore service.