mcp-server-trino

mcp-server-trino

14
databases

The Trino MCP Server is a Model-Control-Protocol server designed to interact with Trino, allowing users to list, query, and read table contents using Python. It facilitates big data analytics through Trino's distributed SQL engine.

Trino MCP Server

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

Overview

  • MCP: MCP is a protocol for bridging AI models, data, and tools. This example MCP server provides:
    • A list of Trino tables as MCP resources
    • Ability to read table contents through MCP
    • A tool for executing arbitrary SQL queries against Trino
  • Trino: A fast, distributed SQL query engine for big data analytics. This server makes use of Trino’s Python client (trino.dbapi) to connect to a Trino host, catalog, and schema.

Requirements

  • Python 3.9+ (or a version compatible with mcp, trino, and asyncio)
  • trino (the Python driver for Trino)
  • mcp (the Model-Control-Protocol Python library)

Configuration

The server reads Trino connection details from environment variables:

VariableDescriptionDefault
TRINO_HOSTTrino server hostname or IPlocalhost
TRINO_PORTTrino server port8080
TRINO_USERTrino user namerequired
TRINO_PASSWORDTrino password (optional, depends on your authentication setup)(empty)
TRINO_CATALOGDefault catalog to use (e.g., hive, tpch, postgresql, etc.)required
TRINO_SCHEMADefault schema to use (e.g., default, public, etc.)required

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>"
      }
    }
  }
}