txn2/mcp-trino¶
An MCP server that connects AI assistants to Trino data warehouses. Execute SQL queries, explore schemas, and describe tables with optional semantic context from metadata catalogs like DataHub.
Unlike other MCP servers, mcp-trino is designed as a composable Go library. Import it into your own MCP server to add Trino capabilities with custom authentication, tenant isolation, and audit logging. The standalone server works out of the box; the library lets you build exactly what your organization needs.
Two Ways to Use¶
-
Use the Server
Connect Claude, Cursor, or any MCP client to Trino with secure defaults.
- Read-only mode by default
- Query limits & timeouts
- Multi-cluster support
-
Build Custom MCP
Import the Go library for enterprise servers with auth, tenancy, and compliance.
- OAuth, API keys, SSO
- Row-level tenant isolation
- SOC2 / HIPAA audit logs
Core Capabilities¶
-
Composable Architecture
Import as a Go library to build custom MCP servers with authentication, tenant isolation, and audit logging without forking.
-
Semantic Context
Surface business descriptions, ownership, data quality, and sensitivity markers from metadata catalogs like DataHub.
-
Multi-Cluster
Query production, staging, and development Trino servers from a single MCP installation with unified credentials.
-
Secure Defaults
Read-only mode, query limits, timeouts, and SLSA Level 3 provenance for production deployments.
Available Tools¶
| Tool | Description |
|---|---|
trino_query |
Execute SQL with limits and format options |
trino_explain |
Analyze execution plans |
trino_list_catalogs |
Discover available catalogs |
trino_list_schemas |
Browse schemas in a catalog |
trino_list_tables |
Find tables with pattern matching |
trino_describe_table |
Get columns and sample data |
trino_list_connections |
See configured connections |
Works With¶
Claude Desktop · Claude Code · Cursor · Windsurf · Any MCP Client