
Trino
Distributed SQL query engine for big data
The Lens
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 freeTrino 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.
Similar Tools
About
- Stars
- 12,690
- Forks
- 3,558
Explore Further
More tools in the directory
Get tools like this delivered weekly
The Open Source Drop — the best new open source tools, analyzed. Free.


