Trino MCP Server - Find Mcp Servers and Clients

Trino MCP Server

This repository provides an MCP (Model-Control-Protocol) server that allows you to list and query tables via Trino using Python. It bridges AI models, data, and tools.

Overview

MCP: This 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 uses 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