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 |
Capabilities
Features and capabilities supported by this server
| 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 | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/alaturqua/mcp-trino-python'
If you have feedback or need assistance with the MCP directory API, please join our Discord server