Tools/trinodb/trino

Trino

Distributed SQL query engine for big data

13.1k+32/wkgrowthJavaApache License 2.0trending

The Lens

By Erik Loyd, SaaS CEO and former COO/CFO of an AWS Premier Partner.

Updated Mar 2026

Trino queries across all your data sources (Postgres, S3, Elasticsearch, spreadsheets) with standard SQL. It's a distributed SQL query engine that connects to dozens of data sources and lets you join across them like they're one database.

Formerly known as PrestoSQL (the original creators of Presto at Facebook forked after a dispute), Trino is the community-driven continuation. Apache 2.0, used by companies like Netflix, LinkedIn, and Lyft.

The engine is free. Managed options include Starburst (the commercial company founded by Trino's creators) starting around $2/hr for a small cluster, and AWS Athena which is Trino under the hood at $5/TB scanned.

The catch: Trino is a query engine, not a database. It doesn't store data; it reads from where your data already lives. Running it yourself means managing a coordinator + workers cluster, which is real ops work. And for single-source queries, it's slower than querying that source directly. Trino shines specifically when you need to federate across multiple sources.

Free vs Self-Hosted vs Paid

fully free

Trino is fully open source under Apache 2.0. No paid features in the engine.

Self-hosted: Coordinator + worker nodes. Minimum 2-3 nodes for anything useful. On cloud VMs, figure $150-400/mo for a small cluster. You handle scaling, configuration, and connector setup.

Managed options:

  • Starburst Enterprise/Galaxy: starts around $2/hr for a small cluster. Monthly cost depends on usage; a team running queries daily might spend $500-1,500/mo.
  • AWS Athena: $5/TB scanned, serverless. Great for occasional queries, expensive for heavy use.
  • Google BigQuery: not Trino, but solves the same federated query problem differently.

The decision: If you query daily, self-host or use Starburst. If it's occasional, Athena's pay-per-query model wins.

Free engine. Self-host for $150-400/mo or use managed Starburst/Athena based on query volume.

Self-hosting ops:significant

Get tools like this every Wednesday

One featured tool, three on the radar. No fluff.

Similar Tools

Score
88/100 · A
Adoption27/30
Maintenance25/25
Community11/20
License15/15
Analysis10/10

A low score is not a verdict on quality. Young and niche tools start low by design. How we calculate scores

Trust Signals

High adoption: 12,731 starsActive community: 3,567 forksPermissive license (Apache-2.0)

About

Stars
13,110
Forks
3,722

Explore Further

More tools in the directory