What is MCP?
MCP (Model-Control-Protocol) is a protocol for bridging AI models, data, and tools. This server implements MCP to expose Trino tables and query capabilities.
Trino MCP Server
@MCP-Mirror
Basic information
About Trino MCP Server
Mirror of
Trino MCP Server config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryTrino MCP Server tools
Tool list not available yet
This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.
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?
This server provides an MCP (Model-Control-Protocol) interface for listing and querying tables via Trino using Python. It connects to a Trino host using the trino.dbapi Python client and exposes tables as MCP resources, allows reading table contents, and provides a tool to execute arbitrary SQL queries. It is intended for AI models and MCP clients that need to interact with Trino data sources.
How to use Trino MCP Server?
Configure the required Trino connection details via environment variables (TRINO_HOST, TRINO_PORT, TRINO_USER, TRINO_CATALOG, TRINO_SCHEMA, optionally TRINO_PASSWORD). Then run the server by adding it to your MCP client configuration using uv with the command uv --directory <path_to_server> run mcp_server_trino and the necessary environment variables.
Key features of Trino MCP Server
- List Trino tables as MCP resources.
- Read table contents through MCP.
- Execute arbitrary SQL queries via a tool.
- Connects using Trino’s Python client (
trino.dbapi). - Fully configurable via environment variables.
Use cases of Trino MCP Server
- AI assistants exploring and querying Trino data catalogs.
- Listing available tables in a Trino schema from an MCP client.
- Running ad‑hoc SQL queries against Trino through AI tools.
- Integrating big data analytics with conversational AI workflows.
Frequently asked questions
What environment variables are required?
You must set `TRINO_HOST`, `TRINO_PORT`, `TRINO_USER`, `TRINO_CATALOG`, and `TRINO_SCHEMA`. `TRINO_PASSWORD` is optional and depends on your Trino authentication setup.
What dependencies does the server need?
Python 3.9+ along with the `trino` and `mcp` Python packages.
Can I run SQL queries other than SELECT?
Yes, the server includes a tool for executing arbitrary SQL queries against Trino, subject to Trino’s permissions.
How does the server connect to Trino?
It uses the `trino.dbapi` Python client and requires a host, port, user, catalog, and schema. Password authentication is optional.
More Other MCP servers
Codelf
unbugA search tool helps dev to solve the naming things problem.
14.2K
Volley.sh
VolleyA good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi
🚀 Model Context Protocol (MCP) Curriculum for Beginners
microsoftThis open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,
16.7K
YOUB
Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov
Lemon.io
lemon-ioRequest dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3
Comments