mcp-trino

Overview

The mcp-trino project is a well-implemented MCP server for Trino (formerly PrestoSQL), written in Go. It provides a robust solution for AI assistants to interact with Trino's distributed SQL query engine through standardized MCP tools. The server features dual operation modes: as an MCP server for AI integration and as an interactive CLI similar to psql. It supports both STDIO and HTTP transports, with optional OAuth 2.1 authentication for enhanced security.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• execute_query

  Execute a SQL query against a Trino cluster

  Try:Show me the top 10 customers by revenueTry:Count all orders placed in January 2023Try:Calculate the average order value
• list_catalogs

  List all available catalogs in the Trino cluster

  Try:What databases are available?Try:Show all catalogs in the data warehouse
• list_schemas

  List all schemas within a specific catalog

  Try:What schemas are available in the analytics catalog?Try:Show all schemas in the data warehouse
• list_tables

  List all tables within a specific catalog and schema

  Try:What tables are in the analytics.sales schema?Try:Show all tables in the production database
• get_table_schema

  Get the schema and column information for a specific table

  Try:Show me the structure of the customers tableTry:What columns are in the orders table?
• explain_query

  Get the execution plan for a SQL query

  Try:Explain how this query would run: SELECT COUNT(*) FROM ordersTry:Show me the execution plan for the monthly sales report

Comparable tools

Installation

# Homebrew
brew install tuannvm/mcp/mcp-trino

# Or one-liner (macOS/Linux)
curl -fsSL https://raw.githubusercontent.com/tuannvm/mcp-trino/main/install.sh | bash

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

FAQ

What authentication methods does mcp-trino support?

mcp-trino supports OAuth 2.1 with multiple providers: Okta, Google, Azure AD, and HMAC. It offers both native mode (zero server-side secrets) and proxy mode for centralized credential management.

Can mcp-trino be used as a CLI tool?

Yes, mcp-trino has dual functionality: it operates as both an MCP server for AI integration and an interactive CLI similar to psql for direct Trino access.

Compare mcp-trino with