Skip to content

mcp-trino-v1.1.0

Choose a tag to compare

@github-actions github-actions released this 03 Mar 21:21
· 13 commits to main since this release
Immutable release. Only release title and notes can be modified.
57bc8d8

mcp-trino v1.1.0 — Consolidated Catalog Browsing

v1.1.0 consolidates the three hierarchical navigation tools into a single, parameterized trino_browse tool. This reduces the tool count from 8 to 6 while preserving all functionality, freeing tool slots for future capabilities.


Breaking Changes

This release removes three tool names with no aliases or deprecation period:

Removed tool Replacement
trino_list_catalogs trino_browse (no parameters)
trino_list_schemas trino_browse with catalog
trino_list_tables trino_browse with catalog + schema

Migration guide

MCP clients (Claude Desktop, Claude Code, etc.): Update any tool references in prompts or configurations. The new tool is auto-discovered; no manual registration changes are needed for end users.

Library consumers (pkg/tools importers):

  • Replace tools.ToolListCatalogs, tools.ToolListSchemas, tools.ToolListTables constants with tools.ToolBrowse
  • Replace tools.ListCatalogsInput, tools.ListSchemasInput, tools.ListTablesInput structs with tools.BrowseInput
  • Replace tools.ListCatalogsOutput, tools.ListSchemasOutput, tools.ListTablesOutput structs with tools.BrowseOutput
  • AllTools() now returns 6 tools (was 8); SchemaTools() returns 2 (was 4)

Structured output changes

The three separate output types are replaced by a single unified BrowseOutput:

{
  "level": "tables",
  "catalog": "hive",
  "schema": "sales",
  "items": ["customers", "orders", "order_items"],
  "count": 3,
  "pattern": "%order%"
}
  • level indicates the browsing mode: "catalogs", "schemas", or "tables"
  • items replaces the type-specific fields (catalogs, schemas, tables)
  • catalog, schema, and pattern are omitted when not applicable

New: trino_browse Tool

Browse the Trino catalog hierarchy with a single tool. The browsing level is determined by which parameters are provided:

Parameters Action
(none) List all catalogs
catalog List schemas in that catalog
catalog + schema List tables in that schema
catalog + schema + pattern List tables matching a SQL LIKE pattern

Input validation

Input Error
schema without catalog "schema requires catalog"
pattern without catalog + schema "pattern requires both catalog and schema"

Pattern filtering

The pattern parameter supports standard SQL LIKE syntax:

Pattern Matches
order% Tables starting with "order"
%log Tables ending with "log"
%event% Tables containing "event"
user_ 5-character tables starting with "user" (_ = single character)

Annotations

trino_browse carries the same MCP annotations as the tools it replaces: ReadOnlyHint: true, IdempotentHint: true, OpenWorldHint: true.


Tool Summary (v1.1.0)

Tool Display Title Description
trino_query Execute SQL Query Execute read-only SQL (SELECT/SHOW/DESCRIBE)
trino_execute Execute SQL (Write) Execute any SQL including write operations
trino_explain Explain Query Plan Get execution plans
trino_browse Browse Catalog Hierarchy Browse catalogs, schemas, or tables
trino_describe_table Describe Table Get columns, sample data, and semantic context
trino_list_connections List Connections List configured server connections

Stats

  • 28 files changed across code, tests, and documentation
  • Net reduction of ~290 lines (543 added, 830 removed)
  • All existing tests updated; new browse-specific test suite added
  • Full documentation refresh across README, CLAUDE.md, mkdocs site, and API reference

Installation

Claude Desktop (macOS/Windows)

Download the .mcpb bundle for your platform and double-click to install:

  • macOS Apple Silicon (M1/M2/M3/M4): mcp-trino_1.1.0_darwin_arm64.mcpb
  • macOS Intel: mcp-trino_1.1.0_darwin_amd64.mcpb
  • Windows: mcp-trino_1.1.0_windows_amd64.mcpb

Homebrew (macOS)

brew install txn2/tap/mcp-trino

Claude Code CLI

claude mcp add trino \
  -e TRINO_HOST=your-trino-host \
  -e TRINO_USER=your-user \
  -- mcp-trino

Docker

docker pull ghcr.io/txn2/mcp-trino:v1.1.0

Verification

All release artifacts are signed with Cosign. Verify with:

cosign verify-blob --bundle mcp-trino_1.1.0_linux_amd64.tar.gz.sigstore.json \
  mcp-trino_1.1.0_linux_amd64.tar.gz