Skip to content
VS Code

Apache Pinot MCP Server for VS Code

io.github.startreedata/mcp-pinot

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

client:VS Code transport:stdio runtime:pypi

Install Apache Pinot MCP Server in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "pinot-controller-url",
      "description": "PINOT_CONTROLLER_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pinot-broker-url",
      "description": "PINOT_BROKER_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pinot-username",
      "description": "PINOT_USERNAME",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pinot-password",
      "description": "PINOT_PASSWORD",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pinot-token",
      "description": "PINOT_TOKEN",
      "password": true
    },
    {
      "type": "promptString",
      "id": "pinot-use-msqe",
      "description": "PINOT_USE_MSQE",
      "password": true
    },
    {
      "type": "promptString",
      "id": "mcp-transport",
      "description": "MCP_TRANSPORT",
      "password": true
    },
    {
      "type": "promptString",
      "id": "auth-provider",
      "description": "AUTH_PROVIDER",
      "password": true
    }
  ],
  "servers": {
    "mcp-pinot": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "${input:pinot-controller-url}",
        "PINOT_BROKER_URL": "${input:pinot-broker-url}",
        "PINOT_USERNAME": "${input:pinot-username}",
        "PINOT_PASSWORD": "${input:pinot-password}",
        "PINOT_TOKEN": "${input:pinot-token}",
        "PINOT_USE_MSQE": "${input:pinot-use-msqe}",
        "MCP_TRANSPORT": "${input:mcp-transport}",
        "AUTH_PROVIDER": "${input:auth-provider}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

Apache Pinot MCP Server in other clients