MCP Trino Server provides seamless integration between AI assistants and Trino/Iceberg databases through a standardized interface. Developed by alaturqua, this Python implementation exposes Trino's querying capabilities and Iceberg's table maintenance operations as MCP resources and tools, enabling data exploration, SQL execution, and table optimization. The server handles connection management, query formatting, and catalog navigation while supporting environment-based configuration, making it particularly valuable for interactive data analysis, automated table maintenance, and building AI-powered tools that interact with Trino databases.
Execute a SQL query and return formatted results. Parameters: query (string, required)
Show a hierarchical tree view of catalogs, schemas, and tables. No parameters required
Show the CREATE TABLE statement for a table. Parameters: table (string, required), catalog (string, optional), schema (string, optional)
Show the CREATE VIEW statement for a view. Parameters: view (string, required), catalog (string, optional), schema (string, optional)
Show statistics for a table. Parameters: table (string, required), catalog (string, optional), schema (string, optional)
Optimize an Iceberg table by compacting small files. Parameters: table (string, required), catalog (string, optional), schema (string, optional)
Optimize manifest files for an Iceberg table. Parameters: table (string, required), catalog (string, optional), schema (string, optional)
Remove old snapshots from an Iceberg table. Parameters: table (string, required), retention_threshold (string, optional), catalog (string, optional), schema (string, optional)
Get the history of executed queries. Parameters: limit (number, optional)
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIOur bundler currently only supports TypeScript-based servers. Check back soon!