mcp-server-trino

MCP Server for Trino

18 stars PythonServers & Infrastructure Updated Sep 25, 2025

Documentation

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:
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

json

{
  "mcpServers": {
    "trino": {
      "command": "uv",
      "args": [
        "--directory", 
        "",
        "run",
        "mcp_server_trino"
      ],
      "env": {
        "TRINO_HOST": "",
        "TRINO_PORT": "",
        "TRINO_USER": "",
        "TRINO_PASSWORD": "",
        "TRINO_CATALOG": "",
        "TRINO_SCHEMA": ""
      }
    }
  }
}

Frequently asked questions

What is mcp-server-trino?

mcp-server-trino is MCP Server for Trino

How do I install mcp-server-trino?

Open the GitHub repository and follow its README. Most MCP servers are added to your client's MCP config, then called by your agent.

Is mcp-server-trino open source?

Yes — it is hosted on GitHub at https://github.com/Dataring-engineering/mcp-server-trino and has 18 stars.

Related MCP tools

damn-vulnerable-mcp-server

Damn Vulnerable MCP Server Python-based implementation. Trusted by 1200+ developers. Trusted by 1200+ developers. Trusted by 1200+ developers.

1,209 Python

mysql_mcp_server

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases Python-based implementation. Trusted by 900+ developers.

964 Python

aimcpmodel-context-protocol+1

supabase-mcp-server

Query MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support, automatic migration versioning...

805 Python

cursormodel-context-protocolsupabase+1