Trino

🚀 Trino MCP Server

This repository provides an MCP (Model Control Protocol) server that allows you to list and query tables using Trino via Python.

🚀 Quick Start

✨ Features

• MCP: MCP is a protocol for connecting AI models, data, and tools. This example MCP server provides:
  • Listing Trino tables as MCP resources.
  • The ability to read table contents via MCP.
  • A tool to execute arbitrary SQL queries (for Trino).
• Trino: A fast, distributed SQL query engine for big data analysis. This server uses the Trino Python client (trino.dbapi) to connect to the specified Trino host, catalog, and schema.

📦 Installation

• Python 3.9+ (or a version compatible with mcp, trino, and asyncio).
• trino (Trino's Python driver library).
• mcp (Model Control Protocol Python library).

📚 Documentation

Configuration

The server reads Trino connection information from environment variables:

💻 Usage Examples

Basic Usage

{
  "mcpServers": {
    "trino": {
      "command": "uv",
      "args": [
        "--directory", 
        "<path_to_mcp_server_trino>",
        "run",
        "mcp_server_trino"
      ],
      "env": {
        "TRINO_HOST": "<host>",
        "TRINO_PORT": "<port>",
        "TRINO_USER": "<user>",
        "TRINO_PASSWORD": "<password>",
        "TRINO_CATALOG": "<catalog>",
        "TRINO_SCHEMA": "<schema>"
      }
    }
  }
}