MCPgee
MCPgee
MCPgeeMCPgee

Trino

v2.2.1•Databases•stable

A high-performance Model Context Protocol (MCP) server for Trino implemented in Go.

mcpmcp-servertrino
Share:
107
Stars
0
Downloads
0
Weekly
0/5
View on GitHub

What is Trino?

Trino is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to high-performance model context protocol (mcp) server for trino implemented in go.

A high-performance Model Context Protocol (MCP) server for Trino implemented in Go.

This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.

Features

  • A high-performance Model Context Protocol (MCP) server for T

Use Cases

Query distributed data warehouses using Trino's high-performance SQL engine. Execute complex analytics across multiple data sources.
tuannvm

Maintainer

LicenseMIT License
Languagego
Versionv2.2.1
UpdatedMay 20, 2026
Statushealthy
Maintenanceactive

Works with

ClaudeOpenAIwindowsmacoslinux
View SourceBrowse All Servers

Installation

Manual Installation

npx mcp-trino

Configuration

Configuration Details

Config File

claude_desktop_config.json

Performance

Response Metrics

Response Time< 200ms
ThroughputMedium

Resource Usage

Memory UsageLow
CPU UsageLow

How to Set Up and Use Trino

mcp-trino is a high-performance MCP server written in Go that enables AI assistants to interact with Trino, the distributed SQL query engine for large-scale analytics. It exposes six tools for listing catalogs, schemas, and tables, inspecting column definitions, explaining query plans, and executing arbitrary SQL across any data source Trino connects to. Teams running data lakes, data warehouses, or federated query environments will benefit from being able to query multiple data sources through natural language.

Prerequisites

  • A running Trino cluster accessible from your machine
  • Trino connection credentials (host, port, user, optionally password)
  • Go 1.21 or later if building from source (or use Homebrew/install script)
  • An MCP client such as Claude Desktop
1

Install mcp-trino

Install the binary using Homebrew on macOS/Linux, or use the provided install script.

# Homebrew (macOS/Linux)
brew install tuannvm/mcp/mcp-trino

# Or one-liner install script
curl -fsSL https://raw.githubusercontent.com/tuannvm/mcp-trino/main/install.sh | bash
2

Set Trino connection environment variables

Export your Trino cluster connection details as environment variables. These are used by both CLI and MCP server modes.

export TRINO_HOST=your-trino-host
export TRINO_PORT=8080
export TRINO_USER=your_user
export TRINO_PASSWORD=your_password   # if auth is enabled
export TRINO_CATALOG=hive             # default catalog
export TRINO_SCHEMA=default           # default schema
export TRINO_SSL=true                 # if TLS is required
3

Test connectivity in interactive mode

Verify the server can connect to Trino before wiring it into an MCP client.

mcp-trino --interactive
# Then try: catalogs
# Then try: query "SELECT 1"
4

Configure your MCP client

Add mcp-trino to your Claude Desktop configuration, passing Trino credentials as environment variables.

// claude_desktop_config.json
{
  "mcpServers": {
    "trino": {
      "command": "mcp-trino",
      "args": [],
      "env": {
        "TRINO_HOST": "your-trino-host",
        "TRINO_PORT": "8080",
        "TRINO_USER": "your_user",
        "TRINO_CATALOG": "hive",
        "TRINO_SCHEMA": "default"
      }
    }
  }
}
5

Restart Claude Desktop and query your data

Restart Claude Desktop and start asking natural language questions about your data. The server will translate them into Trino SQL and return results.

Trino Examples

Client configuration

Claude Desktop config for mcp-trino with environment-based Trino credentials

{
  "mcpServers": {
    "trino": {
      "command": "mcp-trino",
      "args": [],
      "env": {
        "TRINO_HOST": "trino.example.com",
        "TRINO_PORT": "8080",
        "TRINO_USER": "analyst",
        "TRINO_CATALOG": "hive",
        "TRINO_SCHEMA": "sales",
        "TRINO_SSL": "true"
      }
    }
  }
}

Prompts to try

Natural language prompts for querying Trino through the MCP server

- "List all catalogs available in Trino."
- "Show me the tables in the hive.sales schema."
- "What columns does the orders table have?"
- "Run a query to find the top 10 customers by total revenue this year."
- "Explain the execution plan for: SELECT count(*) FROM orders WHERE status = 'shipped'"

Troubleshooting Trino

Connection refused when the MCP server starts

Verify TRINO_HOST and TRINO_PORT are correct and that the Trino coordinator is reachable from your machine. Test with 'curl http://your-trino-host:8080/v1/info'.

Authentication errors with TRINO_PASSWORD set

Ensure TRINO_SSL is set to 'true' when using password authentication, as Trino requires TLS for password-based auth. Also confirm the user exists in the configured authenticator.

Queries time out on large datasets

Use TRINO_ALLOWED_SCHEMAS to restrict the schemas the MCP server can see, reducing catalog scanning overhead. Add LIMIT clauses or use the explain_query tool to optimize before running costly queries.

Frequently Asked Questions about Trino

What is Trino?

Trino is a Model Context Protocol (MCP) server that high-performance model context protocol (mcp) server for trino implemented in go. It connects AI assistants to external tools and data sources through a standardized interface.

How do I install Trino?

Follow the installation instructions on the Trino GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.

Which AI clients work with Trino?

Trino works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.

Is Trino free to use?

Yes, Trino is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.

Learn More About MCP Servers

Getting Started with MCP

Set up your first MCP server in minutes

MCP Setup Guide

Configure MCP in Claude, Cursor & VS Code

All MCP Tutorials

18+ hands-on guides for developers

MCP FAQ

40+ answers about Model Context Protocol

Trino Alternatives — Similar Databases Servers

Looking for alternatives to Trino? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.

Excelize

★ 20.6k

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets

MCP Toolbox for Databases

★ 15.3k

Open source MCP server specializing in easy, fast, and secure tools for Databases.

DBHub

★ 2.8k

A universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.

Tabularis

★ 2.1k

A lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.

Postgres AI Guide

★ 1.7k

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.

Anyquery

★ 1.7k

🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.

Browse More Databases MCP Servers

Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.

DatabasesBrowse All Servers

Quick Config Preview

{ "mcpServers": { "mcp-trino": { "command": "npx", "args": ["-y", "mcp-trino"] } } }

Add this to your claude_desktop_config.json or .cursor/mcp.json

Read the full setup guide →

Ready to use Trino?

Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.

33,000+ ServersFree & Open SourceStep-by-Step Guides
Explore All ServersRead Our Guides