MCP.so
登录

MCP Trino Server

@alaturqua

基本信息

分类

其他

许可证

Apache-2.0

传输方式

stdio

作者

alaturqua

关于 MCP Trino Server

MCP Server for Trino developed via MCP Python SDK

MCP Trino Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-trino-python": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@alaturqua/mcp-trino-python",
        "--client",
        "claude"
      ]
    }
  }
}

MCP Trino Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is MCP Trino Server?

MCP Trino Server is a Model Context Protocol (MCP) server that provides seamless integration with Trino and Iceberg, enabling advanced data exploration, querying, and table maintenance through a standard interface. It is designed for developers and data engineers building AI‑powered tools that interact with Trino databases.

How to use MCP Trino Server?

Install via uv, pip, or Docker, then configure using environment variables (TRINO_HOST, TRINO_PORT, TRINO_USER, etc.). Run the server with python src/server.py (or the Docker equivalent) using one of three transport modes: stdio (default), streamable‑http, or sse. Connect an MCP client (e.g., VS Code or Claude Desktop) by providing the server’s command and configuration.

Key features of MCP Trino Server

  • Execute SQL queries with formatted results
  • Browse catalogs, schemas, and tables hierarchically
  • Perform Iceberg table maintenance (optimize, expire snapshots)
  • Inspect Iceberg metadata (snapshots, manifests, partitions, files)
  • Supports stdio, streamable‑HTTP, and SSE transports
  • Configurable via environment variables or .env file

Use cases of MCP Trino Server

  • Interactive data exploration and analysis in Trino
  • Automated Iceberg table maintenance and optimization
  • Building AI‑powered tools that interact with Trino databases
  • Executing and managing SQL queries with proper result formatting

常见问题

1

What are the prerequisites to run MCP Trino Server?

You need Python 3.12 or higher and a running Trino server (Docker Compose is available for local development). Docker is optional but recommended for containerized deployment.

2

What transport modes are supported?

The server supports `stdio` (default, for local MCP clients like VS Code and Claude Desktop), `streamable‑http` (for remote or web access), and `sse` (Server‑Sent Events, legacy HTTP transport).

3

How do I configure the server?

Configure via environment variables: `TRINO_HOST`, `TRINO_PORT`, `TRINO_USER`, `TRINO_CATALOG`, `TRINO_SCHEMA`, `TRINO_HTTP_SCHEME`, and optionally `TRINO_PASSWORD`. You can also use a `.env` file.

4

Does the server support authentication to Trino?

Yes, you can set the `TRINO_PASSWORD` environment variable to provide a password for authentication to the Trino server.

5

Can I deploy the server in a container?

Yes. Build the Docker image with `docker build -t mcp-trino-python .` and run it with either `stdio` or `streamable‑http` transport. Docker Compose profiles are also provided for quick start.

评论

其他 分类下的更多 MCP 服务器