Mcp Server Trino

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

``` json { "mcpServers": { "trino": { "command": "uv", "args": [ "--directory", "", "run", "mcpservertrino" ], "env": { "TRINOHOST": "", "TRINOPORT": "", "TRINOUSER": "", "TRINOPASSWORD": "", "TRINOCATALOG": "", "TRINOSCHEMA": "" } } } }

## Source & license

This open-source MCP server is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [Dataring-engineering](https://github.com/Dataring-engineering)
- **Source:** [Dataring-engineering/mcp-server-trino](https://github.com/Dataring-engineering/mcp-server-trino)
- **License:** MIT

Install and usage instructions live in the source repository linked above.