Packages
Reads Excel files (.xlsx, .xls) into Python with zero-copy data exchange via the Arrow PyCapsule Interface, enabling direct use with compatible libraries without intermediate conversions.
Ibis is a portable Python dataframe library that compiles dataframe expressions into SQL or native operations, letting you use a single API across more than 20 backends.
Install it if you work with multiple data backends or want to avoid vendor lock-in; skip it if you're committed to a single backend and don't need portability.
SQLAlchemy dialect for Apache Drill that enables SQL queries against Drill data sources via REST, JDBC, or ODBC connections.
APSW is a Python wrapper around SQLite's complete C API, providing access to advanced SQLite features like full-text search, virtual tables, VFS, JSON support, and async framework integration.
A dbt adapter that enables data transformation and testing workflows on ClickHouse, supporting table, view, incremental, and materialized view materializations with ClickHouse-specific configurations.
Install it if you use ClickHouse and want to adopt dbt for data transformation.
A Python driver for connecting to and querying Microsoft SQL Server, Azure SQL, and SQL databases in Fabric, using a direct C++ backend (DDBC) instead of platform-specific driver managers.
However, verify the license terms before production use, as the license treatment is currently unclear.
A dbt adapter that connects dbt-core to Microsoft Fabric Synapse Data Warehouse, enabling data transformation and modeling workflows on Fabric.
Install only if you have a Fabric warehouse and dbt-core 1.4 or newer; it is not useful as a standalone tool.
Extends Microsoft Fabric's Semantic Link with utilities for managing Power BI semantic models, reports, and capacities programmatically within Jupyter notebooks.
However, its utility is narrowly scoped to the Fabric environment; it is not a general-purpose Power BI tool and requires Python 3.10 or later.
A SQLAlchemy driver that enables you to use DuckDB as a database backend, allowing standard SQLAlchemy ORM and SQL operations against DuckDB instances.
Python client library and SQLAlchemy dialect for querying Apache Kylin OLAP engines using SQL from Python applications and BI tools.
Provides a dict-like interface to SQLite databases, allowing you to store and retrieve Python objects persistently with multi-threaded access support.
A Python client for Apache Atlas REST API v2 that provides lazy-loaded access to metadata entities, classifications, and search operations without requiring direct knowledge of underlying REST endpoints.
aioodbc provides async/await access to ODBC databases by wrapping pyodbc with asyncio support, using threads internally to avoid blocking the event loop.
However, if you require active maintenance or are starting a new greenfield project, consider whether a more actively maintained async driver for your specific…
Provides DBAPI (PEP-249) and SQLAlchemy dialect access to Elasticsearch and OpenSearch clusters via SQL, enabling read-only queries against these search engines.
Install it if you need to query Elasticsearch/OpenSearch via SQL or SQLAlchemy; skip it only if you prefer native query DSLs or have no Elasticsearch infrastructure.
GraphFrames Python wrapper provides graph processing and analysis on Apache Spark, enabling operations like centrality metrics, motif finding, community detection, and traversals on distributed graph data.
The main gotcha is the external JVM dependency—you cannot use this package standalone; it requires a working Spark environment.
Python client library for Typesense search engine, providing both synchronous and asynchronous APIs to query, index, and manage search collections.
Install it if you are already running a Typesense server and need a Python client to interact with it; it is not useful without a Typesense instance to connect to.
dbt-athena is a dbt adapter that enables data transformation workflows to run against Amazon Athena, supporting table and incremental models, snapshots, and Python models on Hive and Iceberg table formats.
Install it if you use dbt and need to transform data in Athena.
Provides a rich JSON editor widget for Django's admin interface and forms, enabling visual editing of JSONField data with syntax highlighting and validation.
Weave is a toolkit for tracing, logging, and evaluating generative AI applications, letting you instrument functions to capture inputs, outputs, and execution traces for debugging and analysis.
Unofficial Python client for Notion.so API v3 that maps Notion database tables to Python classes, enabling object-oriented read/write access to Notion pages, blocks, and collections.
However, be aware that automatic Notion-to-Python updates are disabled and require manual refresh() calls, and the underlying Notion API v3 is undocumented and…
A SQLAlchemy dialect that enables ORM and SQL toolkit access to CockroachDB databases, supporting both synchronous and asynchronous connections through multiple database drivers.
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.
Python client library for the Meilisearch API, enabling document indexing, full-text search with typo tolerance, and semantic search capabilities against a Meilisearch server.
Install it if you are already running a Meilisearch server and need a straightforward Python client for indexing and search.
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.
Provides a SQLAlchemy dialect for connecting to Microsoft SQL Server via the TDS protocol using python-tds as the underlying driver.
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.
A dbt adapter that connects dbt projects to Trino, enabling SQL-based data transformations across multiple federated data sources through a single connection.
Install it if your data architecture relies on query federation; skip it if you work with a single warehouse or don't use dbt.
DjangoQL provides an advanced search query language for Django models with auto-completion, supporting logical operators, field joins, and complex filtering through a Python-like syntax.
However, the aging status (199 days since last release) means you should verify compatibility with your specific Django version before adopting.
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…
Adds ordering and reordering capabilities to Django models, with methods to move instances up, down, to specific positions, or relative to other instances, plus admin UI support.
However, verify compatibility with your Django version since the last release was 2023-03-17 and no updates are planned.
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.
Maggma provides a unified interface for building data processing pipelines that read from and write to diverse storage backends—MongoDB, S3, local files, and others—using a consistent query syntax and modular Builder components for transformation.
Install it if you're building multi-stage data processing that needs to work across heterogeneous storage systems or if you want to parallelize transformations cleanly.
Executes PostgreSQL meta-commands (backslash commands) programmatically through a Python API, enabling applications to run special commands on a database connection.
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.
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.
PyDynamoDB is a DB API 2.0 client for Amazon DynamoDB that executes SQL-like queries (PartiQL for DML, MySQL-like syntax for DDL) against DynamoDB tables and provides a SQLAlchemy dialect.
PyAthenaJDBC wraps the Amazon Athena JDBC driver to provide a Python DB API 2.0 (PEP 249) interface for querying Amazon Athena from Python.
No—not for new projects.
Provides a SQLAlchemy dialect for connecting to and querying Trino databases, enabling ORM and SQL expression support for Trino as a backend.
Piccolo Admin is a web-based admin interface and content management system for Python applications, built on Piccolo ORM and ASGI, providing data management, filtering, media handling, and REST API capabilities.
Install it if you're using Piccolo ORM and need a modern, feature-rich admin UI, or if you want a self-contained CMS for ASGI applications.