Mcp Trino
by tuannvmcommunityv2.2.1
100
45
This MCP server implements the Model Context Protocol for Trino in Go, allowing AI assistants to interact with Trino's distributed SQL query engine through standardized tools.
From the registry: MCP server for Trino distributed SQL query engine access
Install & configure
Prerequisites
- requiredInstall mcp-trino binaryInstall via Homebrew or the shell one-liner
https://github.com/tuannvm/mcp-trino$ brew install tuannvm/mcp/mcp-trino
Install in your client
Paste into the AI you're chatting with — it will figure out the rest
Please install the `mcp-trino` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **Install mcp-trino binary** — Install via Homebrew or the shell one-liner Run: `brew install tuannvm/mcp/mcp-trino` (https://github.com/tuannvm/mcp-trino)
Canonical MCP server config (stdio transport):
- command: `mcp-trino`
- args: []
- required environment variables:
- `TRINO_HOST`: Trino coordinator hostname (example: `trino.example.com`)
- `TRINO_USER`: Trino username (example: `<your-trino-username>`)
- optional environment variables:
- `TRINO_PORT`: Trino port (example: `443`)
- `TRINO_PASSWORD`: Trino password (if required) (example: `<your-trino-password>`)
- `TRINO_CATALOG`: Default catalog (example: `hive`)
- `TRINO_SCHEMA`: Default schema (example: `analytics`)
- `TRINO_SSL`: Enable SSL (example: `true`)
Note: Dual-mode: MCP server and interactive CLI. HTTP transport with OAuth is also supported.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.Note: Dual-mode: MCP server and interactive CLI. HTTP transport with OAuth is also supported.
Tools (6)
execute_query
Executes a SQL query against the Trino engine.
list_catalogs
Lists available catalogs in the Trino engine.
list_schemas
Lists schemas within a specified catalog.
list_tables
Lists tables within a specified schema.
get_table_schema
Retrieves the schema of a specified table.
explain_query
Provides an explanation of a SQL query execution plan.
Environment variables
TRINO_HOSTrequiredThe hostname of the Trino server.TRINO_USERrequiredThe username for authenticating with the Trino server.Packages
https://github.com/tuannvm/mcp-trino/releases/download/v2.2.1/mcp-trino_2.2.1_darwin_arm64.tar.gz
mcpbtransport: stdio
Details
- Language
- Go
- License
- MIT
- Released
- Sep 9, 2025
- Last commit
- Apr 11, 2026
- Registry name
- io.github.tuannvm/mcp-trino