Trino

io.github.alaturquaPublished by GitHub account alaturquav0.8.1Updated Nov 21, 2026

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

VerifiedSTDIODesktop onlyDatabasesData & Analytics

Overview

AI-generated overview

Connects an AI assistant to a Trino SQL engine so it can explore catalogs, run SQL queries, and inspect or maintain Iceberg tables.

What you can do
  • Explore catalogs, schemas, tables, columns, DDL and statistics
  • Run SQL queries and get rows back as JSON
  • Inspect Iceberg snapshots, manifests, partitions, files, history, branches and tags
  • Maintain Iceberg tables by compacting files and manifests and expiring old snapshots
When to use it
Useful when your data lives in Trino or Iceberg and you want to ask questions in plain language, explore schemas, or run ad-hoc SQL without leaving the assistant. Also handy for routine Iceberg maintenance tasks.
Requirements
Runs locally over stdio via uvx (uv required) or a Docker image, and needs a reachable Trino server. TRINO_HOST and TRINO_USER are required; TRINO_PORT, TRINO_HTTP_SCHEME, TRINO_CATALOG, TRINO_SCHEMA, TRINO_READ_ONLY and TRINO_PASSWORD are optional. Basic auth via TRINO_PASSWORD requires https.
Before you install
The assistant can run SQL and, unless TRINO_READ_ONLY is set to true, write data and run Iceberg maintenance such as compaction and snapshot expiry. Set read-only mode when you only want queries. TRINO_PASSWORD is a secret passed by environment variable and should only be sent over https.

Installation

In SourceWeft

  1. Open Trino in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Desktop only via STDIO. STDIO servers start a local process, so they need the SourceWeft desktop host.

Other MCP clients

Follow the launch instructions in the repository.

README

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

bash
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:

text
/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"):

json
{  "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

bash
uv syncdocker compose up -d --wait trinouv run pytest

See Development for linting, docs and releases.

License

Apache 2.0. See LICENSE.

Source: README.md at commit 1c4f425

Tools

0
SourceWeft has not started this package in its sandbox yet, so its tools are not known.

Version history

1
  1. v0.8.1LatestNov 21, 2026

Score

50% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 days25 pts

    Keep the endpoint answering the MCP handshake; SourceWeft probes it every 30 days.

  • Auth declared10 pts

    Declare the credential headers in the registry entry, or keep the endpoint answering the probe so its auth can be classified.

  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts