presto-python-client
Client for the Presto distributed SQL Engine
Decision gist · record as of 2026-08-14
Yes, if you need to query Presto from Python. The package is actively maintained, has low install friction, carries no known vulnerabilities, and uses a permissive Apache 2.0 license. However, note the release gap since 2023-09-07—verify compatibility with your Presto version before adopting in new projects.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Low install friction with a pure-wheel distribution.
- Actively maintained as of 2026-03-18, though the last release was in 2023-09-07.
- Depends on common, stable libraries (click, requests, six).
License · maintenance · safety
Apache 2.0 (permissive) — Licensed under Apache 2.0 (permissive), allowing commercial and private use with minimal restrictions.
last release 2023-09-07 (1072 days) · last repo commit 2026-03-18 · 244 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 4,918,934 downloads/mo, #2,199 on PyPI
Alternatives
Verify before relying
pip install presto-python-client
import click
import requests
conn = connect(
host='localhost',
port=8080,
user='the-user',
catalog='the-catalog',
schema='the-schema',
)
cur = conn.cursor()
cur.execute('SELECT * FROM system.runtime.nodes')
rows = cur.fetchall()- Whether the package works with modern Presto/Trino versions given the release gap since 2023-09-07.
- Current compatibility with Python 3.8 and 3.9 versions beyond those explicitly listed in early classifiers.
- Whether Kerberos and OAuth authentication features work reliably in production environments.
What it is and what it does
This is a Python client for Presto, a distributed SQL query engine. It implements the Python DBAPI 2.0 interface, allowing you to connect to a Presto cluster and execute SQL queries using standard cursor methods like execute() and fetchall(). You provide connection details (host, port, user, catalog, schema) and optional authentication (basic, Kerberos, or OAuth), then interact with the cluster through familiar database cursor operations.
The package handles HTTP communication with the Presto coordinator and supports transaction control via isolation levels. It works across multiple Python versions and operating systems, including CPython and PyPy. Common use cases include ad-hoc analytics queries, data pipeline integration, and programmatic access to Presto clusters from Python applications.
Use it for
- Execute SQL queries against a Presto cluster from a Python script without writing raw HTTP requests.
- Integrate Presto queries into data pipelines or ETL workflows that require programmatic SQL execution.
- Connect to LDAP-configured or OAuth-enabled Presto clusters using authentication classes.
- Retrieve query results in batches using fetchone(), fetchmany(), or fetchall() for memory-efficient processing.
- Run transactional workloads by setting isolation_level to REPEATABLE_READ or other non-autocommit modes.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you need to query Presto from Python.
The package is actively maintained, has low install friction, carries no known vulnerabilities, and uses a permissive Apache 2.0 license. However, note the release gap since 2023-09-07—verify compatibility with your Presto version before adopting in new projects.
Install
presto-python-client on PyPI
Before you install
Low install friction with a pure-wheel distribution. Actively maintained as of 2026-03-18, though the last release was in 2023-09-07. Depends on common, stable libraries (click, requests, six).
License in practice
Licensed under Apache 2.0 (permissive), allowing commercial and private use with minimal restrictions.
Quickstart
pip install presto-python-client
import click
import requests
conn = connect(
host='localhost',
port=8080,
user='the-user',
catalog='the-catalog',
schema='the-schema',
)
cur = conn.cursor()
cur.execute('SELECT * FROM system.runtime.nodes')
rows = cur.fetchall()Verify before relying
- Whether the package works with modern Presto/Trino versions given the release gap since 2023-09-07.
- Current compatibility with Python 3.8 and 3.9 versions beyond those explicitly listed in early classifiers.
- Whether Kerberos and OAuth authentication features work reliably in production environments.
Package facts
| License | Apache 2.0 permissive |
| Python support | Not specified |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 5 packagesclickrequestssixipaddresstyping |
| Maintenance | Actively maintained 1,072 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 4,918,934 / month, #2,199 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaIntended Audience :: DevelopersLicense :: OSI Approved :: Apache Software LicenseOperating System :: MacOS :: MacOS XOperating System :: Microsoft :: WindowsOperating System :: POSIXProgramming Language :: PythonProgramming Language :: Python :: 2.7Programming Language :: Python :: 3Programming Language :: Python :: 3.5Programming Language :: Python :: 3.6Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Programming Language :: Python :: Implementation :: CPythonProgramming Language :: Python :: Implementation :: PyPyTopic :: Database :: Front-Ends |
Evidence: presto_python_client-0.8.4-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 › “presto sql client python”
- presto-python-clientProvides a Python DBAPI-compatible client to query Presto, a…
- presto-types-parserParses Presto SQL type annotations from rows returned by the Presto…
- apache-airflow-providers-prestoIntegrates Presto query execution into Apache Airflow workflows,…
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 presto-types-parser · singlestoredb · trino · nflx-genie-client · apache-airflow-providers-presto · salesforce-cdp-connector · elasticsearch-dbapi · python-tds · qds-sdk · ydb-dbapi