MCP Trino Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| TRINO_AUTH | No | Authentication method | |
| TRINO_HOST | No | Trino server hostname | localhost |
| TRINO_PORT | No | Trino server port | 8080 |
| TRINO_USER | No | Trino username | trino |
| TRINO_SCHEMA | No | Default schema | |
| TRINO_CATALOG | No | Default catalog | |
| TRINO_HTTP_SCHEME | No | HTTP scheme (http/https) | http |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| show_catalogsB | List all available catalogs |
| show_schemasB | List all schemas in a catalog |
| show_tablesB | List all tables in a schema |
| describe_tableC | Describe a table |
| show_create_tableA | Show the CREATE TABLE statement for a specific table |
| show_create_viewB | Show the CREATE VIEW statement for a specific view |
| execute_queryC | Execute a SQL query and return results in a readable format |
| optimizeB | Optimize an Iceberg table's data files |
| optimize_manifestsC | Optimize manifest files for an Iceberg table |
| expire_snapshotsB | Remove old snapshots from an Iceberg table |
| show_statsC | Show statistics for a table |
| show_query_historyB | Get the history of executed queries |
| show_catalog_treeA | Show a hierarchical tree view of catalogs, schemas, and tables |
| show_table_propertiesC | Show Iceberg table properties |
| show_table_historyC | Show Iceberg table history/changelog |
| show_metadata_log_entriesC | Show metadata for the table |
| show_snapshotsC | Show Iceberg table snapshots |
| show_manifestsC | Show Iceberg table manifests |
| show_partitionsB | Show Iceberg table partitions |
| show_filesC | Show Iceberg table data files |
| show_entriesC | Show Iceberg table manifest entries |
| show_refsA | Show Iceberg table references (branches and tags) |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| explore_data | Interactive prompt to explore Trino data. Args: catalog: The name of the catalog to explore schema_name: The name of the schema to explore Returns: list[base.Message]: A list of messages to guide the conversation |
| maintain_iceberg | Interactive prompt for Iceberg table maintenance. |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 22 tools
Most tools have distinct purposes, especially the 'show_' variants which target different Iceberg metadata. However, some concepts like show_table_history, show_metadata_log_entries, and show_snapshots overlap conceptually, causing minor potential confusion.
All tools follow a verb_noun pattern with underscores, which is consistent. The verbs vary (show, describe, execute, expire, optimize) but are clear and appropriate, though a fully uniform verb set would improve consistency.
22 tools is on the higher side but remains reasonable given the dual focus on general Trino queries and detailed Iceberg management. The scope justifies the count, though it could be split into two servers for clarity.
The tool set covers core query operations and comprehensive Iceberg maintenance (snapshots, files, optimization, history). Missing DDL commands like create/drop table or schema are notable gaps but align with the server's apparent administrative/analytical focus.