pinotdb
Python DB-API and SQLAlchemy dialect for Pinot.
Decision gist · record as of 2026-08-14
Yes. The package is actively maintained, has no known vulnerabilities, uses a permissive MIT license, and installs with low friction. It is the standard way to query Pinot from Python and is well-suited for analytics, BI tool integration, and real-time data access workflows. Install if you need to work with Pinot from Python.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires a running Pinot broker instance accessible at the specified host and port; SQLAlchemy usage additionally requires a Pinot controller for table/schema metadata.
- Low install friction with four lightweight runtime dependencies (ciso8601, h11, httpx, urllib3).
- Active maintenance with a recent release (81 days ago) and ongoing repository activity.
License · maintenance · safety
MIT (permissive) — MIT license permits unrestricted use, modification, and distribution with minimal restrictions, making it suitable for both open-source and commercial projects.
last release 2026-05-25 (81 days) · last repo commit 2026-08-11 · 19 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 44,311,633 downloads/mo, #631 on PyPI
Alternatives
Verify before relying
from pinotdb import connect
conn = connect(host='localhost', port=8000, path='/query/sql', scheme='http')
curs = conn.cursor()
curs.execute('SELECT * FROM places LIMIT 10')
for row in curs:
print(row)- Whether the package supports Pinot versions beyond 1.1.0 or if 1.1.0 is the only tested version.
- Performance characteristics and query timeout defaults when working with large result sets.
- Whether async dialect fully supports all query options and authentication methods available in sync mode.
What it is and what it does
pinotdb is a Python database driver that implements the DB-API 2.0 specification and provides a SQLAlchemy dialect for Apache Pinot, a real-time analytics database. It allows you to query Pinot via HTTP/HTTPS using either raw SQL connections or through SQLAlchemy's ORM and query builder, with support for both synchronous and asynchronous operations.
The package handles connection management to Pinot brokers and controllers, exposes query statistics (servers queried, documents scanned, execution time), supports basic authentication, SSL verification, and query options like the multi-stage engine. It integrates with tools like Superset for analytics dashboarding and works with modern Python versions (3.10 through 3.14).
Use it for
- Query real-time analytics data from Pinot using standard SQL in Python applications or Jupyter notebooks.
- Integrate Pinot as a data source in SQLAlchemy-based ORMs or query builders for analytics workflows.
- Build async data pipelines that fetch large result sets from Pinot without blocking the event loop.
- Connect Superset or other BI tools to Pinot via the SQLAlchemy dialect for interactive dashboarding.
- Monitor query performance by accessing broker statistics like segment counts and document scans after each query.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
The package is actively maintained, has no known vulnerabilities, uses a permissive MIT license, and installs with low friction. It is the standard way to query Pinot from Python and is well-suited for analytics, BI tool integration, and real-time data access workflows. Install if you need to work with Pinot from Python.
Install
pinotdb on PyPI
Before you install
Low install friction with four lightweight runtime dependencies (ciso8601, h11, httpx, urllib3). Active maintenance with a recent release (81 days ago) and ongoing repository activity.
Requires a running Pinot broker instance accessible at the specified host and port; SQLAlchemy usage additionally requires a Pinot controller for table/schema metadata.
License in practice
MIT license permits unrestricted use, modification, and distribution with minimal restrictions, making it suitable for both open-source and commercial projects.
Quickstart
from pinotdb import connect
conn = connect(host='localhost', port=8000, path='/query/sql', scheme='http')
curs = conn.cursor()
curs.execute('SELECT * FROM places LIMIT 10')
for row in curs:
print(row)Verify before relying
- Whether the package supports Pinot versions beyond 1.1.0 or if 1.1.0 is the only tested version.
- Performance characteristics and query timeout defaults when working with large result sets.
- Whether async dialect fully supports all query options and authentication methods available in sync mode.
Package facts
| License | MIT permissive |
| Python support | Supports the current Python release <4,>=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagesciso8601h11httpxurllib3 |
| Maintenance | Actively maintained 81 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 44,311,633 / month, #631 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | License :: OSI Approved :: MIT LicenseProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14 |
Evidence: pinotdb-9.1.2-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “pinot database connector”
- pinotdbProvides Python DB-API and SQLAlchemy dialect support for querying…
- apache-airflow-providers-apache-pinotIntegrates Apache Pinot with Apache Airflow, providing operators and…
- mysql-connector-pythonMySQL Connector/Python is a PEP 249-compliant database driver that…
Give your agent the search over MCP, or paste the wish link into any chat.
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
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.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
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.
See also sqlalchemy-cockroachdb · surrealdb · elasticsearch-dbapi · sqlalchemy-databricks · apache-airflow-providers-apache-pinot · sqlalchemy-jdbcapi · sqlalchemy-hana · sqlalchemy-trino · PyHive · pydoris