Trino

Trino is an open-source, distributed SQL query engine built for lightning-fast analytics over large, heterogeneous data sets. Originally forked from Presto (which emerged at Facebook), it supports ANSI-compliant SQL across a wide range of storage systemsfrom data lakes (S3, HDFS, Iceberg) to relational and NoSQL databases (MySQL, PostgreSQL, Cassandra, MongoDB, Elasticsearch, Kafka, and more) . Architecturally, Trino employs a massively parallel processing (MPP) model with a dedicated coordinator that plans queries and multiple worker nodes that execute them in parallel, allowing it to scale from gigabytes to petabytes of data .
Tags:

Links

Features

C# Client Driver, Go Client Driver, JDBC, ODBC, Python Client Driver, Elixir Client Driver, Simba JDBC Client Driver, R Client Driver, Ruby Client Driver, Rust Client Driver, Command Line Interface, Grafana, Apache Airflow, Apache DolphinScheduler, Coginiti, Cube, DBeaver, dbt, DbVisualizer, Emacs, FugueSQL, Great Expectations, Harlequin, Hue, Ibis, IBM Cognos Analytics, JetBrains Datagrip, Jupy SQL, Logi Symphony, Looker, Metabase, Microstrategy, Mitzu, Mode, PopSQL, Power BI, Querybook, Quix, Redash, SQuirrel SQL, Tableau, VSCode, waii, Wren AI, yanagishima, Zing Data, Spill to disk, Resource groups, Session property managers, Distributed sort, Dynamic filtering, Graceful shutdown, Fault-tolerant execution, HTTP event listener, Kafka event listener, MySQL event listener, OpenLineage event listener, Client protocol, HTTP server, Resource management, Query management, Catalog management, SQL environment, Spilling, Exchange, Task, Write partitioning, Writer scaling, Node scheduler, Optimizer, Logging, Web UI, Regular expression function, HTTP client, Table statistics, Cost in EXPLAIN, Cost-based optimizations, Pushdown, Adaptive plan optimizations, Amazon Redshift, Apache Cassandra, Apache Druid, Apache Ignite, Apache Kafka, Apache Pinot, Clickhouse, Datafaker, Elasticsearch, Exasol, Google BigQuery, Google Sheets, MariaDB, Microsoft SQL Server, MongoDB, MySQL, OpenSearch, Oracle, PostgreSQL, Prometheus, Redis, SingleStore, Snowflake, TPC, Vertica, Amazon Kinesis, Apache Accumulo, Apache Kudu, Apache Phoenix, Git, OpenAPI, VAST, JMX, Kubernetes, OpenLineage, Open Policy Agent, OpenTelemetry, Trino Gateway, Datadog, Gurubase, jOOQ, Minitrino, RudderStack, SQL Formatter, Testcontainers, Trino-lb, Workload Analyzer

Integrations

BigQuery, Black Hole, Cassandra, ClickHouse, Delta Lake, Druid, DuckDB, Elasticsearch, Exasol, Faker, Google Sheets, Hive, Hudi, Iceberg, Ignite, JMX, Kafka, Loki, MariaDB, Memory, MongoDB, MySQL, OpenSearch, Oracle, Pinot, PostgreSQL, Prometheus, Redis, Redshift, SingleStore, Snowflake, SQL Server, System, Thrift, TPC-DS, TPC-H, Vertica


Last modified January 4, 2026: update latest (e894d98e1)