Apache Pinot MCP Server MCP Server

Name: Apache Pinot MCP Server MCP Server
Author: io.github.startreedata

io.github.startreedata/mcp-pinot

Repository Registry

What is the Apache Pinot MCP Server MCP server?

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

How to install Apache Pinot MCP Server

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

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

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "<YOUR_PINOT_CONTROLLER_URL>",
        "PINOT_BROKER_URL": "<YOUR_PINOT_BROKER_URL>",
        "PINOT_USERNAME": "<YOUR_PINOT_USERNAME>",
        "PINOT_PASSWORD": "<YOUR_PINOT_PASSWORD>",
        "PINOT_TOKEN": "<YOUR_PINOT_TOKEN>",
        "PINOT_USE_MSQE": "<YOUR_PINOT_USE_MSQE>",
        "MCP_TRANSPORT": "<YOUR_MCP_TRANSPORT>",
        "AUTH_PROVIDER": "<YOUR_AUTH_PROVIDER>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "<YOUR_PINOT_CONTROLLER_URL>",
        "PINOT_BROKER_URL": "<YOUR_PINOT_BROKER_URL>",
        "PINOT_USERNAME": "<YOUR_PINOT_USERNAME>",
        "PINOT_PASSWORD": "<YOUR_PINOT_PASSWORD>",
        "PINOT_TOKEN": "<YOUR_PINOT_TOKEN>",
        "PINOT_USE_MSQE": "<YOUR_PINOT_USE_MSQE>",
        "MCP_TRANSPORT": "<YOUR_MCP_TRANSPORT>",
        "AUTH_PROVIDER": "<YOUR_AUTH_PROVIDER>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "<YOUR_PINOT_CONTROLLER_URL>",
        "PINOT_BROKER_URL": "<YOUR_PINOT_BROKER_URL>",
        "PINOT_USERNAME": "<YOUR_PINOT_USERNAME>",
        "PINOT_PASSWORD": "<YOUR_PINOT_PASSWORD>",
        "PINOT_TOKEN": "<YOUR_PINOT_TOKEN>",
        "PINOT_USE_MSQE": "<YOUR_PINOT_USE_MSQE>",
        "MCP_TRANSPORT": "<YOUR_MCP_TRANSPORT>",
        "AUTH_PROVIDER": "<YOUR_AUTH_PROVIDER>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "mcp-pinot": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "<YOUR_PINOT_CONTROLLER_URL>",
        "PINOT_BROKER_URL": "<YOUR_PINOT_BROKER_URL>",
        "PINOT_USERNAME": "<YOUR_PINOT_USERNAME>",
        "PINOT_PASSWORD": "<YOUR_PINOT_PASSWORD>",
        "PINOT_TOKEN": "<YOUR_PINOT_TOKEN>",
        "PINOT_USE_MSQE": "<YOUR_PINOT_USE_MSQE>",
        "MCP_TRANSPORT": "<YOUR_MCP_TRANSPORT>",
        "AUTH_PROVIDER": "<YOUR_AUTH_PROVIDER>"
      }
    }
  }
}

Claude Code

claude mcp add mcp-pinot --env PINOT_CONTROLLER_URL=<YOUR_PINOT_CONTROLLER_URL> --env PINOT_BROKER_URL=<YOUR_PINOT_BROKER_URL> --env PINOT_USERNAME=<YOUR_PINOT_USERNAME> --env PINOT_PASSWORD=<YOUR_PINOT_PASSWORD> --env PINOT_TOKEN=<YOUR_PINOT_TOKEN> --env PINOT_USE_MSQE=<YOUR_PINOT_USE_MSQE> --env MCP_TRANSPORT=<YOUR_MCP_TRANSPORT> --env AUTH_PROVIDER=<YOUR_AUTH_PROVIDER> -- uvx mcp-pinot-server