Trino MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
TRINO_HOSTNoHostname of the Trino servertrino
TRINO_PORTNoPort of the Trino server8080
TRINO_USERNoUsername for connecting to Trinotrino
TRINO_CATALOGNoDefault catalog to use in Trinomemory

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription
trino://catalog

Tools

Functions exposed to the LLM to take actions

NameDescription
execute_query
Execute a SQL query against Trino. Args: sql: The SQL query to execute. catalog: Optional catalog name to use for the query. schema: Optional schema name to use for the query. Returns: Dict[str, Any]: Query results including metadata.
cancel_query
Cancel a running query. Args: query_id: ID of the query to cancel. Returns: Dict[str, Any]: Result of the cancellation operation.
inspect_table
Get detailed metadata about a table. Args: catalog: Catalog name. schema: Schema name. table: Table name. Returns: Dict[str, Any]: Table metadata including columns, statistics, etc.