trinodb/trino

Health v2 · maintenance only

Adoption not part of the score

13183 stars · 3749 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

Trino is a fast, distributed ANSI SQL query engine for big data analytics, formerly known as PrestoSQL. It queries data in place across diverse sources such as data lakes (Hive, Iceberg, Delta Lake), object storage, and relational databases, with support for query federation and BI tool integration.

Use cases

• run interactive SQL analytics against data lakes on S3 or Hadoop
• federate queries joining data from MySQL, Kafka, Cassandra, and object storage in one SQL statement
• connect BI tools like Tableau, Power BI, or Superset to a fast SQL engine
• query Iceberg and Delta Lake lakehouse tables at scale
• execute large multi-hour batch queries and sub-second high-volume app queries
• explore exabyte-scale data warehouses without copying data

When to choose

• you need low-latency, distributed SQL analytics over heterogeneous data sources
• you want in-place querying and federation without ETL data copies
• you need an ANSI SQL engine that integrates with standard BI tools and JDBC clients

When to avoid

• you need a transactional OLTP database for writes and small point lookups
• you want a small single-node embedded database for an application
• your workload is simple analytics on one small dataset where a lightweight engine suffices

Facets

application · maturity stable

database search-engine analytics etl big-data databases data-science analytics jvm cloud self-hosted sql-query-engine distributed-systems data-lake lakehouse query-federation presto jdbc iceberg delta-lake sql data-engineering linux macos docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="trinodb/trino")