LogoSTMCP
Download
mcp-pinot

Pinot MCP Server

A Python-based Model Context Protocol (MCP) server for Apache Pinot that enables real-time analytics, metadata queries, and SQL execution through Claude Desktop integration for business intelligence.

Tools

1. list_tables

List all tables in the Pinot cluster.

2. list_segments

List all segments for a given table.

3. get_schema_info

Retrieve schema information for a given table.

4. execute_sql_query

Execute a read-only SQL query on the Pinot cluster.

5. view_index_metadata

View index-level metadata for a given table.

6. view_column_metadata

View column-level metadata for a given table.

Open Graph image for Pinot MCP Server

JSON Config

{
  "mcpServers": {
    "pinot_mcp_claude": {
      "command": "/path/to/uv",
      "args": [
        "--directory",
        "/path/to/mcp-pinot-repo",
        "run",
        "mcp_pinot/server.py"
      ],
      "env": {
        // Pinot cluster connection environment variables
      }
    }
  }
}

Useful Links

GitHubDeepWiki

Information

Categories

Tags

Back

More MCP Server