Loading...
brew install mcp-trino{
"mcpServers": {
"mcp-trino": {
"command": "docker",
"args": ["run", "--rm", "-i",
"-e", "TRINO_HOST=<HOST>",
"-e", "TRINO_PORT=<PORT>",
"-e", "TRINO_USER=<USERNAME>",
"-e", "TRINO_PASSWORD=<PASSWORD>",
"-e", "TRINO_SCHEME=http",
"ghcr.io/tuannvm/mcp-trino:latest"],
"env": {}
}
}
}execute_queryExecutes a SQL query against the Trino cluster.
Can modify or expose sensitive data depending on the query and user permissions.
list_catalogsLists available catalogs in the Trino cluster.
Read-only operation that reveals catalog names.
list_schemasLists available schemas within a specified catalog.
Read-only operation that reveals schema names.
list_tablesLists available tables within a specified schema.
Read-only operation that reveals table names.
get_table_schemaRetrieves the schema of a specified table.
Read-only operation that reveals table structure.
explain_queryExplains the execution plan of a SQL query.
Read-only operation that analyzes query execution.
This MCP server provides a controlled interface to Trino. It is relatively safe when used with read-only queries and proper OAuth configuration. Enabling user impersonation and allowing arbitrary SQL execution increases the risk significantly.