Packages
DuckDB is an in-process SQL database engine that executes analytical queries on local and remote data files (CSV, Parquet, JSON) without requiring a separate server or external dependencies.
pymssql provides a Python DB-API interface to Microsoft SQL Server, built on FreeTDS, enabling standard database operations like connecting, querying, and retrieving results.
Install it if you need to connect Python to Microsoft SQL Server and prefer a lightweight, DB-API-compliant interface over heavier ORMs.
mysqlclient provides a Python interface to MySQL and MariaDB databases, enabling direct database connections and query execution from Python code.
SQLModel combines SQLAlchemy and Pydantic to let you define SQL database tables and rows as Python classes with type annotations, eliminating code duplication between ORM models and data validators.
TinyDB is a lightweight, pure-Python document database that stores JSON-like dictionaries to local files, with no external dependencies or server required.
Native Python client library for connecting to and querying Vertica databases, implementing the DB-API v2.0 standard.
However, the aging maintenance status suggests it may not receive timely updates for new Vertica features or Python versions—verify compatibility with your specific…
Provides a Python binding to LMDB (Lightning Memory-Mapped Database), a fast key-value store based on memory-mapped files for efficient data access and storage.
pyngrok wraps the ngrok reverse-proxy binary and exposes it through a Python API, allowing you to programmatically open secure tunnels from public URLs to localhost.
Plyvel is a Python interface to LevelDB, a fast key-value storage library. It provides read and write access to LevelDB databases with a Pythonic API.
Gdbmongo provides GDB pretty printers and commands for inspecting MongoDB Server internals in live processes and core dumps, with support for multiple MongoDB versions.
A drop-in replacement for Python's sqlite3 module that bundles sqlean extensions, adding cryptography, fuzzy matching, statistics, regex, file I/O, and other SQL functions directly into SQLite.
However, the abandoned repository status means you should not rely on it for long-term production systems expecting active maintenance or future Python compatibility…
Compares rows across two SQL databases or datasets to identify differences, available as both a command-line tool and Python library.
However, the abandoned status and archived upstream repository mean you should verify that the fork is actively maintained by the current publisher and plan for…
Provides a self-contained SQLite database driver for Python that can be installed separately from the standard library, with support for modern SQLite features and the option to use either bundled or system SQLite.
However, note that the maintainer is directing new development elsewhere, so consider whether that project better suits your long-term needs.
Prisma Client Python is a type-safe ORM that generates a fully typed database client from a schema file, supporting both synchronous and asynchronous access to PostgreSQL, MySQL, SQLite, CockroachDB, and experimental MongoDB and SQL Server.
However, the repository is archived and abandoned—install only if you are maintaining an existing project or willing to fork and maintain it yourself.
dbt adapter that enables data transformation workflows on Vertica databases, connecting dbt projects to Vertica via the vertica-python client.
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.
USearch provides approximate nearest-neighbor vector search using HNSW indexing, supporting custom metrics, multiple data types, and on-disk index serving without loading into RAM.
pysqlite3 packages SQLite as a standalone Python module, letting you use a specific SQLite version independently of the system library or Python's bundled sqlite3.
Install only if you have a concrete reason—the standard library module is sufficient for most applications.
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…
Memori is a Python SDK that automatically captures and recalls structured memory from LLM interactions and agent conversations, persisting context across sessions without requiring code changes to existing LLM calls.
pymonetdb is a native Python client library for MonetDB databases, providing DBAPI 2.0-compatible access without requiring any MonetDB system libraries.
Install it if you need to connect Python to MonetDB; the low friction and stable maintenance make it a straightforward choice.
Pyoxigraph is a Python library that provides in-memory and disk-based graph databases with SPARQL 1.1 query support, plus utilities for reading and writing RDF data in multiple formats including JSON-LD, Turtle, TriG, N-Triples, N-Quads, and RDF/XML.
However, it is classified as Alpha, so production use should account for potential API changes.
ArcticDB is a serverless DataFrame database that stores and retrieves Pandas DataFrames to S3 or LMDB with a C++ compression engine, supporting time-series data, versioning, and schemaless updates.
However, production deployments require a paid license from ArcticDB Limited; confirm licensing terms with info@arcticdb.io before committing to production use.
Provides access to archived versions of the py2neo Neo4j client library, allowing projects pinned to older releases to continue working when those versions are no longer available on PyPI.
sqlcipher3 is a Python DB-API 2.0 interface to SQLCipher, providing encrypted SQLite database access with features like user-defined window functions, incremental BLOB I/O, and native backup support.
Official Python client for SurrealDB, supporting both remote (WebSocket/HTTP) and embedded (in-memory or file-based) database connections with synchronous and asynchronous APIs.
However, verify the license terms before use—the metadata does not specify a license, which is a blocker for some projects.
Adds CreateView and DropView SQL constructs to SQLAlchemy, enabling programmatic creation and removal of database views through SQLAlchemy's expression language.
MySQL-python provides a Python 2 interface to MySQL databases, implementing the Python Database API specification for executing queries and managing connections.
Python client library for the Rockset API, enabling programmatic creation, management, and querying of Rockset resources.
A Python DB-API 2.0 interface to SQLCipher, providing encrypted SQLite database access with a self-contained binary wheel requiring no external dependencies.
However, verify platform support matches your target (wheels shown are Linux x86_64 only), and note the package is aging—last release was 226 days ago.
Implements Bloom filters—space-efficient probabilistic data structures for fast set membership testing with controllable false positive rates and no false negatives.
Install only if your use case genuinely benefits from Bloom filter semantics; for simple set membership in memory-unconstrained applications, a plain Python set is…
Provides a Python DB-API 2.0 interface to SQLCipher, enabling encrypted SQLite database operations with a familiar sqlite3-like API.
However, the aging maintenance status (219 days since last release, 34 stars) suggests evaluating alternatives for new projects.
Voyager performs fast approximate nearest-neighbor searches on in-memory vector collections using the HNSW algorithm, enabling efficient similarity queries on embedding data.
Install it if you need fast vector similarity queries on embeddings; the medium install friction is offset by broad platform coverage and proven scale at Spotify.
Provides an in-memory MongoDB instance for testing by wrapping pymongo's MongoClient, eliminating the need for a running MongoDB server during development and test runs.
DocArray provides a Python data structure for representing, transmitting, storing, and retrieving multimodal data, with built-in support for tensors from NumPy, PyTorch, TensorFlow, and JAX.
Synchronize database schemas and bulk-load data using Python dataclasses and async SQL generation, supporting PostgreSQL, MySQL, and other dialects.
Jina is a framework for building and deploying AI services that communicate via gRPC, HTTP, and WebSockets, with built-in support for scaling, containerization, and cloud deployment.
Not recommended if you prefer minimal dependencies or need cutting-edge feature velocity.
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.