This repository provides an MCP (Model-Control-Protocol) server that allows you to list and query tables via Trino using Python.
Overview
- MCP: MCP is a protocol for bridging AI models, data, and tools. This example MCP server provides:
- A list of Trino tables as MCP resources
- Ability to read table contents through MCP
- A tool for executing arbitrary SQL queries against Trino
- Trino: A fast, distributed SQL query engine for big data analytics. This server makes use of Trino’s Python client (trino.dbapi) to connect to a Trino host, catalog, and schema.
Requirements
- Python 3.9+ (or a version compatible with mcp, trino, and asyncio)
- trino (the Python driver for Trino)
- mcp (the Model-Control-Protocol Python library)
Configuration
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 |
Usage
{
"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>"
}
}
}
}