Repository avatar
Databases
v0.8.1
active

mcp-trino-python

io.github.alaturqua/mcp-trino-python

Query Trino and inspect or maintain Iceberg tables: catalogs, schemas, SQL, snapshots.

Documentation

MCP Trino Server

PyPI Docs Docker License MseeP.ai Security Assessment Badge

Let your AI assistant talk to Trino. Ask questions about your data in plain language; the assistant explores catalogs, writes and runs SQL, and inspects or maintains your Iceberg tables.

Works with Claude Code, Claude Desktop, GitHub Copilot in VS Code, Cursor, and any other MCP client.

šŸ“– Documentation

Quick start

You need uv and a Trino server (or docker run -d -p 8080:8080 trinodb/trino:484 for one with sample data).

Claude Code

claude mcp add trino -e TRINO_HOST=localhost -e TRINO_USER=trino -- uvx mcp-trino-python

or install the plugin, which asks for the connection settings:

/plugin marketplace add alaturqua/mcp-trino-python
/plugin install trino@mcp-trino-python

Claude Desktop

Download mcp-trino-python.mcpb from the latest release and double-click it.

VS Code / GitHub Copilot, Cursor and others

Add this to your client's MCP config (.vscode/mcp.json uses "servers" instead of "mcpServers"):

{
  "mcpServers": {
    "trino": {
      "command": "uvx",
      "args": ["mcp-trino-python"],
      "env": { "TRINO_HOST": "localhost", "TRINO_PORT": "8080", "TRINO_USER": "trino" }
    }
  }
}

Then ask: "What catalogs are in Trino?"

More clients, Docker and troubleshooting: Connect your AI client.

What it can do

  • Explore: catalogs, schemas, tables, columns, DDL and statistics
  • Query: run SQL and get the rows back as JSON
  • Iceberg: snapshots, manifests, partitions, files, history, branches and tags
  • Maintain Iceberg tables: compact files and manifests, expire old snapshots
  • Read-only mode: TRINO_READ_ONLY=true blocks writes and hides maintenance tools

See the full tool list.

Configuration

VariableWhat it doesDefault
TRINO_HOSTTrino server hostnamelocalhost
TRINO_PORTTrino server port8080
TRINO_USERUser to run queries astrino
TRINO_PASSWORDPassword; turns on basic auth (needs https)not set
TRINO_HTTP_SCHEMEhttp or httpshttp
TRINO_CATALOGDefault catalognot set
TRINO_SCHEMADefault schemanot set
TRINO_READ_ONLYtrue blocks writes and hides maintenance toolsfalse

Running a shared server over HTTP or in Docker: see Remote and Docker deployment.

Contributing

uv sync
docker compose up -d --wait trino
uv run pytest

See Development for linting, docs and releases.

License

Apache 2.0. See LICENSE.

PYPI
mcp-trino-python
Install Command
pip install mcp-trino-python
Runtime: uvx
OCI
ghcr.io/alaturqua/mcp-trino-python:0.8.1
Install Command
docker pull ghcr.io/alaturqua/mcp-trino-python:0.8.1:undefined