Trino MCP Server

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.