MCP.Market

Apache Pinot MCP Server

by startreedata·io.github.startreedata/mcp-pinot·v5.0.0·17 stars
No reviews yet

Query and manage Apache Pinot through MCP with typed tools and preview-first safety.

A85/100grade A
Write a reviewInstall
What users say
No reviews yet
Be the first
Safety scan
A85/100

full report

Adoption
Growing

17 stars85 downloads/wk

Reviews

Write one

Nobody has reviewed Apache Pinot MCP Server yet.

If you have run it, two minutes of your experience saves the next person an afternoon.

Apache Pinot MCP Server tools (18, 5 write)

write = sends, deletes, buys or posts

Read from the package source without running it. The installed server may list more.

  • begin_investigation

    Open an owner-bound, budgeted evidence run using a server-owned profile.

  • create_schemawrite action

    Preview or create a new Pinot schema without replacing an existing schema.

  • create_table_configwrite action

    Create a new Pinot table configuration.

  • finish_investigation

    Close a run once with authentic citations and an unverified outcome.

  • get_schema

    Get one Pinot schema, including dimensions, metrics, time, and primary keys.

  • get_segment_index_metadata

    Get per-column index metadata for ONE segment (which indexes each column has).

  • get_table_config

    Get one table's indexing, retention, tenant, and ingestion configuration.

  • get_table_size

    Get a table's storage footprint: reported vs. estimated size in bytes.

  • get_trace

    Retrieve scoped trace rows with actual span and parent-span identifiers.

  • list_segment_metadata

    Get a deterministic page of segment rows, sizes, and time boundaries.

  • list_segments

    List a table's segment names, grouped by table type (OFFLINE/REALTIME).

  • list_tables

    List Pinot tables visible to this server (subject to table filters).

  • query_incident

    Collect bounded evidence with fixed tenant/time predicates and citations.

  • read_querywrite action

    Run a read-only SQL query against Pinot and return a page of rows.

  • reload_table_filters

    Preview or apply the configured table-filter YAML without restarting.

  • test_connection

    Probe Pinot connectivity and return diagnostics.

  • update_schemawrite action

    Update an existing Pinot schema.

  • update_table_configwrite action

    Update an existing Pinot table configuration.

Public scan report

scanner v0.1.10 · 2026-10-30 · same rubric, same numbers if you re-run it

no findings
  • Code scan13 source files scanned25/25
  • –Live reliabilityno gateway calls yet and no remote to proben/a
  • –Tool poisoningtools not inspected (local package is not executed); not countedn/a
  • Auth qualitystatic API keys via environment variables6/15
  • Maintenancelast push 3 days ago15/15
  • Maintainer identityregistry namespace matches repository owner; GitHub account older than a year9/10
Overall 85/100. Components that don't apply are left out of the denominator. Any critical finding is an F.RubricAppeal a findingJSON

How Apache Pinot MCP Server compares

Against every graded MCP server, from our own scans and uptime checks. Updated after each scan run.

Safety score
85/100
higher than 70% of 48,255 servers
Tools
18
the typical server has 7
Tools that change things
28%
typical: 0%. Fewer write tools means less an agent can break
GitHub stars
17
more than 90% of 28,688 servers
Downloads a week
85
more than 59% of 12,191 servers with a package

What its tools let an agent do: 13 read · 2 create · 3 change

Release history: 2 versions in the registry since 2026-08-29, latest 2026-10-12, typically one every 43 days.

Install Apache Pinot MCP Server in Claude Code, Cursor or VS Code

claude mcp add mcp-pinot -- uvx mcp-pinot-server
Add to Cursor

What the publisher says

From the Apache Pinot MCP Server repository's README, as published. We do not edit it. Read it on GitHub

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.

Features

and failure-recovery guidance for agent planning.

  • Every tool advertises typed input and output JSON Schemas, MCP risk annotations,

pages with continuation metadata instead of returning unbounded agent context.

  • Large query, table, segment-name, and segment-metadata responses use bounded

and transient connectivity errors are surfaced as actionable MCP errors.

  • Read-only SQL is parsed and enforced before execution; validation, permission,

payload before applying. Applying requires the preview's short-lived, one-time confirmation_token, including for table-filter reloads. A preview is not a guarantee that Pinot will accept the later write.

  • Every mutating tool supports dry_run; always preview the exact target and

operations: use getschema and gettable_config independently.

  • Single-purpose schema and table-config inspection tools avoid ambiguous combined

MCP Tool Contract

Tool names are case-sensitive and use underscores. Version 4 renamed four tools to make every operation verb-first; clients using the former noun-first names must update their calls.

For every schema, table-config, or table-filter change, first call the same tool with dryrun=true, present the preview to the user, and call it with dryrun=false and the preview's one-time confirmation_token only after confirmation. Editing a table-filter file after preview invalidates its token. Pinot performs authoritative validation during table/schema apply calls, so a write can still fail after a successful preview.

Shortened. The full README is on GitHub.

Nothing above is checked by us. What we check is on the safety report.

Apache Pinot MCP Server: common questions

Is Apache Pinot MCP Server safe?
Yes, by our scan: it is graded A (85/100). Read the Apache Pinot MCP Server safety report
How do I install Apache Pinot MCP Server?
It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
Does Apache Pinot MCP Server need an API key?
Yes. The registry entry asks for PINOT_PASSWORD, PINOT_TOKEN.
Is Apache Pinot MCP Server maintained?
The last commit was 8 days ago (2026-10-27). The latest release is v5.0.0.
How does Apache Pinot MCP Server compare with other MCP servers?
safety score 85/100 (higher than 70% of 48,255 servers); tools 18 (the typical server has 7); tools that change things 28% (typical: 0%. Fewer write tools means less an agent can break). Full comparison.