Trino Query
STDIOMCP server for listing and querying tables via Trino using Python.
MCP server for listing and querying tables via Trino using Python.
This repository provides an MCP (Model-Control-Protocol) server that allows you to list and query tables via Trino using Python.
The server reads Trino connection details from environment variables:
Variable | Description | Default |
---|---|---|
TRINO_HOST | Trino server hostname or IP | localhost |
TRINO_PORT | Trino server port | 8080 |
TRINO_USER | Trino user name | required |
TRINO_PASSWORD | Trino password (optional, depends on your authentication setup) | (empty) |
TRINO_CATALOG | Default catalog to use (e.g., hive , tpch , postgresql , etc.) | required |
TRINO_SCHEMA | Default schema to use (e.g., default , public , etc.) | required |
{ "mcpServers": { "trino": { "command": "uv", "args": [ "--directory", "<path_to_mcp_server_trino>", "run", "mcp_server_trino" ], "env": { "TRINO_HOST": "<host>", "TRINO_PORT": "<port>", "TRINO_USER": "<user>", "TRINO_PASSWORD": "<password>", "TRINO_CATALOG": "<catalog>", "TRINO_SCHEMA": "<schema>" } } } }