mcp-server-trino

Dataring-engineering/mcp-server-trino

🔗 Latest commit:9acf767

🕒 Updated:Sep 9, 2025, 01:05 PM

Python

Development

MCP Server for Trino

MCP Trust Score

Based on our comprehensive evaluation criteria

🤖 Evaluated by gemini-2.5-flashFix

Trust Score48/100

• Core MCP protocol features implemented (20/40)
• Room for improvement in GitHub community
• Optimal dependency management (20/20)
• Room for improvement in deployment maturity
• Documentation (8/8)
• Archestra MCP Trust score badge is missing

GitHub Metrics

Repository statistics and activity

⭐ GitHub Stars:17

👥 Contributors:1

📋 Total Issues:0

📦 Has Releases:No

🔧 Has CI/CD Pipeline:No

Configuration

Configuration example extracted from README.md for Claude Desktop and other clients.

🤖 Evaluated by gemini-2.5-flashFix

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

MCP Protocol Support

Implemented MCP protocol features

🤖 Evaluated by gemini-2.5-flashFix

Tools:✓

Prompts:✗

Resources:✓

Sampling:✗

Roots:✗

Logging:✗

STDIO Transport:✓

HTTP Transport:✗

OAuth2 Auth:✗

Dependencies

2 dependencies

Libraries and frameworks used by this MCP server

🤖 Evaluated by gemini-2.5-flashFix

Main

mcp

trino

README.md

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:

Variable	Description	Default
`TRINO_HOST`	Trino server hostname or IP	`localhost`
`TRINO_PORT`	Trino server port	`8080`
`TRINO_USER`	Trino user name	required
`TRINO_PASSWORD`	Trino password (optional, depends on your authentication setup)	(empty)
`TRINO_CATALOG`	Default catalog to use (e.g., `hive`, `tpch`, `postgresql`, etc.)	required
`TRINO_SCHEMA`	Default 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>"
      }
    }
  }
}

Resources

GitHub Repository

Add Quality Badge

Show your MCP trust score in your README

[![Trust Score](https://archestra.ai/mcp-catalog/api/badge/quality/Dataring-engineering/mcp-server-trino)](https://archestra.ai/mcp-catalog/dataring-engineering__mcp-server-trino)

Edit This Server Add New MCP Server Report an Issue

README.md

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:

Variable	Description	Default
`TRINO_HOST`	Trino server hostname or IP	`localhost`
`TRINO_PORT`	Trino server port	`8080`
`TRINO_USER`	Trino user name	required
`TRINO_PASSWORD`	Trino password (optional, depends on your authentication setup)	(empty)
`TRINO_CATALOG`	Default catalog to use (e.g., `hive`, `tpch`, `postgresql`, etc.)	required
`TRINO_SCHEMA`	Default 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>"
      }
    }
  }
}