How do I install the mcp pinot mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `PINOT_CONTROLLER_URL`, `PINOT_BROKER_URL`, `PINOT_BROKER_HOST`, `PINOT_TOKEN`, `MCP_STATIC_TOKEN`, `OAUTH_CLIENT_ID`, `OAUTH_CLIENT_SECRET`, `OAUTH_BASE_URL` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

MCP Pinot MCP Server

It allows you to - List tables, segments, and schema info from Pinot - Execute read-only SQL queries - View index/column-level metadata - Designed to

Remote serverstreamable-httpPython

What is the MCP Pinot MCP Server?

It allows you to - List tables, segments, and schema info from Pinot - Execute read-only SQL queries - View index/column-level metadata - Designed to assist

What the server does

Every tool advertises typed input and output JSON Schemas, MCP risk annotations,
Large query, table, segment-name, and segment-metadata responses use bounded
Read-only SQL is parsed and enforced before execution; validation, permission,
Every mutating tool supports dry_run; always preview the exact target and
Single-purpose schema and table-config inspection tools avoid ambiguous combined

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

How to install the MCP Pinot MCP Server

claude mcp add pinot --env PINOT_CONTROLLER_URL=your-value --env PINOT_BROKER_URL=your-value --env PINOT_BROKER_HOST=your-value --env PINOT_TOKEN=your-value --env MCP_STATIC_TOKEN=your-value --env OAUTH_CLIENT_ID=your-value --env OAUTH_CLIENT_SECRET=your-value --env OAUTH_BASE_URL=your-value -- npx -y @anthropic-ai/mcpb

Configuration

Variable	Description	Required
PINOT_CONTROLLER_URL	Endpoint or connection string the server talks to.	Yes
PINOT_BROKER_URL	Endpoint or connection string the server talks to.	Yes
PINOT_BROKER_HOST	Endpoint or connection string the server talks to.	Optional
PINOT_TOKEN	Credential the server authenticates with.	Yes
MCP_STATIC_TOKEN	Credential the server authenticates with.	Yes
OAUTH_CLIENT_ID	Configuration value read at startup.	Optional
OAUTH_CLIENT_SECRET	Credential the server authenticates with.	Yes
OAUTH_BASE_URL	Endpoint or connection string the server talks to.	Yes

Example prompts to try

“Use MCP Pinot to Prerequisites.”
“Use MCP Pinot to Installation.”
“Use MCP Pinot to Authentication.”

Frequently asked questions

It allows you to - List tables, segments, and schema info from Pinot - Execute read-only SQL queries - View index/column-level metadata - Designed to assist Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.