trino

Client for the Trino distributed SQL Engine

trino Permissive license Apache 2.0 Active ★ 433 v0.338.0 released 2026-06-29

Install

trino on PyPI

pip

pip install trino

uv

uv add trino

poetry

poetry add trino

Package facts

License	Apache 2.0 (permissive)
Python support	supports the current Python release (>=3.9)
Install friction	low — pure-Python wheel
Runtime dependencies	7 — lz4, orjson, python-dateutil, pytz, requests, tzlocal, zstandard
Maintenance	actively maintained — 45 days since the last release
Last repo commit	2026-07-29
First released	2020-12-28
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: trino-0.338.0-py3-none-any.whl

Development Status :: 4 - BetaIntended Audience :: DevelopersLicense :: OSI Approved :: Apache Software LicenseOperating System :: MacOS :: MacOS XOperating System :: Microsoft :: WindowsOperating System :: POSIXProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.9Programming Language :: Python :: Implementation :: CPythonProgramming Language :: Python :: Implementation :: PyPyTopic :: Database :: Front-Ends

About trino

from the package's own PyPI description — quoted content, verbatim

Trino Python client

Client for Trino, a distributed SQL engine for interactive and batch big data processing. Provides a low-level client and a DBAPI 2.0 implementation and a SQLAlchemy adapter. It supports Python>=3.9 and PyPy.

Build Status (image) Trino Slack (image) Trino: The Definitive Guide book download (image)

Development

See DEVELOPMENT for information about code style, development process, and guidelines.

See CONTRIBUTING for contribution requirements.

Usage

The Python Database API (DBAPI)

Installation

$ pip install trino

Quick Start

Use the DBAPI interface to query Trino:

if host is a valid...

Read as markdown · JSON record · Source repository · Homepage

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

A Python client for Trino, a distributed SQL engine, offering DBAPI 2.0 and SQLAlchemy interfaces for querying big data clusters.

Low friction install with seven runtime dependencies (lz4, orjson, python-dateutil, pytz, requests, tzlocal, zstandard). Active maintenance with a release 45 days ago and regular commits; 433 GitHub stars.

Apache 2.0 permissive license allows broad use, modification, and distribution with minimal restrictions—suitable for commercial and proprietary projects.

Usage

pip install trino

from trino.dbapi import connect

conn = connect(
    host="localhost",
    port=8080,
    user="username",
    catalog="system",
    schema="runtime"
)
cur = conn.cursor()
cur.execute("SELECT * FROM system.runtime.nodes")
rows = cur.fetchall()

Requires Python >=3.9; a running Trino server is needed to connect to.

Verdict: Actively maintained, top-1000 popular package with no known vulnerabilities and permissive licensing. Low install friction and broad Python version support (3.9–3.13, PyPy) make it a solid choice for Trino connectivity. Suitable for both DBAPI and SQLAlchemy workflows.

Needs verification

Whether the SQLAlchemy adapter requires Trino server >=351 as a hard constraint or merely recommended.
Performance characteristics and connection pooling behavior under high-concurrency workloads.
Support status for authentication methods beyond those documented (e.g., custom SASL mechanisms).

trino sql clientdistributed sql query pythondbapi sql enginesqlalchemy trino adapterbig data query clientinteractive sql processingtrino connection library