Trino MCP Server in Go

What is Trino MCP Server in Go?

A high-performance Model Context Protocol (MCP) server for Trino implemented in Go. It enables AI assistants to interact with Trino's distributed SQL query engine through standardized MCP tools.

How to use Trino MCP Server in Go?

Install via Homebrew or the one-liner script. Set environment variables (TRINO_HOST, TRINO_USER), then run mcp-trino. Use --interactive for REPL mode, or configure it as an MCP server with STDIO or HTTP transport.

Key features of Trino MCP Server in Go

• Dual mode: works as MCP server and interactive CLI
• Supports STDIO and HTTP (StreamableHTTP) transports
• OAuth 2.1 authentication via oauth-mcp-proxy library
• Trino SQL query execution through MCP tools
• Catalog, schema, and table discovery
• Docker container support

Use cases of Trino MCP Server in Go

• AI assistant querying and analyzing Trino data
• Interactive SQL shell similar to psql for Trino
• Multi-client integration with Claude Desktop, Cursor, Windsurf, and ChatWise
• Production deployment with OAuth and user identity tracking

FAQ from Trino MCP Server in Go

What transports does it support?

STDIO and HTTP (StreamableHTTP with JWT, with SSE backward compatibility).

How does authentication work?

Optional OAuth 2.1 with native (zero server-side secrets) and proxy modes, supporting Okta, Google, and Azure AD.

What are the runtime requirements?

Go runtime (for source builds) or Docker. Pre-built binaries for macOS and Linux via Homebrew or the install script.

How is user identity tracked?

Query attribution tags queries with OAuth user info automatically; optional impersonation executes queries as the OAuth user via X-Trino-User.

Where does the data come from?

The server connects to a Trino cluster, which in turn accesses data sources like PostgreSQL, MySQL, S3/Hive, BigQuery, and MongoDB.