Subcategories
Packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
PyMongo is the official MongoDB Python driver, providing synchronous and asynchronous APIs for querying, inserting, updating, and managing MongoDB databases from Python applications.
Install it if you need to connect Python to MongoDB.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
dbt-core transforms raw data in a warehouse using SQL select statements organized as models, handling compilation, testing, and dependency management across data transformation projects.
Install it if you need to build SQL-based data transformations with testing and documentation; you will also need to install a warehouse-specific adapter…
Provides compiled C optimizations for the PostgreSQL database adapter, accelerating database operations when installed as an optional component.
Snowpark Python provides APIs to query and process data directly in Snowflake without moving data to your local system, with support for both native Snowpark and pandas-compatible interfaces.
Install it if you use Snowflake and want to process data without moving it to your application layer.
PyMySQL is a pure-Python MySQL and MariaDB client library that implements the DB-API 2.0 standard, enabling Python applications to connect to and query MySQL or MariaDB databases without compiled extensions.
Install it if you are building a Python application that must connect to MySQL or MariaDB and prefer or require a pure-Python driver.
Provides an async-only, pluggable key-value store abstraction with support for multiple backends and automatic TTL handling.
xlrd reads data and formatting information from legacy Excel .xls files, extracting cell values, sheet metadata, and formula results without support for newer formats or advanced features like macros, charts, or password protection.
However, note that it is aging (last release 426 days ago) and does not support newer Excel formats—if you work primarily with .xlsx or .xlsm files, look elsewhere.
AWS SDK for pandas integrates pandas DataFrames with AWS data services—S3, Athena, Redshift, DynamoDB, Timestream, and others—enabling direct read/write operations without manual API calls.
Install it if you work with pandas and AWS data services—it eliminates boilerplate and integrates naturally into existing pandas workflows.
SQLGlot parses, transpiles, optimizes, and analyzes SQL across over 30 dialects without external dependencies, enabling format conversion and semantic analysis of queries.
Snowflake SQLAlchemy is a SQLAlchemy dialect that enables SQLAlchemy applications to connect to and query Snowflake databases using standard SQLAlchemy ORM and Core APIs.
Install it if you are building a Python application that needs to connect to Snowflake and prefer SQLAlchemy's abstraction layer over raw SQL or the connector API.
PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling thread-safe connections, cursors, and SQL execution with native support for PostgreSQL data types.
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.
Peewee is a lightweight ORM that maps Python classes to database tables and provides a query builder for SQLite, MySQL, MariaDB, and PostgreSQL, with optional asyncio support.
Provides low-level Python bindings for CUDA host APIs, offering 1:1 access to CUDA functionality from Python code.
MySQL Connector/Python is a PEP 249-compliant database driver that enables Python programs to connect to and query MySQL databases using a standard API.
h5py reads and writes HDF5 files from Python, providing both low-level API access and high-level interfaces that map HDF5 datasets and groups to NumPy arrays and Python data structures.
Install it if you work with scientific data, need portable binary storage, or must interoperate with HDF5 files from other tools or languages.
pyodbc provides Python access to ODBC databases through a DB API 2.0-compliant interface, supporting SQL Server, Access, and other ODBC-compatible data sources.
Install only if ODBC infrastructure is confirmed available; otherwise, consider a native database driver for your specific database.
DiskCache provides a pure-Python disk-backed cache library that stores key-value pairs using SQLite and the filesystem, offering an alternative to in-memory caching systems like Memcached or Redis.
However, two known vulnerabilities are flagged in the security record—verify whether they affect version 5.6.3 or your use case before deploying to production.
PyIceberg provides programmatic access to Apache Iceberg table metadata and data, implementing the Iceberg table specification in Python for reading and writing Iceberg-format datasets.
Provides stemming algorithms for 34 languages, reducing word variants to a common stem for text search and indexing applications.
Install it if you need stemming for search or text indexing.
Adds vector storage and similarity search support to PostgreSQL through Python ORMs and database drivers, enabling semantic search and embeddings workflows.
Install it if you need vector search in PostgreSQL from Python—it's the standard bridge between pgvector and popular ORMs.
Provides a connection pool for Psycopg 3, managing reusable PostgreSQL database connections to reduce overhead and improve performance in applications that make frequent database queries.
A Python database driver for ClickHouse that supports DataFrames, arrays, and query execution through HTTP, with optional SQLAlchemy and async support.
Deltalake provides native Python bindings to Delta Lake, enabling you to read, write, and manage Delta tables with Pandas integration and OpenTelemetry tracing support.
A Python driver for connecting to Oracle Database directly, conforming to the Python Database API 2.0 specification with support for both thin mode (direct connection) and thick mode (with optional Oracle Client libraries).
Python client library for Azure Cosmos DB SQL API that manages databases, containers, and JSON documents with SQL-like query support.
Install it if you are building applications on Azure Cosmos DB SQL API and need a native Python client.
Partd is a key-value byte store that appends values to existing keys and retrieves them, with support for multiple backends (in-memory, file-based, buffered, or remote) and optional compression or encoding layers.
However, dormant maintenance (last release May 2024, minimal recent activity) means it is best suited to stable, well-tested scenarios rather than active feature…
Python client library for Qdrant vector search engine, supporting both local in-memory and remote server modes with sync and async APIs.
Install it if you need to integrate vector search into a Python application—whether for prototyping locally or connecting to a production Qdrant deployment.
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.
Query and interact with Microsoft Azure Kusto clusters from Python using a DB API-compatible interface, with support for both synchronous and asynchronous clients.
Install it if you need to query Kusto clusters from Python; skip it only if you have no Kusto infrastructure or prefer a different query interface.
CacheLib provides a unified API for interacting with multiple cache backends—Redis, Memcached, MongoDB, DynamoDB, file system, in-memory, uWSGI, and Valkey—so you can swap implementations without changing application code.
Install it if you need flexible caching or plan to support multiple backends.