Trino

Free plan APILinuxSelf-hostedWeb

What Trino is

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 suits

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 it does well

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.

Limits

The free plan is self-managed under the Apache License 2.0. Trino is designed for data warehousing and analytics, not general-purpose relational database or OLTP workloads; a default installation has no security features enabled.

Plans

Plan	Billed and limits	Price
Trino open source	Apache License 2.0 · self-managed deployment	Free

As trino.io lists them, read 30 Sept 2026. The maker's own page has the final word.

Getting started

Visit https://trino.io/ to get started.
Choose a self-managed deployment: Kubernetes, Docker, or a server tarball.
Select and configure connectors for the data sources you want to query.
Use a supported client driver, the command-line interface, or Grafana data-source plugin.

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.

Questions

How much does Trino cost?

The open-source plan is free under the Apache License 2.0, with self-managed deployment.

Which platforms does Trino support?

Trino is listed for API, Linux, self-hosted, and web. It can run on Kubernetes, in Docker, or as a manually deployed server.

Which data sources can Trino connect to?

Connectors include BigQuery, Cassandra, ClickHouse, Elasticsearch, MongoDB, MySQL, Oracle, PostgreSQL, Redis, Snowflake, and SQL Server.

Is Trino open source?

Yes. Trino projects use the Apache License 2.0, and the Trino Software Foundation governs the project.

Does Trino include security features?

It supports TLS 1.2 and 1.3, multiple authentication options, and file-based, Open Policy Agent, and Ranger access control. Security is disabled in the default installation.

How can users get help with Trino?

The project directs users to Slack for help and GitHub issues for bug reports.

Facts from Trino's own pages

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, 30 Sept 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, 30 Sept 2026
Cloud and on-premises: Trino is optimized for on-premises and cloud environments including Amazon, Azure, and Google Cloud. · trino.io, 30 Sept 2026
Deployment: Trino can run on Kubernetes, in Docker containers, or through a manually deployed server tarball. · trino.io, 30 Sept 2026
Integrations: Trino provides connectors for data sources including BigQuery, Cassandra, ClickHouse, Elasticsearch, MongoDB, MySQL, Oracle, PostgreSQL, Redis, Snowflake, and SQL Server. · trino.io, 30 Sept 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, 30 Sept 2026
Performance: Trino is highly parallel and distributed and is built for efficient, low-latency analytics. · trino.io, 30 Sept 2026
Query federation: Trino can query multiple systems within a single query, such as joining S3 object storage data with MySQL data. · trino.io, 30 Sept 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, 30 Sept 2026
Security default: A default Trino installation has no security features enabled. · trino.io, 30 Sept 2026
SQL support: Trino is an ANSI SQL compliant query engine. · trino.io, 30 Sept 2026
Support: The project directs users to Slack for help and GitHub issues for bug reports. · trino.io, 30 Sept 2026
What it does: Trino is a distributed SQL query engine for querying large datasets across heterogeneous data sources. · trino.io, 30 Sept 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, 30 Sept 2026