SSyncDev

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?

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

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

Practical notes

  • Maintained by tuannvm, written in Go.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

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

A high-performance Model Context Protocol (MCP) server for Trino implemented in Go. This project enables AI assistants to seamlessly interact with Trino's Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.

Alternatives to the MCP Trino MCP Server

PostgreSQL

Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.

DatabasesTypeScript★ 63.0k

Notion

Official

Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.

Productivity & Project ManagementRemoteTypeScript★ 3.3k

Supabase

Official

Use the Supabase MCP server to inspect database schemas, query project data and retrieve docs through a project-scoped connection.

DatabasesRemoteTypeScript★ 2.2k

SQLite

Official

Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.

DatabasesPython★ 63.0k

Metabase

Official

Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.

DatabasesRemoteClojure★ 48.5k

MongoDB

Official

Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.

DatabasesTypeScript★ 900