广告合作
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 服务器

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K
广告合作