Trino MCP Server

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.