Pinot MCP Server

Name: Pinot MCP Server
Author: startreedata

@startreedata

Repository

About Pinot MCP Server

MCP Server for Apache Pinot

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

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

FAQ from Pinot MCP Server

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.