Trino is a distributed SQL query engine for analyzing large datasets across different data systems. It supports ANSI SQL and can query multiple sources together, such as joining data in S3 object storage with data in MySQL. Its parallel, distributed design targets efficient, low-latency analytics for data warehousing; it is not intended as a general-purpose relational database or an OLTP replacement. Connectors cover systems including BigQuery, Cassandra, ClickHouse, Elasticsearch, MongoDB, MySQL, Oracle, PostgreSQL, Redis, Snowflake, and SQL Server. The project maintains JDBC, Go, JavaScript, Python, and C# clients, along with a command-line interface and Grafana data-source plugin. Trino can run in Kubernetes, Docker, or as a manually deployed server, in cloud and on-premises environments. Its AI functions support OpenAI and Anthropic directly and other models through Ollama, with the language model supplied as an external service. Trino is free under the Apache License 2.0 as self-managed software. It supports several authentication and access-control methods, but a default installation has no security features enabled.
Who it is for
Trino may suit data teams querying and joining large datasets across multiple systems for analytics. It is not designed as a general-purpose relational database or OLTP replacement.
What is good
- Queries can combine multiple data sources.
- Connectors include MySQL, PostgreSQL, and Snowflake.
- Runs on Kubernetes, Docker, or a deployed server.
- Free under the Apache License 2.0.
- Supports multiple authentication and access-control methods.
What to know first
- Not a general-purpose relational database or OLTP replacement.
- Default installation has no security features enabled.
- Language models for AI functions are external services.
Verdict
Trino is aimed at federated SQL analytics across data systems, with deployment choices for cloud and on-premises environments. A default installation has no security enabled, so account for setup before use.
Trino plans and pricing
All plansCompared on OLAP databases
- Free plan
- Yes
- Cloud hosted
- Yes
- Self-hosted
- Yes
- SQL querying
- Yes
- Query result cache
- Yes
- Row-level security
- Yes
- API access
- Yes
