Schema | MCP Trino Server

MCP Trino Server

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

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.

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`	{}

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)

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.

Contextual data attached and managed by the client

Name	Description
No resources

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