mcp-trino · txn2 — Trino MCP server for Claude Code
Connects Trino to an AI assistant for SQL queries, plan inspection, and schema browsing. Useful when you want to explore a data warehouse from your coding environment.
Open on GitHubWhat mcp-trino does
mcp-trino connects Trino and an AI assistant over MCP. It can run SQL, inspect execution plans, and browse catalogs, schemas, and tables. Query row limits and timeouts are configurable; read-only mode helps prevent data changes.
One server installation can connect to multiple Trino instances. When a metadata source is configured, the assistant can also see business descriptions, ownership details, and data quality information. Table views can include column samples and semantic context. You need Trino connection settings, including the server address, to query a warehouse. The Go library can also be used to build a custom MCP server with middleware and interceptors.
For Claude Code, the guide describes installing through Homebrew or downloading a binary, then configuring the MCP server. Docker and Go installation are also covered. Note that trino_execute accepts write operations; use trino_query for read-only SQL.
What it helps with
- run SQL queries against Trino from an AI assistant
- inspect logical and distributed query plans
- browse catalogs, schemas, and tables
- show business metadata alongside query results
- connect multiple Trino instances through one server
Example prompts for the agent
- List the tables in the
hivecatalog anddefaultschema. - Run a read-only Trino query and cap the number of returned rows.
- Explain the execution plan for this SQL query.
How to install mcp-trino
Install
The MCP registry has no launch command for it: see the repository README
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about mcp-trino
How do I install mcp-trino in Claude Code?
The guide covers installing with Homebrew or downloading a binary, then adding the MCP server in Claude Code. Set the Trino connection details, including TRINO_HOST, to connect to your warehouse.
What does mcp-trino do?
It connects Trino to an AI assistant through MCP. The assistant can run SQL, inspect query plans, and browse data structures.
Can mcp-trino connect to multiple Trino servers?
Yes. One installation can connect to multiple Trino instances.
Similar MCP servers
All MCP servers for Data and databases →mcp-trino by other authors comes first.
