Which integrations are available for this server?

Mentioned as a possible catalog type that can be used with Trino through the MCP server Mentioned as a possible catalog type that can be used with Trino through the MCP server Allows users to list tables, read table contents, and execute arbitrary SQL queries against a Trino database through an MCP server

How do I use Trino MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Trino MCP Server show me the top 10 customers by total sales" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

Trino MCP Server

This repository provides an MCP (Model-Control-Protocol) server that allows you to list and query tables via Trino using Python.

Overview

MCP: MCP is a protocol for bridging AI models, data, and tools. This example MCP server provides:
- A list of Trino tables as MCP resources
- Ability to read table contents through MCP
- A tool for executing arbitrary SQL queries against Trino
Trino: A fast, distributed SQL query engine for big data analytics. This server makes use of Trino’s Python client (trino.dbapi) to connect to a Trino host, catalog, and schema.

Related MCP server: MCP Trino Server

Requirements

Python 3.9+ (or a version compatible with mcp, trino, and asyncio)
trino (the Python driver for Trino)
mcp (the Model-Control-Protocol Python library)

Configuration

The server reads Trino connection details from environment variables:

Variable	Description	Default
`TRINO_HOST`	Trino server hostname or IP	`localhost`
`TRINO_PORT`	Trino server port	`8080`
`TRINO_USER`	Trino user name	required
`TRINO_PASSWORD`	Trino password (optional, depends on your authentication setup)	(empty)
`TRINO_CATALOG`	Default catalog to use (e.g., `hive`, `tpch`, `postgresql`, etc.)	required
`TRINO_SCHEMA`	Default schema to use (e.g., `default`, `public`, etc.)	required

Usage

{
  "mcpServers": {
    "trino": {
      "command": "uv",
      "args": [
        "--directory", 
        "<path_to_mcp_server_trino>",
        "run",
        "mcp_server_trino"
      ],
      "env": {
        "TRINO_HOST": "<host>",
        "TRINO_PORT": "<port>",
        "TRINO_USER": "<user>",
        "TRINO_PASSWORD": "<password>",
        "TRINO_CATALOG": "<catalog>",
        "TRINO_SCHEMA": "<schema>"
      }
    }
  }
}