Mcp Server Trino
What is Mcp Server Trino
mcp-server-trino is an MCP (Model-Control-Protocol) server designed to facilitate interaction with Trino, a distributed SQL query engine. It allows users to list and query tables through a Python interface, leveraging Trino’s capabilities for big data analytics.
Use cases
mcp-server-trino can be used in scenarios such as data analysis, reporting, and querying large datasets in real-time. It is suitable for data scientists and engineers who need to interact with Trino in a programmatic way.
How to use
To use mcp-server-trino, configure the necessary environment variables for Trino connection details, including host, port, user, password, catalog, and schema. Then, run the server using the provided command structure in the JSON format, ensuring the correct path to the MCP server is specified.
Key features
Key features of mcp-server-trino include the ability to list Trino tables as MCP resources, read table contents via MCP, and execute arbitrary SQL queries against Trino. It utilizes the trino Python client for seamless connectivity.
Where to use
undefined
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mcp Server Trino
mcp-server-trino is an MCP (Model-Control-Protocol) server designed to facilitate interaction with Trino, a distributed SQL query engine. It allows users to list and query tables through a Python interface, leveraging Trino’s capabilities for big data analytics.
Use cases
mcp-server-trino can be used in scenarios such as data analysis, reporting, and querying large datasets in real-time. It is suitable for data scientists and engineers who need to interact with Trino in a programmatic way.
How to use
To use mcp-server-trino, configure the necessary environment variables for Trino connection details, including host, port, user, password, catalog, and schema. Then, run the server using the provided command structure in the JSON format, ensuring the correct path to the MCP server is specified.
Key features
Key features of mcp-server-trino include the ability to list Trino tables as MCP resources, read table contents via MCP, and execute arbitrary SQL queries against Trino. It utilizes the trino Python client for seamless connectivity.
Where to use
undefined
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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>"
}
}
}
}Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
