广告合作
MCP.so
登录

Trino MCP Server

@stinkgen

代码仓库

基本信息

分类

其他

许可证

MIT

传输方式

stdio

作者

stinkgen

关于 Trino MCP Server

MCP Server for Trino

#trino#mcp#sql-query#ai-integration

Trino MCP Server 配置

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

{
  "mcpServers": {
    "trino_mcp": {
      "command": "python",
      "args": [
        "llm_trino_api.py"
      ]
    }
  }
}

Trino MCP Server 工具

工具列表暂未提供

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

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Trino MCP Server?

A Model Context Protocol server for Trino, providing AI models with structured access to Trino's distributed SQL query engine. It is currently a beta release (v0.1.2).

How to use Trino MCP Server?

Start the server with docker-compose up -d. Verify the API at http://localhost:9097/api/query. For a non-containerized version, run python llm_trino_api.py on port 8008. Use STDIO transport (recommended) inside the container; client scripts run on the local machine and connect via docker exec.

Key features of Trino MCP Server

  • Exposes Trino resources through the MCP protocol
  • Enables AI tools to query and analyze Trino data
  • Provides STDIO transport (reliable) and SSE transport (not recommended)
  • Offers both Docker container API and standalone Python API
  • Includes demo scripts for generating and querying test data
  • Fixed catalog handling and Docker container initialization issues

Use cases of Trino MCP Server

  • Let LLMs query Trino databases via natural language prompts
  • Run complex analytical SQL queries through AI assistants
  • Get database schema information programmatically
  • Analyze data and present results with visualizations (e.g., Mermaid charts)

常见问题

1

Which transport should I use?

STDIO transport works reliably. SSE transport has critical issues with MCP 1.3.0 and causes server crashes on client disconnection; avoid its use until a newer MCP version is integrated.

2

What are the runtime requirements?

Docker and docker-compose for the containerized version; Python for the standalone API. All scripts can run on the local machine and communicate with Docker containers via `docker exec`.

3

Where does the demo data live?

The demo data is generated by `tools/create_bullshit_data.py` and loaded into Trino's memory catalog using `load_bullshit_data.py`. The default catalog is `memory`.

4

How do I run tests?

Use `python test_mcp_stdio.py` for STDIO transport testing, or `./run_tests.sh` for automated tests. The `test_bullshit_query.py` script demonstrates complex queries through MCP.

5

Are there known limitations?

Yes. The SSE transport is broken in MCP 1.3.0. The Docker container API previously had a 503 initialization issue (now fixed). The project is in beta (v0.1.2) and may have other edge cases.

评论

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

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

ICSS

chokcoco

不止于 CSS

20.7K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

der die das – German noun genders (Lingviko)

Lingviko

The article (der, die, das) of 90,000 German nouns, compounds included, plus a checker that finds wrong articles in German text (“mit der Zug” → dem). Uses dictionary data, not AI guessing. Free, no login.

广告合作