Skip to content
MCP server

Apache Pinot MCP Server

Query and manage Apache Pinot clusters with typed tools and preview-first changes

Runs locallyStatus and history
Install
Pricing
Open source
Platforms
CLI, self-hosted, Linux
Runs
Locally
Version
5.0.0
Listing updated
2 days ago

About Apache Pinot MCP Server

Apache Pinot MCP Server is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

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.

Install

Run in a terminal

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

Add to claude_desktop_config.json

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

Add to ~/.cursor/mcp.json

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

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Configuration

  • PINOT_CONTROLLER_URLHTTP(S) endpoint of the Pinot Controller.
  • PINOT_BROKER_URLHTTP(S) endpoint of the Pinot Broker.
  • PINOT_USERNAMEOptional Pinot basic-auth username.
  • PINOT_PASSWORDOptional Pinot basic-auth password.
  • PINOT_TOKENOptional Pinot bearer token. Overrides username and password when set.
  • PINOT_USE_MSQEWhether to enable Pinot multi-stage query engine support.
  • MCP_TRANSPORTTransport mode: 'stdio' (default, for desktop clients) or 'http'.
  • AUTH_PROVIDERInbound auth provider for HTTP transport (e.g. 'oauth'); required to bind a non-loopback host.

Tools this server provides (14)

Taken from the project documentation; the running server may differ.

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

What it does

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

Pricing

Open source

Prices change. Check startreedata.github.io before you buy.

Apache Pinot MCP Server 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 to Apache Pinot MCP Server

  1. Open-source analytics app where an AI agent builds charts and dashboards from your data

    • Remote
    • Open source
    • 7.7K GitHub stars
    • Analytics and data
  2. Hosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat

    • 8 tools
    • Remote
    • Freemium
    • 8.1K GitHub stars
    • Marketing and SEO
  3. Indian NSE and BSE stock market data for AI assistants through 48 MCP tools

    • 17 tools
    • Remote
    • Freemium
    • 150 GitHub stars
    • Finance and payments
  4. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  5. World Monitor

    MCP server

    Live geopolitical intelligence dashboard with an API and MCP server for agents

    • Remote
    • Freemium
    • Analytics and data
  6. CompanyData

    MCP server

    Search and enrich company records from official registers via the CompanyData API

    • 3 tools
    • Remote
    • Paid
    • 3 GitHub stars
    • Analytics and data