Apache Pinot MCP Server

io.github.startreedata/mcp-pinot · v5.0.0

Query and manage Apache Pinot through MCP with typed tools and preview-first safety.

Website Source code Set it up

Connect Runs on your machine

Terminal

claude mcp add mcp-pinot -e PINOT_CONTROLLER_URL=<PINOT_CONTROLLER_URL> -e PINOT_BROKER_URL=<PINOT_BROKER_URL> -e PINOT_USERNAME=<PINOT_USERNAME> -e PINOT_PASSWORD=<PINOT_PASSWORD> -e PINOT_TOKEN=<PINOT_TOKEN> -e PINOT_USE_MSQE=<PINOT_USE_MSQE> -e MCP_TRANSPORT=<MCP_TRANSPORT> -e AUTH_PROVIDER=<AUTH_PROVIDER> -- uvx mcp-pinot-server==5.0.0

claude_desktop_config.json

{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server==5.0.0"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "<PINOT_CONTROLLER_URL>",
        "PINOT_BROKER_URL": "<PINOT_BROKER_URL>",
        "PINOT_USERNAME": "<PINOT_USERNAME>",
        "PINOT_PASSWORD": "<PINOT_PASSWORD>",
        "PINOT_TOKEN": "<PINOT_TOKEN>",
        "PINOT_USE_MSQE": "<PINOT_USE_MSQE>",
        "MCP_TRANSPORT": "<MCP_TRANSPORT>",
        "AUTH_PROVIDER": "<AUTH_PROVIDER>"
      }
    }
  }
}

~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server==5.0.0"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "<PINOT_CONTROLLER_URL>",
        "PINOT_BROKER_URL": "<PINOT_BROKER_URL>",
        "PINOT_USERNAME": "<PINOT_USERNAME>",
        "PINOT_PASSWORD": "<PINOT_PASSWORD>",
        "PINOT_TOKEN": "<PINOT_TOKEN>",
        "PINOT_USE_MSQE": "<PINOT_USE_MSQE>",
        "MCP_TRANSPORT": "<MCP_TRANSPORT>",
        "AUTH_PROVIDER": "<AUTH_PROVIDER>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "mcp-pinot": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-pinot-server==5.0.0"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "<PINOT_CONTROLLER_URL>",
        "PINOT_BROKER_URL": "<PINOT_BROKER_URL>",
        "PINOT_USERNAME": "<PINOT_USERNAME>",
        "PINOT_PASSWORD": "<PINOT_PASSWORD>",
        "PINOT_TOKEN": "<PINOT_TOKEN>",
        "PINOT_USE_MSQE": "<PINOT_USE_MSQE>",
        "MCP_TRANSPORT": "<MCP_TRANSPORT>",
        "AUTH_PROVIDER": "<AUTH_PROVIDER>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

Name	Description
`PINOT_CONTROLLER_URL` Optional	HTTP(S) endpoint of the Pinot Controller.
`PINOT_BROKER_URL` Optional	HTTP(S) endpoint of the Pinot Broker.
`PINOT_USERNAME` Optional	Optional Pinot basic-auth username.
`PINOT_PASSWORD` Optional, secret	Optional Pinot basic-auth password.
`PINOT_TOKEN` Optional, secret	Optional Pinot bearer token. Overrides username and password when set.
`PINOT_USE_MSQE` Optional	Whether to enable Pinot multi-stage query engine support.
`MCP_TRANSPORT` Optional	Transport mode: 'stdio' (default, for desktop clients) or 'http'.
`AUTH_PROVIDER` Optional	Inbound auth provider for HTTP transport (e.g. 'oauth'); required to bind a non-loopback host.

Details

Package	`[email protected]` (PYPI, stdio)
Package	`ghcr.io/startreedata/mcp-pinot:5.0.0` (OCI, stdio)
First published	12 Oct 2026
Last updated	12 Oct 2026
Registry name	`io.github.startreedata/mcp-pinot`

More other servers See all

Live status

Local install

Installed and run on your own machine, so there is no public endpoint to check.

Pair it with live search

Agents that use Apache Pinot MCP Server often also need current facts. NestDaddy MCP gives your AI today's internet: web search, real-time breaking news and full page reading in one connector.

See NestDaddy MCP

For maintainers

[![NestDaddy MCP](https://nestdaddy.com/mcp/servers/io-github-startreedata-mcp-pinot/badge.svg)](https://nestdaddy.com/mcp/servers/io-github-startreedata-mcp-pinot)

Add the badge to your README. It turns green while your server passes our daily check. Listing details come from the official MCP registry; update them there.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.