Overview
what is Trino MCP Server?
Trino MCP Server is a Model-Control-Protocol server that enables users to list and query tables via Trino using Python, facilitating big data analytics.
how to use Trino MCP Server?
To use the Trino MCP Server, configure the necessary environment variables for Trino connection details and run the server using the provided command structure.
key features of Trino MCP Server?
- Lists Trino tables as MCP resources.
- Reads table contents through MCP.
- Executes arbitrary SQL queries against Trino.
use cases of Trino MCP Server?
- Querying large datasets efficiently using SQL.
- Integrating AI models with data sources for analytics.
- Bridging various data tools through the MCP protocol.
FAQ from Trino MCP Server?
- What is the required Python version?
Python 3.9 or higher is required to run the server.
- How do I configure the server?
The server configuration is done through environment variables for Trino connection details.
- Can I use Trino with different databases?
Yes, Trino supports various catalogs like Hive, PostgreSQL, etc.
Content
Trino MCP Server
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>"
}
}
}
}
No tools information available.
