Skip to main content
Glama
Sign In
enesjakozh

Trino MCP Server

by Dataring-engineering
GitHub
Python
MIT License
13
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Integrations

  • 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

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.

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:

VariableDescriptionDefault
TRINO_HOSTTrino server hostname or IPlocalhost
TRINO_PORTTrino server port8080
TRINO_USERTrino user namerequired
TRINO_PASSWORDTrino password (optional, depends on your authentication setup)(empty)
TRINO_CATALOGDefault catalog to use (e.g., hive, tpch, postgresql, etc.)required
TRINO_SCHEMADefault 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>" } } } }

This server cannot be installed

-
security - not tested
A
license - permissive license
-
quality - not tested

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

An MCP server that enables listing and querying Trino tables using Python, providing access to data resources through the Model-Control-Protocol.

  1. Overview
    1. Requirements
      1. Configuration
        1. Usage

          Related Resources

          Related MCP Servers

          • Unstructured API MCP Serverofficial

            Unstructured-IO
            A
            security
            F
            license
            A
            quality
            An MCP server implementation that enables interaction with the Unstructured API, providing tools to list, create, update, and manage sources, destinations, and workflows.
            Last updated -
            39
            21
            • Apple

          • database-mcp

            TheRaLabs
            -
            security
            F
            license
            -
            quality
            A server that helps people access and query data in databases using the Query Runner with integration of the Model Context Protocol (MCP) Python SDK. Support databases including PostgreSQL Redshift MySQL Microsoft SQL Server Google APIs Amazon Web Services (via boto3) CockroachDB SQLite
            Last updated -
            6
            Python
            GPL 3.0
            • Linux
            • Apple

          • IcebergMCP

            ryft-io
            -
            security
            -
            license
            -
            quality
            An MCP server that enables natural language interaction with Apache Iceberg data lakehouses, allowing users to query table metadata, schemas, and properties through Claude, Cursor, or other MCP clients.
            Last updated -
            31
            Python
            Apache 2.0

          • MCP Trino Server

            alaturqua
            -
            security
            A
            license
            -
            quality
            A Model Context Protocol server that provides seamless integration with Trino and Iceberg, enabling data exploration, querying, and table maintenance through a standard interface.
            Last updated -
            14
            Python
            Apache 2.0

          View all related MCP servers

          Appeared in Searches

          ID: m94exir35y