Trino
What it is
Trino is a free, distributed SQL query engine for analyzing large datasets across different data sources. It supports ANSI SQL and can combine systems in one query, such as joining S3 object storage with MySQL. Its parallel design is built for low-latency analytics and data warehousing, not general-purpose relational database or OLTP workloads. Connectors cover BigQuery, Cassandra, ClickHouse, Elasticsearch, MongoDB, MySQL, Oracle, PostgreSQL, Redis, Snowflake and SQL Server. The project maintains JDBC, Go, JavaScript, Python and C# drivers, a command-line interface and a Grafana data-source plugin. Deploy it on Kubernetes, in Docker or as a manually deployed server, in cloud or on-premises environments. AI functions work directly with OpenAI and Anthropic and with other models through Ollama, using an external language model service. Security options include several authentication and access-control methods, but a default installation has no security features enabled. The self-managed open-source plan is free under Apache License 2.0.
For and against
For
- Queries multiple data sources in one SQL query.
- Connectors include MySQL, BigQuery and Snowflake.
- Runs on Kubernetes, Docker or a deployed server.
- Maintains drivers for five programming languages.
Against
- Default installation has no security features enabled.
- Not designed as an OLTP replacement.
- Self-managed deployment is listed for the free plan.
The verdict
Trino brings distributed SQL querying and a broad set of connectors to analytics workloads. Review its security configuration before deployment, since security is off by default.
Who it suits
Trino suits teams that need SQL analytics across multiple data sources in cloud or on-premises environments. It is designed for data warehousing and analytics, rather than OLTP or general-purpose database use.
Plans and prices
Trino open source
Apache License 2.0 · self-managed deployment
Read 30 Sep 2026 · trino.io
On the record
- AI functions
- Trino provides AI functions supporting OpenAI and Anthropic directly and other models through Ollama, with the language model supplied as an external service.trino.io · read 30 Sep 2026
- Client interfaces
- The Trino project maintains JDBC, Go, JavaScript, Python, and C# client drivers, plus a command-line interface and Grafana data-source plugin.trino.io · read 30 Sep 2026
- Cloud and on-premises
- Trino is optimized for on-premises and cloud environments including Amazon, Azure, and Google Cloud.trino.io · read 30 Sep 2026
- Deployment
- Trino can run on Kubernetes, in Docker containers, or through a manually deployed server tarball.trino.io · read 30 Sep 2026
- Integrations
- Trino provides connectors for data sources including BigQuery, Cassandra, ClickHouse, Elasticsearch, MongoDB, MySQL, Oracle, PostgreSQL, Redis, Snowflake, and SQL Server.trino.io · read 30 Sep 2026
- License and governance
- The Trino Software Foundation is an independent nonprofit that governs the project, whose projects use the Apache License 2.0.trino.io · read 30 Sep 2026
- Performance
- Trino is highly parallel and distributed and is built for efficient, low-latency analytics.trino.io · read 30 Sep 2026
- Query federation
- Trino can query multiple systems within a single query, such as joining S3 object storage data with MySQL data.trino.io · read 30 Sep 2026
- Security
- Trino supports TLS 1.2 and TLS 1.3, password-file, LDAP, Salesforce, OAuth 2.0, certificate, JWT, and Kerberos authentication, plus file-based, Open Policy Agent, and Ranger access control.trino.io · read 30 Sep 2026
- Security default
- A default Trino installation has no security features enabled.trino.io · read 30 Sep 2026
- SQL support
- Trino is an ANSI SQL compliant query engine.trino.io · read 30 Sep 2026
- Support
- The project directs users to Slack for help and GitHub issues for bug reports.trino.io · read 30 Sep 2026
- What it does
- Trino is a distributed SQL query engine for querying large datasets across heterogeneous data sources.trino.io · read 30 Sep 2026
- Workload scope
- Trino is designed for data warehousing and analytics and is not a general-purpose relational database or an OLTP replacement.trino.io · read 30 Sep 2026
