广告合作
MCP.so
登录

Trino MCP Server

@MCP-Mirror

代码仓库

基本信息

分类

其他

许可证

MIT license

传输方式

stdio

作者

MCP-Mirror

关于 Trino MCP Server

Mirror of

#trino#mcp-server#data-query

Trino MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

Trino MCP Server 工具

工具列表暂未提供

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

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

概览

What is Trino MCP Server?

This server provides an MCP (Model-Control-Protocol) interface for listing and querying tables via Trino using Python. It connects to a Trino host using the trino.dbapi Python client and exposes tables as MCP resources, allows reading table contents, and provides a tool to execute arbitrary SQL queries. It is intended for AI models and MCP clients that need to interact with Trino data sources.

How to use Trino MCP Server?

Configure the required Trino connection details via environment variables (TRINO_HOST, TRINO_PORT, TRINO_USER, TRINO_CATALOG, TRINO_SCHEMA, optionally TRINO_PASSWORD). Then run the server by adding it to your MCP client configuration using uv with the command uv --directory <path_to_server> run mcp_server_trino and the necessary environment variables.

Key features of Trino MCP Server

  • List Trino tables as MCP resources.
  • Read table contents through MCP.
  • Execute arbitrary SQL queries via a tool.
  • Connects using Trino’s Python client (trino.dbapi).
  • Fully configurable via environment variables.

Use cases of Trino MCP Server

  • AI assistants exploring and querying Trino data catalogs.
  • Listing available tables in a Trino schema from an MCP client.
  • Running ad‑hoc SQL queries against Trino through AI tools.
  • Integrating big data analytics with conversational AI workflows.

常见问题

1

What is MCP?

MCP (Model-Control-Protocol) is a protocol for bridging AI models, data, and tools. This server implements MCP to expose Trino tables and query capabilities.

2

What environment variables are required?

You must set `TRINO_HOST`, `TRINO_PORT`, `TRINO_USER`, `TRINO_CATALOG`, and `TRINO_SCHEMA`. `TRINO_PASSWORD` is optional and depends on your Trino authentication setup.

3

What dependencies does the server need?

Python 3.9+ along with the `trino` and `mcp` Python packages.

4

Can I run SQL queries other than SELECT?

Yes, the server includes a tool for executing arbitrary SQL queries against Trino, subject to Trino’s permissions.

5

How does the server connect to Trino?

It uses the `trino.dbapi` Python client and requires a host, port, user, catalog, and schema. Password authentication is optional.

评论

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

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

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

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.

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

广告合作