広告掲載
MCP.so
ログイン

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

よくある質問

1

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.

2

What are the runtime requirements?

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

3

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.

4

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.

5

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`.

コメント

「その他」の他のコンテンツ

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

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

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

広告掲載