Trino MCP Server
About
A Model Context Protocol server for Trino, providing AI models with structured access to Trino's distributed SQL query engine. It is currently a beta release (v0.1.2).
Details
- Author
- stinkgen
- GitHub stars
- 10
- Downloads
- 445
- Categories
- Other
Jump to
- Exposes Trino resources through the MCP protocol
- Enables AI tools to query and analyze Trino data
- Provides STDIO transport (reliable) and SSE transport (not recommended)
- Offers both Docker container API and standalone Python API
- Includes demo scripts for generating and querying test data
- Fixed catalog handling and Docker container initialization issues
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Trino MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Start the server with docker-compose up -d. Verify the API at http://localhost:9097/api/query. For a non-containerized version, run python llm_trino_api.py on port 8008. Use STDIO transport (recommended) inside the container; client scripts run on the local machine and connect via docker exec.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"trino mcp server": {
"trino_mcp": {
"command": "python",
"args": [
"llm_trino_api.py"
]
}
}
}
}McpServers
{
"trino_mcp": {
"command": "python",
"args": [
"llm_trino_api.py"
]
}
}Trino MCP Server
Model Context Protocol server for Trino, providing AI models with structured access to Trino's distributed SQL query engine.
⚠️ BETA RELEASE (v0.1.2) ⚠️
This project is stabilizing with core features working and tested. Feel free to fork and contribute!
Features
- ✅ Fixed Docker container API initialization issue! (reliable server initalization)
- ✅ Exposes Trino resources through MCP protocol
- ✅ Enables AI tools to query and analyze data in Trino
- ✅ Provides transport options (STDIO transport works reliably; SSE transport has issues)
- ✅ Fixed catalog handling for proper Trino query execution
- ✅ Both Docker container API and standalone Python API server options
Quick Start
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
