mcp-trino-v0.3.0

Summary

This release improves query response metadata with accurate duration reporting and query ID tracking for debugging.

Breaking Changes

QueryStats.DurationMs field type change

The duration_ms JSON field now correctly contains milliseconds instead of nanoseconds.

Before (v0.2.x):

{"duration_ms": 540000000}  // Actually nanoseconds!

After (v0.3.0):

{"duration_ms": 540}  // Correctly milliseconds

Migration: If you were dividing by 1,000,000 to convert, remove that conversion.

New Features

Query ID in response stats

Query responses now include the Trino query ID for debugging and log correlation:

{
  "stats": {
    "row_count": 100,
    "duration_ms": 540,
    "truncated": false,
    "query_id": "20240115_123456_00001_abcde"
  }
}

Use this to:

• Correlate with Trino UI/logs
• Debug slow queries
• Build audit trails

Fixes

• #22: duration_ms JSON field now contains actual milliseconds (was nanoseconds)
• #23: Added query_id to QueryStats for debugging/tracking

Known Limitations

• #24 (Warnings): Trino REST API returns warnings, but trino-go-client v0.333.0 does not expose them. Tracking upstream support.

Upgrade Guide

1. Update your dependency:

   go get github.com/txn2/mcp-trino@v0.3.0

2. If you were compensating for nanosecond values in duration_ms, remove that logic.

3. (Optional) Start using query_id for debugging and correlation.

Changelog

Others

• a547dd9: Add changelogs for v0.2.0 and v0.2.1 releases (#18) (@cjimti)
• e4fafe9: Housekeeping/repo (#20) (@cjimti)
• 4958dea: Issues #22, #23, #24 - QueryStats Improvements (#26) (@cjimti)
• d2a6387: ci: bump the github-actions group with 2 updates (#19) (@dependabot[bot])
• fd00323: ci: bump the github-actions group with 3 updates (#21) (@dependabot[bot])
• eb2c662: ci: bump the github-actions group with 6 updates (#16) (@dependabot[bot])

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_0.3.0_darwin_arm64.mcpb
• macOS Intel: mcp-trino_0.3.0_darwin_amd64.mcpb
• Windows: mcp-trino_0.3.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:v0.3.0

Verification

All release artifacts are signed with Cosign. Verify with:

cosign verify-blob --bundle mcp-trino_0.3.0_linux_amd64.tar.gz.sigstore.json \
  mcp-trino_0.3.0_linux_amd64.tar.gz