Pinot MCP Server
About
An MCP server for interacting with Apache Pinot, a real-time distributed OLAP datastore.
Details
- Author
- startreedata
- GitHub stars
- 16
- Downloads
- 298
- Categories
- Database, Other, Search
Jump to
- List tables, segments, and schema info from Pinot
- Execute read-only SQL queries with automatic validation
- View index and column-level metadata
- Optional table filtering with glob patterns
- Multiple transport modes (stdio, HTTP, HTTPS with OAuth)
- Read-only query enforcement (SELECT/WITH only)
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Pinot MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Clone the repository, install dependencies with uv, configure a .env file for the Pinot cluster connection, then run the server. It supports stdio transport for Claude Desktop and HTTP transport for other clients with optional OAuth authentication.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"pinot mcp server": {
"mcp-pinot": {
"command": "uv",
"args": [
"pip",
"install",
"-e",
".",
"#",
"Install",
"dependencies"
]
}
}
}
}McpServers
{
"mcp-pinot": {
"command": "uv",
"args": [
"pip",
"install",
"-e",
".",
"#",
"Install",
"dependencies"
]
}
}Pinot MCP Server
<!-- mcp-name: io.github.startreedata/mcp-pinot -->
Table of Contents
- Overview
- Features
- Quick Start
- Configuration Reference
- Docker Build
- Claude Desktop Integration
- Try a Prompt
- Security and Vulnerability Reporting
- Developer Notes
Overview
This project is a Python-based Model Context Protocol (MCP) server for interacting with Apache Pinot. It is built using the FastMCP framework. It is designed to integrate with Claude Desktop to enable real-time analytics and metadata queries on a Pinot cluster.
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 business users via Claude integration
- and much more.
<a href="https://glama.ai/mcp/servers/@startreedata/mcp-pinot">
</a>
Pinot MCP in Action
See Pinot MCP in action below:
Fetching Metadata
Fetching Data, followed by analysis
Prompt:
Can you do a histogram plot on the GitHub events against time
Sample Prompts
Once Claude is running, click the hammer 🛠️ icon and try these prompts:- Can you help me analyse my data in Pinot? Use the Pinot tool and look at the list of tables to begin with.
- Can you do a histogram plot on the GitHub events against time
Quick Start
Prerequisites
Install uv (if not already installed)
uv is a fast Python package installer and resolver, written in Rust. It's designed to be a drop-in replacement for pip with significantly better performance.```bash
curl -LsSf https://astral.sh/uv/install.sh | sh
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
