MCP Trino MCP Server

A high-performance Model Context Protocol (MCP) server for Trino implemented in Go. This project enables AI assistants to seamlessly interact with

Local serverstdioGo

What is the MCP Trino MCP server?

If you want an AI assistant working directly with MCP Trino, the mcp trino mcp server is the bridge. A high-performance Model Context Protocol (MCP) server for Trino implemented in Go. This project enables AI assistants to seamlessly interact with Trino's distributed SQL query engine through standardized MCP tools.

What MCP Trino does

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

This project implements a Model Context Protocol (MCP) server for Trino in Go. It enables AI assistants to access Trino's distributed SQL query engine through standardized MCP tools.

Key capabilities

  • Dual Mode: Works as both MCP server AND interactive CLI
  • CLI Mode — psql-like interactive SQL shell for direct Trino access
  • MCP Mode — Full MCP server for AI assistant integration
  • ✅ MCP server implementation in Go
  • ✅ Trino SQL query execution through MCP tools
  • ✅ Catalog, schema, and table discovery
  • ✅ Docker container support
  • ✅ Supports both STDIO and HTTP transports

Tools it exposes

Once connected, the assistant can call these 2 tools directly:

  • Security — The Security tool exposed by this server
  • Testing — The Testing tool exposed by this server

Installing the mcp trino mcp server

Setup follows the standard MCP pattern: clone or install the server, then register it in your client's configuration file and restart the client. The configuration snippets on this page cover Claude Desktop, Claude Code and Cursor.

Configuration

The server reads 8 environment variables: TRINO_HOST, TRINO_PORT, TRINO_USER, TRINO_PASSWORD, TRINO_CATALOG, TRINO_SCHEMA, TRINO_SSL, OAUTH_ENABLED. Keep credentials in your client's env block or a secrets manager rather than committing them.

Where it fits

Database servers turn schema archaeology and ad-hoc reporting into conversation, which is why they tend to be the second or third server people install. MCP Trino sits in that group, and the shape of its toolset — Security, Testing — tells you what it is really for. Worth comparing against the other databases servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.

Practical notes

  • This server runs locally, so it operates with whatever access your machine and its credentials already have. Scope that deliberately rather than by default.
  • Maintained by tuannvm, written in Go.
  • MCP clients ask for confirmation before each tool call by default. Keep that on while you learn what the mcp trino mcp server actually does with your data.
  • Every entry in this directory is reviewed by hand before it goes live, and details are checked against the project's own documentation.

Available tools

ToolWhat it does
SecurityThe Security tool exposed by this server.
TestingThe Testing tool exposed by this server.

Configuration

VariableDescriptionRequired
TRINO_HOSTEndpoint or connection string the server talks to.Optional
TRINO_PORTConfiguration value read at startup.Optional
TRINO_USERConfiguration value read at startup.Optional
TRINO_PASSWORDConfiguration value read at startup.Optional
TRINO_CATALOGConfiguration value read at startup.Optional
TRINO_SCHEMAConfiguration value read at startup.Optional
TRINO_SSLConfiguration value read at startup.Optional
OAUTH_ENABLEDConfiguration value read at startup.Optional

Example prompts to try

  • Use MCP Trino to Security.
  • Use MCP Trino to Testing.

Frequently asked questions

It connects MCP Trino to MCP-compatible AI assistants such as Claude and Cursor, exposing 2 tools (Security, Testing) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with MCP Trino directly.