Trino
Fast distributed SQL query engine for big data analytics across federated data sources.
- MCP
- CLI
About Trino
Fast distributed SQL query engine for big data analytics across federated data sources. Explore how Trino integrates with the agentic data stack ecosystem and supports autonomous data operations.
Key Features
- Distributed massively parallel processing (MPP) SQL query engine for interactive analytics
- Federated querying across heterogeneous data sources in a single query
- ANSI SQL compliant with complex queries, joins, window functions, and subqueries
- Connector architecture with 30+ connectors (Hive, Iceberg, Delta, PostgreSQL, MongoDB, Kafka)
- Separation of compute and storage — queries data in place without ETL
- Cost-based query optimizer with predicate pushdown and join reordering
- Dynamic scaling with coordinator/worker architecture
- Built-in AI functions (ai_gen, ai_classify, ai_analyze_sentiment) for LLM invocation from SQL
External Links
Trino MCP Server (Go)Community MCP server supporting execute_query, list_catalogs, list_schemas, list_tables, get_table_schemaAI Functions DocumentationBuilt-in AI functions that invoke external LLMs directly from SQL queriesCLI DocumentationOfficial command line interface reference for interactive SQL queriesClient REST APIREST API documentation for submitting SQL queries and receiving results programmaticallyTrino Python ClientOfficial Python client with DBAPI 2.0 and SQLAlchemy adapter
← Back to SQL Engine