Mcp Trino
by txn2communityv0.2.1
1
mcp-trino is a Model Context Protocol (MCP) server for Trino that enables AI assistants to query and explore data warehouses with optional semantic context from metadata catalogs.
From the registry: MCP server for Trino data warehouses. Query, analyze plans, and explore schemas.
Install & configure
Prerequisites
- requiredInstall mcp-trino (txn2)Install via Homebrew, Go, or pre-built binary
https://github.com/txn2/mcp-trino$ brew install txn2/tap/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-txn2` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **Install mcp-trino (txn2)** — Install via Homebrew, Go, or pre-built binary Run: `brew install txn2/tap/mcp-trino` (https://github.com/txn2/mcp-trino)
Canonical MCP server config (stdio transport):
- command: `mcp-trino`
- args: []
- required environment variables:
- `TRINO_HOST`: Trino server hostname (example: `trino.example.com`)
- `TRINO_USER`: Trino username (example: `<your-trino-username>`)
- optional environment variables:
- `TRINO_PASSWORD`: Trino password (example: `<your-trino-password>`)
- `TRINO_CATALOG`: Default catalog (example: `hive`)
- `TRINO_SCHEMA`: Default schema (example: `default`)
Note: txn2 mcp-trino variant; supports multi-cluster via TRINO_ADDITIONAL_SERVERS JSON and semantic metadata providers.
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: txn2 mcp-trino variant; supports multi-cluster via TRINO_ADDITIONAL_SERVERS JSON and semantic metadata providers.
Tools (6)
trino_query
Execute read-only SQL queries (SELECT, SHOW, DESCRIBE) with limit/timeout control
trino_execute
Execute any SQL including write operations (INSERT, UPDATE, DELETE, CREATE, DROP)
trino_explain
Get execution plans (logical/distributed/io/validate)
trino_browse
Browse catalog hierarchy: list catalogs, schemas, or tables
trino_describe_table
Get columns, sample data, and semantic context (if configured)
trino_list_connections
List all configured server connections
Environment variables
TRINO_USERrequiredAuthentication usernameTRINO_PASSWORDrequiredAuthentication passwordPackages
https://github.com/txn2/mcp-trino/releases/download/v0.2.1/mcp-trino_0.2.1_darwin_arm64.mcpb
mcpbtransport: stdio
https://github.com/txn2/mcp-trino/releases/download/v0.2.1/mcp-trino_0.2.1_darwin_amd64.mcpb
mcpbtransport: stdio
https://github.com/txn2/mcp-trino/releases/download/v0.2.1/mcp-trino_0.2.1_windows_amd64.mcpb
mcpbtransport: stdio
Details
- Language
- Go
- License
- Apache-2.0
- Released
- Jan 16, 2026
- Last commit
- Jun 12, 2026
- Registry name
- io.github.txn2/mcp-trino