Trino MCP Server
@Dataring-engineering
About Trino MCP Server
MCP Server for Trino
Basic information
Config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryTools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Trino MCP Server?
A Model Context Protocol (MCP) server that lists and queries tables via Trino using Python. It provides Trino tables as MCP resources, allows reading their contents, and includes a tool for executing arbitrary SQL queries against Trino. Designed for AI models that need to interact with Trino’s fast, distributed SQL query engine for big data analytics.
How to use Trino MCP Server?
Configure connection via environment variables (TRINO_HOST, TRINO_PORT, TRINO_USER, TRINO_PASSWORD, TRINO_CATALOG, TRINO_SCHEMA), then add the server to your MCP client configuration using uv as the command. The server reads these variables at startup and connects to the specified Trino host, catalog, and schema.
Key features of Trino MCP Server
- Lists Trino tables as MCP resources.
- Reads table contents through MCP.
- Provides a tool for arbitrary SQL queries.
- Connects to any Trino host, catalog, and schema.
- Uses the official Trino Python driver (
trino.dbapi).
Use cases of Trino MCP Server
- Query big data analytics datasets via AI assistants.
- Explore available tables and schemas in a Trino cluster.
- Enable natural language querying of Trino data through MCP‑compatible clients.
FAQ from Trino MCP Server
What Python version and dependencies are required?
Python 3.9+ and the packages trino, mcp, and asyncio.
How do I configure the connection to Trino?
Set the environment variables TRINO_HOST, TRINO_PORT, TRINO_USER, TRINO_CATALOG, and TRINO_SCHEMA. TRINO_PASSWORD is optional depending on your authentication setup.
Can I use authentication other than a password?
The server supports an optional password via the TRINO_PASSWORD variable, but the README does not describe other authentication methods.
What operations can the server perform?
It can list available Trino tables, read their contents, and execute arbitrary SQL queries through MCP.
Where do the environment variables default to?
TRINO_HOST defaults to localhost, TRINO_PORT defaults to 8080. All other connection variables are required except TRINO_PASSWORD, which defaults to empty.
More Other MCP servers
Awesome-MCP-ZH
yzflyMCP 资源精选, MCP指南,Claude MCP,MCP Servers, MCP Clients
MCP Toolbox for Databases
googleapisMCP Toolbox for Databases is an open source MCP server for databases.
ICSS
chokcoco不止于 CSS
🪟 Windows-MCP
CursorTouchMCP Server for Computer Use in Windows
MaxKB
1Panel-dev🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。
Comments