Apache Pinot MCP Server
Query and manage Apache Pinot clusters with typed tools and preview-first changes
- 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-serverAdd 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

Agent-Native Analytics
MCP serverOpen-source analytics app where an AI agent builds charts and dashboards from your data
- Remote
- Open source
- 7.7K GitHub stars
- Analytics and data

Google Ads + Meta Ads + SEO/GEO MCP
MCP serverHosted 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

Tapetide - Indian Stock Market MCP
MCP serverIndian NSE and BSE stock market data for AI assistants through 48 MCP tools
- 17 tools
- Remote
- Freemium
- 150 GitHub stars
- Finance and payments

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

World Monitor
MCP serverLive geopolitical intelligence dashboard with an API and MCP server for agents
- Remote
- Freemium
- Analytics and data

CompanyData
MCP serverSearch and enrich company records from official registers via the CompanyData API
- 3 tools
- Remote
- Paid
- 3 GitHub stars
- Analytics and data