# Apache Pinot MCP Server

> Apache Pinot MCP Server is an open-source MCP server for databases. Query and manage Apache Pinot clusters with typed tools and preview-first changes. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** CLI, self-hosted, Linux, macOS
- **Website:** https://startreedata.github.io/mcp-pinot/
- **Repository:** https://github.com/startreedata/mcp-pinot
- **MCP Registry name:** io.github.startreedata/mcp-pinot
- **Categories:** databases, analytics and data
- **Listing updated:** 2026-11-15

## About

Built on FastMCP, this server connects an assistant to a Pinot cluster's controller and broker. Queries are read-only: SQL is parsed and enforced before execution, and large results come back in bounded pages with continuation metadata rather than flooding the model's context. Table-level filtering with glob patterns limits which tables the server shows.

Every mutating tool, covering schema, table-config and table-filter changes, supports dry_run. The agent previews the exact payload, then applies it with the preview's short-lived, one-time confirmation token, and editing a filter file after preview invalidates the token. Pinot still validates on apply, so a write can fail after a good preview. The README also lists opt-in investigation tools that open a scoped evidence run and cite recorded traces.

It runs over stdio for desktop clients or streamable HTTP with OAuth, and ships as a PyPI package, a container image and a Helm chart. Pinot credentials are optional basic auth or a bearer token.

## Features

- **Read-only SQL:** Queries are parsed and enforced as SELECT-only.
- **Preview-first writes:** dry_run plus a one-time confirmation token before any change.
- **Bounded pages:** Large results page with continuation metadata.
- **Table filtering:** Glob patterns restrict visible tables.
- **Cluster diagnostics:** test_connection checks controller, broker and query connectivity.
- **Kubernetes deployment:** Helm chart with health checks and optional network policy.

## Good for

- Ask an assistant to explore a Pinot table's schema and segments
- Run an ad-hoc read-only query on real-time data
- Preview a table-config change before applying it
- Inspect index metadata of one segment
- Diagnose connectivity to a Pinot cluster

## Install

### Claude Code (Terminal)

```sh
claude mcp add mcp-pinot --env PINOT_PASSWORD='<PINOT_PASSWORD>' --env PINOT_TOKEN='<PINOT_TOKEN>' -- uvx mcp-pinot-server
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_PASSWORD": "<PINOT_PASSWORD>",
        "PINOT_TOKEN": "<PINOT_TOKEN>"
      }
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_PASSWORD": "<PINOT_PASSWORD>",
        "PINOT_TOKEN": "<PINOT_TOKEN>"
      }
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mcp-pinot": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_PASSWORD": "<PINOT_PASSWORD>",
        "PINOT_TOKEN": "<PINOT_TOKEN>"
      }
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_PASSWORD": "<PINOT_PASSWORD>",
        "PINOT_TOKEN": "<PINOT_TOKEN>"
      }
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server"
      ],
      "env": {
        "PINOT_PASSWORD": "<PINOT_PASSWORD>",
        "PINOT_TOKEN": "<PINOT_TOKEN>"
      }
    }
  }
}
```

## Tools

- `test_connection`: Diagnose Pinot cluster connectivity
- `read_query`: Execute read-only SELECT queries
- `list_tables`: Page through visible table names
- `get_table_size`: Get table size and storage information
- `list_segments`: Page through segment names for a table
- `list_segment_metadata`: Page through detailed segment metadata
- `get_segment_index_metadata`: Inspect index and column-level information
- `get_schema`: Fetch a schema by name
- `create_schema`: Preview or create a schema
- `update_schema`: Preview or update a schema
- `get_table_config`: Retrieve table configuration
- `create_table_config`: Preview or create a table configuration
- `update_table_config`: Preview or update a table configuration
- `reload_table_filters`: Preview, then apply the table filter configuration

## FAQ

### Can it modify my cluster?

Only through schema and table-config tools, which preview first and need a one-time confirmation token to apply.

### Which transports does it support?

stdio by default and streamable HTTP, with OAuth for non-loopback hosts.

### How many tools are there?

The site lists 14, with extra opt-in investigation tools in the README.

### How is it installed?

From PyPI as mcp-pinot-server, as a container image, or from source with uv.

### Is Apache Pinot MCP Server free?

Yes. Apache Pinot MCP Server is open source, so you can use and self-host it for free.

### How do I add Apache Pinot MCP Server to Claude Code?

Run this command in your terminal: claude mcp add mcp-pinot --env PINOT_PASSWORD='<PINOT_PASSWORD>' --env PINOT_TOKEN='<PINOT_TOKEN>' -- uvx mcp-pinot-server

### What are the best alternatives to Apache Pinot MCP Server?

The closest alternatives to Apache Pinot MCP Server are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.

## Alternatives

- [Agent-Native Analytics](https://ai-powered.com/mcp/agent-native-analytics): Agent-Native Analytics is an open-source MCP server for analytics and data.
- [Google Ads + Meta Ads + SEO/GEO MCP](https://ai-powered.com/mcp/google-ads-meta-ads-seo-geo-mcp): Google Ads + Meta Ads + SEO/GEO MCP is a freemium MCP server for marketing and seo.
- [Tapetide - Indian Stock Market MCP](https://ai-powered.com/mcp/tapetide-indian-stock-market-mcp): Tapetide - Indian Stock Market MCP is a freemium MCP server for finance and payments.
- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [World Monitor](https://ai-powered.com/mcp/world-monitor): World Monitor is a freemium MCP server for analytics and data.
- [CompanyData](https://ai-powered.com/mcp/companydata): CompanyData is a paid MCP server for analytics and data.
- [ChartAnt](https://ai-powered.com/mcp/chartant): ChartAnt is a freemium MCP server for design and media.
- [Quantivex Research](https://ai-powered.com/mcp/quantivex-research): Quantivex Research is a free MCP server for finance and payments.

---
Source: https://ai-powered.com/mcp/apache-pinot-mcp-server
