About Trino MCP Server
Trino MCP Server connects MCP clients to Trino for table discovery and SQL queries. It exposes table data as resources and arbitrary SQL execution as a tool.
Key features
- 01List Trino tables
- 02Read table contents
- 03Execute SQL queries
- 04Configure Trino connection via environment variables
Use cases
- 01Discover tables in a Trino catalog and schema
- 02Read table data through an MCP client
- 03Run SQL against Trino for analytics
MCP support
Exposes Trino tables as MCP resources and provides a tool for executing SQL queries against Trino.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMETrino 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>"
}
}
}
}
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.