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.
暂无评论. 成为第一个评论的人！
登录以参与讨论
List all available catalogs. No parameters required.
List all schemas in a catalog. Parameters: catalog (string, required).
List all tables in a schema. Parameters: catalog (string, required), schema (string, required).
Show detailed table structure and column information. Parameters: table (string, required), catalog (string, optional), schema (string, optional).
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).
Show Iceberg table properties. Parameters: table (string, required), catalog (string, optional), schema (string, optional).
Show Iceberg table history/changelog. Parameters: table (string, required), catalog (string, optional), schema (string, optional).
Show Iceberg table metadata log entries. Parameters: table (string, required), catalog (string, optional), schema (string, optional).
Show Iceberg table snapshots. Parameters: table (string, required), catalog (string, optional), schema (string, optional).
Show Iceberg table manifests for current or all snapshots. Parameters: table (string, required), catalog (string, optional), schema (string, optional), all_snapshots (boolean, optional).
Show Iceberg table partitions. Parameters: table (string, required), catalog (string, optional), schema (string, optional).
Show Iceberg table data files in current snapshot. Parameters: table (string, required), catalog (string, optional), schema (string, optional).
Show Iceberg table manifest entries for current or all snapshots. Parameters: table (string, required), catalog (string, optional), schema (string, optional), all_snapshots (boolean, optional).
Show Iceberg table references (branches and tags). Parameters: table (string, required), catalog (string, optional), schema (string, optional).
Get the history of executed queries. Parameters: limit (number, optional).
