Trino MCP Server

Example Use Cases

• 1

  Securely query Trino clusters with support for OAuth2 and Azure SPN authentication.

• 2

  Execute read-only or write SQL queries with safety controls to prevent unintended data modification.

• 3

  Export query results to files to avoid hallucination and enable accurate downstream processing.

Description

Trino MCP Server provides a simple interface to interact with Trino query engine, supporting OAuth2, Azure Service Principal, basic auth, or no authentication. It offers core Trino operations like querying catalogs, schemas, tables, and executing SQL with safety features such as double-write protection and query watermarking. The server supports exporting query results to files to prevent LLM hallucination and is compatible with tools like uvx and VS Code for easy integration.