startreedata/mcp-pinot

The Pinot MCP Server is a specialized server that facilitates seamless interaction with Apache Pinot, a real-time distributed OLAP datastore. This server is built using the Model Context Protocol (MCP), which allows for efficient communication and data exchange between different systems. The primary goal of the Pinot MCP Server is to integrate with Claude Desktop, providing business users with the ability to perform real-time analytics and metadata queries on a Pinot cluster. By leveraging this server, users can list tables, segments, and schema information, execute read-only SQL queries, and view index or column-level metadata. This integration is particularly beneficial for business users who require quick and easy access to data insights without needing deep technical expertise. The server is designed to be user-friendly and efficient, making it an ideal tool for organizations looking to enhance their data analytics capabilities.

{
  "mcpServers": {
      "pinot_mcp_claude": {
          "command": "/path/to/uv",
          "args": [
              "--directory",
              "/path/to/mcp-pinot-repo",
              "run",
              "mcp_pinot/server.py"
          ],
          "env": {
            // You can also include your .env config here
          }
      }
  }
}