Packages
Provides a SQLAlchemy dialect and Alembic integration for connecting Python applications to StarRocks, a real-time analytics database platform.
Install it if you need to connect a Python application to StarRocks; the low friction and permissive license make it a straightforward choice.
Jobflow is a Python library for defining and executing computational workflows as directed acyclic graphs of jobs, with support for local execution and integration with workflow managers like jobflow-remote and FireWorks.
PyApacheAtlas provides a Python SDK and Excel integration for programmatic and low-code interaction with Azure Purview and Apache Atlas APIs, supporting entity management, lineage definition, type definitions, and classifications.
However, be aware that maintenance is dormant—no updates since late 2023—so evaluate whether the current API compatibility matches your target system versions and…
Pottery provides Python dict, set, list, deque, queue, and counter interfaces backed by Redis, letting you use familiar Python collection syntax to read and write data persisted in Redis.
Tika-python provides Python access to Apache Tika's document parsing, metadata extraction, MIME type detection, and language identification through a REST server interface.
Python SDK for interacting with Cognite Data Fusion (CDF), a cloud-based industrial data platform, with support for both synchronous and asynchronous API operations.
Install it if you need to access CDF from Python; skip it only if you do not use Cognite's platform.
Official Python SDK for Atlan, providing programmatic access to metadata management, asset operations, and data governance features through a typed client interface.
Install it if you need to interact with Atlan's metadata platform from Python or automate data governance workflows.
Indexes Django model instances into Elasticsearch and keeps them synchronized, providing a thin wrapper around elasticsearch-py for querying and managing search indices.
However, verify that your Elasticsearch server version matches the library's major version, and check recent commits to confirm the package still meets your needs…
Python client for querying and managing datasets in the Data Bookkeeping Service 3 (DBS3), a CMS experiment event data catalog that tracks datasets, processing history, files, and runs via REST API.
teradataml provides Python access to analytic functions running on Teradata Vantage, enabling data analysis, machine learning, and data transformation without writing SQL.
However, verify the Teradata License Agreement terms for your use case first, and confirm that optional dependencies (scikit-learn, lightgbm) are available if you…
SQLAlchemy dialect adapter that enables Python applications to connect to and query IBM DB2 databases using SQLAlchemy's ORM and query interface.
Install it if you need SQLAlchemy ORM support for IBM DB2 databases.
Provides a SQLAlchemy dialect that connects to Databricks workspaces and SQL analytics clusters using the official databricks-sql-connector driver.
Django database backend that connects Django applications to Microsoft SQL Server, Azure SQL, and SQL Database in Microsoft Fabric via pyodbc and ODBC drivers.
Install it if you need Django to connect to SQL Server, Azure SQL, or Microsoft Fabric SQL Database.
Django Solo provides a base model class and admin interface for enforcing single-instance (singleton) database tables in Django applications, with optional caching support.
However, the aging maintenance status (225 days since last release) and unclear CC-BY-3.0 license classification warrant verification before production use.
Adds SQL magic commands to IPython and Jupyter notebooks, letting you query databases directly from cells using SQLAlchemy connection strings.
However, the dormant maintenance status (last release over a year ago, Alpha classification) means you should verify compatibility with your Python and IPython…
Bundles dbt-core and MetricFlow with compatible versioning, allowing you to execute semantic layer commands through a single unified installation instead of managing separate packages.
PyGreSQL is a Python interface to PostgreSQL databases that wraps the libpq C API, allowing direct database connections and queries from Python code.
Dash Cytoscape wraps Cytoscape.js to let you build interactive network graphs and visualizations in Python Dash applications.
Install it if you need network visualization in Dash and can tolerate a frozen feature set and potential compatibility drift with future Dash versions.
Python client for Upstash Vector, a serverless vector database—upserts and queries vectors with optional metadata and data fields, supporting dense, sparse, and hybrid index types.
However, the aging maintenance status (533 days since last release) and Alpha classification warrant caution for mission-critical production systems; verify that your…
TM1py provides Python bindings to IBM Planning Analytics (TM1), enabling read/write operations on cubes, dimensions, and hierarchies, plus execution of TI processes and MDX queries.
Install it if you need to automate TM1 workflows or integrate TM1 data into Python applications.
Detects and returns the active theme (light or dark) of a running Streamlit app, updating dynamically when the user changes the theme.
However, the 833-day maintenance gap means no recent bug fixes or Streamlit version updates—verify compatibility with your Streamlit version before relying on it in…
A Python client library for interacting with CouchDB databases, providing document CRUD operations, design document management, object-to-document mapping, and command-line tools for database administration.
Firebolt-sdk provides a Python DB API 2.0-compatible interface to connect to and query Firebolt databases, handling authentication, connection management, and result retrieval.
Install it if you are working with Firebolt; the only caveat is to respect the cursor thread-safety constraint in multi-threaded code.
Provides a SQLAlchemy dialect to query Dremio data warehouses via Flight and ODBC interfaces, enabling SQL-based access to Dremio within Python applications.
Python SDK for publishing and receiving messages through Upstash QStash, an HTTP-based messaging and scheduling service for serverless and edge runtimes.
Provides a lightweight abstraction layer over psycopg2 for PostgreSQL database access, simplifying common query patterns and connection management.
No, not for new projects.
Vanna converts natural language questions into SQL queries and executes them against databases, returning results as interactive tables, charts, and summaries with user-aware permissions and streaming responses.
However, the repository is archived and marked abandoned, which means security patches for the two known vulnerabilities (GHSA-6mj8-jmp2-g8q7, PYSEC-2026-3397) are…
A Python client library for etcd, a distributed key-value store, enabling read, write, delete, and watch operations on etcd servers.
This package has been renamed and is now a redirect to snowflake-cli; installing it pulls in the current Snowflake CLI tool for managing Snowflake resources from the command line.
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.
A Python client library for QuestDB that sends data via the QuestDB Wire Protocol over WebSocket, HTTP, TCP, or UDP, with support for bulk ingestion and row-by-row writes, optional TLS encryption, and authentication.
Install it if you need to ingest data into QuestDB from Python with authenticated or encrypted connections.
Provides a SQLAlchemy dialect for Amazon Redshift, enabling ORM and SQL expression language support against Redshift clusters via psycopg2 or redshift_connector.
However, the current version (0.8.15.dev0) is a development release with no changelog entries, and the last stable release was 425 days ago.
Provides a SQLAlchemy dialect to connect to Db2 on IBM i systems using ODBC, enabling ORM and SQL query construction against IBM i databases.
Provides a SQLAlchemy dialect for Vertica, enabling SQLAlchemy applications to connect to and query Vertica databases using standard SQLAlchemy ORM and SQL expression APIs.
A Python SDK for authenticating with and executing commands against the Qubole Data Service API, supporting Hive, Hadoop, Pig, Presto, and Shell commands via both CLI and programmatic interfaces.
However, be aware that it is aging—the last release was 526 days ago and the original maintainers have moved on—so expect limited support for new features or breaking…
SQLAlchemy dialect for JDBC and ODBC database connections with support for PostgreSQL, Oracle, MySQL, MariaDB, SQL Server, DB2, SQLite, OceanBase, GBase 8s, IBM iSeries, MS Access, and Apache Phoenix.
However, maintenance is aging (268 days since last release), and the description explicitly requests community testing feedback, indicating some dialects may not be…
A Python client for Apache Doris that provides SQLAlchemy integration to query a high-performance analytical database with sub-second response times on large datasets.
Provides Python bindings to query the MusicBrainz NGS webservice and Cover Art Archive API for music metadata and cover art.
However, be aware it is abandoned and will not receive updates.
Generates entity-relationship and UML diagrams from SQLAlchemy ORM models and database schemas, outputting them as image files via Graphviz.
Provides a SQLAlchemy dialect that enables connections to PGSpider using SQLAlchemy's PostgreSQL interface and psycopg2 driver.
Install only if you are locked into an old environment and PGSpider is a hard requirement; otherwise, seek an actively maintained alternative or contact the PGSpider…