{"data":{"slug":"trino","name":"Trino","tagline":"Apache-2.0 distributed SQL query engine for data lakes","category":"databases","categoryName":"Databases","url":"https://trino.io","github":"https://github.com/trinodb/trino","pricing":"open-source","hook":"Trino is a fast distributed SQL query engine for analytics: point it at data lakes (Iceberg, Delta, Hive), databases and object storage, and query them all with ANSI SQL, even joining across sources.","whatsGood":"Apache-2.0 (trinodb/trino), release 484 (2026-10-16), the community fork of PrestoSQL since 2019. Dozens of connectors, a cost-based optimizer, fault-tolerant execution for long queries, and reproducible builds since version 449. Ships as a Java server and an official Docker image. ★~13.3k.","theCatch":"It is a query engine, not storage: you still need a catalog and files or databases underneath. Running a coordinator plus workers on the JVM needs memory tuning, and building from source requires Java 25 and Docker. Starburst sells the commercial distribution; plain Trino is fully open.","verdict":"The standard open engine for SQL over a lakehouse — bring your own storage and catalog.","addedAt":"2026-10-18","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"Analytics & Time-series","tags":["self-host","permissive","active"],"capabilities":[],"surfaces":["Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"Apache-2.0","githubStars":13345,"starsPerWeek":33,"access":"free","archived":false,"repo":{"createdAt":"2019-01-19","pushedAt":"2026-10-19","license":"Apache-2.0","archived":false,"checkedAt":"2026-10-19"}},"related":[{"slug":"supabase","name":"Supabase","tagline":"Open-source Firebase alternative built on Postgres"},{"slug":"turso","name":"Turso","tagline":"SQLite at the edge with libSQL"},{"slug":"redis","name":"Redis","tagline":"The in-memory data store everyone uses"},{"slug":"upstash","name":"Upstash","tagline":"Serverless Redis and Kafka"},{"slug":"pinecone","name":"Pinecone","tagline":"Vector database for AI applications"}],"links":{"self":"/api/gems/trino","html":"/gems/trino","markdown":"/gems/trino.md","category":"/api/gems?category=databases","categoryPage":"/stacks/databases"}}