mcp-trino

mcp-trino

3.5

If you are the rightful owner of mcp-trino and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

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

The Trino MCP Server in Go is a robust implementation of a Model Context Protocol (MCP) server designed to facilitate seamless interaction between AI assistants and Trino's distributed SQL query engine. Trino, formerly known as PrestoSQL, is renowned for its ability to perform fast analytics on large datasets. This project leverages the power of Go to provide a high-performance server that supports various MCP tools, enabling efficient SQL query execution, catalog discovery, and more. The server is compatible with multiple platforms and supports both STDIO and HTTP transports, including Server-Sent Events (SSE) for enhanced client interaction. It is designed to integrate with popular AI applications like Cursor, Claude Desktop, Windsurf, and ChatWise, making it a versatile tool for data exploration and analysis.

Features

  • 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

  1. execute_query

    Execute a SQL query against Trino with full SQL support for complex analytical queries.

  2. list_catalogs

    List all catalogs available in the Trino server.

  3. list_schemas

    List all schemas in a catalog.

  4. list_tables

    List all tables in a schema.

  5. get_table_schema

    Get the schema of a table.