Apache Pinot + MindPal: Complete MCP Integration

Apache Pinot is a MCP server that MCP server for Apache Pinot real-time analytics database with SQL query capabilities and metadata access.

When integrated with MindPal, you can:

• List and inspect Apache Pinot tables
• View and analyze table segments
• Retrieve and analyze table schemas

This guide provides step-by-step instructions to set up Apache Pinot in MindPal, including configuration, examples, and troubleshooting.

What You'll Achieve

After completing this setup:

• Apache Pinot will be fully integrated and operational
• You can use Apache Pinot tools directly in MindPal
• All Apache Pinot capabilities will be available for your workflows
• Access to 5 different tools

Prerequisites

Before starting, ensure you have:

• Apache Pinot broker hostname
• Apache Pinot broker port
• MindPal installed and configured
• Compatible operating system (Web Platform, Mobile Web)

Installation

Step 1: Install Apache Pinot

Configuration

Step 2: Configure MindPal

1. Open MindPal settings
2. Navigate to MCP server configuration
3. Add Apache Pinot server with appropriate settings
4. Save and restart if needed

Examples

Once configured, you can use Apache Pinot in MindPal:

List All Tables

Get overview of available Pinot tables

Ask MindPal: "Show me all the tables available in the Pinot cluster"

Expected Result: List of table names with basic metadata and schema information

Execute Analytics Query

Run SQL query for real-time analytics

Ask MindPal: "SELECT COUNT(*) FROM events WHERE timestamp > now() - 3600000"

Expected Result: Query results showing event count for last hour

Analyze Table Structure

Get detailed schema information for a table

Ask MindPal: "Show me the schema and structure of the user_events table"

Expected Result: Table schema with column names, types, and index information

Generate Data Visualization

Create histogram plots from query results

Ask MindPal: "Create a histogram showing user activity distribution by hour"

Expected Result: Histogram visualization with data aggregated by time buckets

Testing Your Setup

1. Start a new conversation in MindPal
2. Ask MindPal to list available tools
3. Try using Apache Pinot functionality

Troubleshooting

Common Issues

uv Command Not Found

Symptoms: Command not found error, uv: command not found

Cause: uv package manager not installed

Solution:

• Install uv using: curl -LsSf https://astral.sh/uv/install.sh | sh
• Restart terminal or source shell configuration
• Verify installation with: uv --version

Pinot Connection Failed

Symptoms: Connection refused, Broker unreachable, Network timeout

Cause: Invalid Pinot broker configuration or cluster not running

Solution:

• Verify PINOT_BROKER_HOST and PINOT_BROKER_PORT in .env file
• Check Pinot cluster is running and accessible
• Test connection: telnet <broker_host> <broker_port>
• Ensure firewall allows connections to Pinot broker

Environment Variables Not Loaded

Symptoms: Config missing errors, Default values being used

Cause: .env file not found or incorrectly formatted

Solution:

• Create .env file in repository root directory
• Copy from .env.example and modify values
• Ensure no spaces around = in variable assignments
• Restart MCP server after configuration changes

Claude Desktop Not Recognizing Server

Symptoms: Server not appearing, Connection errors in Claude

Cause: Incorrect claude_desktop_config.json configuration

Solution:

• Verify path to uv binary in command field
• Ensure correct path to mcp-pinot repository
• Restart Claude Desktop after configuration changes
• Check Claude Desktop logs for error messages

MCP Server Connection Failed

Symptoms: Connection test fails, Server unreachable error, Timeout during setup

Cause: Invalid server URL or server not accessible from cloud

Solution:

• Verify MCP server URL is correct and publicly accessible
• Check server is running and responding to requests
• Ensure server supports Streamable HTTP or SSE transport (STDIO not supported)
• Test server URL in browser or with curl to confirm accessibility
• Review server logs for connection errors

MCP Tools Not Available to Agent

Symptoms: Agent cannot access MCP tools, Tool calls fail, Tools not appearing in capabilities

Cause: MCP server not properly configured or tools not discovered

Solution:

• Verify MCP server connection shows "Connected" status
• Check that MCP server provides Tools (not just Resources or Prompts)
• Refresh agent settings to rediscover tools
• Test MCP server independently to ensure it is functioning
• Review MCP server documentation for proper tool implementation

Agent Not Understanding MCP Tool Usage

Symptoms: Agent does not use MCP tools when appropriate, Tool selection errors, Incorrect tool parameters

Cause: Ambiguous instructions or insufficient agent training

Solution:

• Provide more explicit instructions about when to use MCP tools
• Train agent with examples of correct MCP tool usage
• Add context about available MCP capabilities to agent knowledge
• Use specific tool names in prompts if agent is not selecting correctly

Workflow Automation Not Triggering

Symptoms: Multi-agent workflows not executing, Checkpoints not firing, Agent handoffs failing

Cause: Workflow configuration errors or trigger conditions not met

Solution:

• Verify workflow trigger conditions are properly set
• Check that all agents in workflow are active and configured
• Review workflow logs for execution errors
• Test each workflow step individually before combining
• Ensure MCP tools are accessible to all agents in workflow

High Usage or Rate Limiting

Symptoms: Plan limits exceeded warning, MCP calls being throttled, Tasks failing due to quota

Cause: Excessive automation or inefficient workflows

Solution:

• Review plan limits and current usage in account dashboard
• Optimize workflows to reduce unnecessary MCP calls
• Implement caching for frequently accessed data
• Add delays between automated tasks if hitting rate limits
• Upgrade plan if automation needs exceed current tier

Apache Pinot not appearing in MindPal

Symptoms: Server not listed, Tools not available

Cause: Configuration or installation issue

Solution:

• Verify configuration syntax
• Check Apache Pinot installation
• Restart MindPal
• Check logs for error messages

Next Steps

Now that Apache Pinot is integrated with MindPal:

• Explore all Apache Pinot capabilities through MindPal
• Check out other MCP servers that work with MindPal
• Join the MCP community for tips and support
• Consider contributing to Apache Pinot development

Need Help?

• Search for Apache Pinot documentation
• Check the MindPal MCP guide
• Join the MCP community discussions