# mcp-trino

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.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed · ★ 5
- Author: txn2
- License: Apache-2.0 · policy=link-only · description only; the file stays with the author
- Source: https://github.com/txn2/mcp-trino
- Updated: 2026-10-17
- HTML: https://affpapa.org/en/nevibecode/mcp/txn2-mcp-trino

## What it 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.

## Install

### Claude Code (native platform)

**Install**
- The MCP registry has no launch command for it: see the repository README

## When to use it
- 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
- List the tables in the `hive` catalog and `default` schema.
- Run a read-only Trino query and cap the number of returned rows.
- Explain the execution plan for this SQL query.

## Similar
- [World Monitor](https://affpapa.org/en/nevibecode/mcp/world-monitor.md) — MCP server · ★ 89609
- [Scrapling MCP Server](https://affpapa.org/en/nevibecode/mcp/scrapling-mcp-server.md) — MCP server · ★ 89899
- [MCP Toolbox for Databases](https://affpapa.org/en/nevibecode/mcp/googleapis-mcp-toolbox-for-databases.md) — MCP server · ★ 16730
- [PostHog MCP Server](https://affpapa.org/en/nevibecode/mcp/posthog-mcp-server.md) — MCP server · ★ 40459
- [dbx](https://affpapa.org/en/nevibecode/mcp/dbx.md) — MCP server · ★ 27844
- [Metabase](https://affpapa.org/en/nevibecode/mcp/metabase.md) — MCP server · ★ 49863

## Other versions with the same name
- [mcp-trino · tuannvm](https://affpapa.org/en/nevibecode/mcp/mcp-trino.md) — ★ 122

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md