Pinot MCP Server

@startreedata

代码仓库

基本信息

分类

其他

许可证

Apache-2.0

传输方式

stdio

作者

startreedata

关于 Pinot MCP Server

MCP Server for Apache Pinot

#mcp-pinot#apache-pinot#data-analytics

Pinot MCP Server 配置

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

{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "-e",
        ".",
        "#",
        "Install",
        "dependencies"
      ]
    }
  }
}

Pinot MCP Server 工具

工具列表暂未提供

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

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

概览

What is Pinot MCP Server?

A Python-based MCP server for interacting with Apache Pinot, built using the FastMCP framework. It integrates with Claude Desktop to enable real-time analytics and metadata queries on a Pinot cluster, allowing users to list tables, segments, schema info, execute read-only SQL queries, and view index/column-level metadata.

How to use Pinot MCP Server?

Clone the repository, install dependencies with uv, configure a .env file for the Pinot cluster connection, then run the server. It supports stdio transport for Claude Desktop and HTTP transport for other clients with optional OAuth authentication.

Key features of Pinot MCP Server

List tables, segments, and schema info from Pinot
Execute read-only SQL queries with automatic validation
View index and column-level metadata
Optional table filtering with glob patterns
Multiple transport modes (stdio, HTTP, HTTPS with OAuth)
Read-only query enforcement (SELECT/WITH only)

Use cases of Pinot MCP Server

Business users analyzing Pinot data through Claude Desktop
Real-time analytics and metadata queries on Pinot clusters
Multi-tenant environments with table filtering per team
Environment-specific deployments (dev, staging, prod) showing relevant tables only

常见问题

What is the difference between Pinot MCP Server and directly querying Pinot?

It provides an MCP interface for Claude Desktop and other MCP clients, with read-only enforcement, table filtering, and metadata discovery tools that abstract away direct Pinot API calls.

What are the runtime requirements?

Python, the uv package manager, and access to a running Pinot cluster with controller and broker endpoints.

Does Pinot MCP Server support authentication?

Yes. It supports basic authentication via `PINOT_USERNAME`/`PINOT_PASSWORD`, token-based auth via `PINOT_TOKEN` or `PINOT_TOKEN_FILENAME`, and OAuth for the MCP server endpoint when exposing it remotely.

How does table filtering work?

Table filtering uses a YAML file with glob patterns to limit which tables are visible across all MCP operations. It is a convenience feature for organizing tables, not a security boundary.

Can I use Pinot MCP Server over HTTP or HTTPS?

Yes, set `MCP_TRANSPORT=http`. For remote access (non-loopback host) you must enable OAuth; TLS can be configured via `MCP_SSL_KEYFILE` and `MCP_SSL_CERTFILE`.

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

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