Trino MCP server

This MCP server provides access to Trino tables and allows you to execute SQL queries through the Model Control Protocol (MCP). The server connects to a Trino database and exposes its tables as MCP resources, enabling seamless integration with AI models and other MCP-compatible tools.

Installation Requirements

Before using the MCP server, ensure you have:

• Python 3.9 or newer
• The Trino Python driver
• The MCP Python library

You can install the required dependencies using pip:

pip install trino mcp

Configuration

The server uses environment variables for configuration. Set the following variables before starting the server:

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 (if authentication is enabled)	(empty)
TRINO_CATALOG	Default catalog (e.g., hive, tpch)	required
TRINO_SCHEMA	Default schema (e.g., default, public)	required

Running the Server

You can run the MCP server using the uv command with appropriate environment variables. Add the server configuration to your MCP configuration file:

{
  "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>"
      }
    }
  }
}

Replace the placeholder values (<host>, <port>, etc.) with your actual Trino connection details.

Using the MCP Server

Once configured and running, the MCP server provides:

• Access to all tables in your specified Trino catalog and schema as MCP resources
• The ability to read table contents through the MCP protocol
• A tool for executing arbitrary SQL queries against your Trino database

The server automatically discovers available tables in your configured catalog and schema, making them available as resources through the MCP interface.

How to install this MCP server

For Claude Code

To add this MCP server to Claude Code, run this command in your terminal:

claude mcp add-json "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>"}}'

See the official Claude Code MCP documentation for more details.

For Cursor

There are two ways to add an MCP server to Cursor. The most common way is to add the server globally in the ~/.cursor/mcp.json file so that it is available in all of your projects.

If you only need the server in a single project, you can add it to the project instead by creating or adding it to the .cursor/mcp.json file.

Adding an MCP server to Cursor globally

To add a global MCP server go to Cursor Settings > Tools & Integrations and click "New MCP Server".

When you click that button the ~/.cursor/mcp.json file will be opened and you can add your server like this:

{
    "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>"
            }
        }
    }
}

Adding an MCP server to a project

To add an MCP server to a project you can create a new .cursor/mcp.json file or add it to the existing one. This will look exactly the same as the global MCP server example above.

How to use the MCP server

Once the server is installed, you might need to head back to Settings > MCP and click the refresh button.

The Cursor agent will then be able to see the available tools the added MCP server has available and will call them when it needs to.

You can also explicitly ask the agent to use the tool by mentioning the tool name and describing what the function does.

For Claude Desktop

To add this MCP server to Claude Desktop:

1. Find your configuration file:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• Windows: %APPDATA%\Claude\claude_desktop_config.json
• Linux: ~/.config/Claude/claude_desktop_config.json

2. Add this to your configuration file:

{
    "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>"
            }
        }
    }
}

3. Restart Claude Desktop for the changes to take effect