Trino

Fast distributed SQL query engine for big data analytics across federated data sources.

MCPCLI

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

Agent Integration

CLI — trino

$ brew install trino
CLI Documentation

External Links

Trino MCP Server (Go)

Community MCP server supporting execute_query, list_catalogs, list_schemas, list_tables, get_table_schema

AI Functions Documentation

Built-in AI functions that invoke external LLMs directly from SQL queries

CLI Documentation

Official command line interface reference for interactive SQL queries

Client REST API

REST API documentation for submitting SQL queries and receiving results programmatically

Trino Python Client

Official Python client with DBAPI 2.0 and SQLAlchemy adapter

← Back to SQL Engine