Dataring Engineering MCP Server Trino

🚀 Trino MCP Server

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

🚀 Quick Start

This Trino MCP server offers a convenient way to interact with Trino tables using Python. It leverages the MCP protocol to bridge AI models, data, and tools, enabling operations such as listing tables and executing SQL queries.

✨ Features

MCP Features

• Resource Listing: Lists Trino tables as MCP resources.
• Table Reading: Enables reading table contents through MCP.
• SQL Query Execution: Provides a tool to execute arbitrary SQL queries against Trino.

Trino Features

Trino is a fast, distributed SQL query engine for big data analysis. This server uses the Trino Python client (trino.dbapi) to connect to Trino hosts, catalogs, and schemas.

📦 Installation

Requirements

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

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