# Apache Pinot

> Use this tool when you need to query real-time analytics data through SQL and access cluster metadata for business intelligence, operational monitoring, or time-series analysis. It provides a production-grade interface for AI assistants to interact with Apache Pinot, supporting inputs like SQL queries and outputs like table configurations, segment details, and index information. Ideal for scenarios requiring high-performance OLAP data stores, it enables efficient data exploration and guided prompts for Pinot query assistance.

Canonical page: https://skillsregistry.net/skills/startreedata-pinot  
JSON: https://api.skillsregistry.net/v1/skills/startreedata-pinot

## Description

This MCP server provides production-grade integration with Apache Pinot, enabling AI assistants to query real-time analytics data through SQL and access cluster metadata including table configurations, segment details, and index information. Built by the StarTree team using Python with the MCP SDK, pinotdb driver, and REST API integration, it supports both quickstart and enterprise Pinot deployments with configurable authentication, database selection, and multi-stage query engine options. The implementation offers seven specialized tools for data exploration (SQL queries, table listing, schema inspection, segment analysis) along with guided prompts for Pinot query assistance, making it valuable for real-time analytics workflows, operational monitoring dashboards, and business intelligence scenarios where AI assistants need to interact with high-performance OLAP data stores for time-series analysis and aggregation queries.

## Trust

- **Trust score (0–1):** 0.50
- **Verification tier:** unverified

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-04-25

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/startreedata-pinot)
- **Repository:** <https://github.com/startreedata/mcp-pinot>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "startreedata-pinot"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/startreedata-pinot` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/startreedata-pinot/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt