AI Atlas

Database · Developer Tools

MCP Pinot

startreedata/mcp-pinot

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.

View on GitHub

Install

docker run --name pinot-quickstart -p 2123:2123 -p 9000:9000 -p 8000:8000 -d apachepinot/pinot:1.5.1 QuickStart -type batch

Client configuration

{
  "mcpServers": {
    "pinot_mcp": {
      "command": "/path/to/uv",
      "args": [
        "--directory",
        "/path/to/mcp-pinot-repo",
        "run",
        "mcp_pinot/server.py"
      ]
    }
  }
}

Environment variables

OAUTH_CLIENT_IDOAUTH_CLIENT_SECRETOAUTH_BASE_URLOAUTH_AUTHORIZATION_ENDPOINTOAUTH_TOKEN_ENDPOINT
Author
@startreedata
Category
Database, Developer Tools
License
Apache-2.0
Updated
Oct 6, 2026

Features

  • Every tool advertises typed input and output JSON Schemas, MCP risk annotations, and failure-recovery guidance for agent planning.

  • Large query, table, segment-name, and segment-metadata responses use bounded pages with continuation metadata instead of returning unbounded agent context.

  • Read-only SQL is parsed and enforced before execution; validation, permission, and transient connectivity errors are surfaced as actionable MCP errors.

  • Every mutating tool supports dry_run; always preview the exact target and payload before applying. Applying requires the preview's short-lived, one-time confirmation_token, including for table-filter…

  • Single-purpose schema and table-config inspection tools avoid ambiguous combined operations: use get_schema and get_table_config independently.

Tools (12)

  • test_connection

    Diagnose broker, controller, and query connectivity.

  • list_tables

    List visible Pinot table names.

  • get_schema

    Get one table's column schema.

  • get_table_config

    Get one table's indexing and ingestion configuration.

  • get_table_size

    Get reported and estimated storage size for one table.

  • list_segments

    List exact segment names for one table.

  • list_segment_metadata

    Page through metadata for a table's segments.

  • get_segment_index_metadata

    Inspect per-column indexes for one exact segment.

  • read_query

    Run one read-only Pinot SQL query.

  • create_schema

    Preview or apply schema changes.

  • create_table_config

    Preview or apply table-config changes.

  • reload_table_filters

    Preview or apply the configured table-filter YAML.

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Claude Desktop logo

Claude Desktop

Desktop · Freemium · Proprietary

Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.

WindowsMacOS

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

677

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database