Druid MCP Server

by christian-schlichtherle

303 downloads
Not rated
GitHub

About

An MCP server for comprehensive read-only access to one or more Apache Druid clusters for ad-hoc data analysis, monitoring, troubleshooting, and comparison.

Details

Author
christian-schlichtherle
Downloads
303
Categories
Other

- Multi-cluster support: connect to and query multiple clusters simultaneously
- Query execution: SQL and native JSON queries
- Datasource management: list, explore, and inspect schemas
- Ingestion monitoring: supervisor and task status tracking
- Cluster operations: service health monitoring and segment analysis
- Lookup management: query and inspect lookup tables
- Smart analysis prompts: pre-built prompts for common analysis tasks
- Schema caching: 5-minute TTL for resource endpoints

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name Druid MCP Server
    Command (node, npx, python, etc.)

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

Install dependencies with uv install or pip install -e ., then configure clusters via the DRUID_CLUSTERS environment variable (whitespace-separated key=value pairs). Run the server in development with mcp dev main.py or production with mcp run main.py. Integrate with Claude Desktop using mcp install main.py. All tools (except cluster management) require an explicit cluster parameter as the first argument.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "druid mcp server": {
            "druid": {
                "command": "uv",
                "args": [
                    "--directory",
                    "/ABSOLUTE/PATH/TO/druid-mcp",
                    "run",
                    "main.py"
                ],
                "env": {
                    "DRUID_CLUSTERS": "dev=http://localhost:8088 stage=http://localhost:8089 prod=http://localhost:8090"
                }
            }
        }
    }
}

McpServers

{
    "druid": {
        "command": "uv",
        "args": [
            "--directory",
            "/ABSOLUTE/PATH/TO/druid-mcp",
            "run",
            "main.py"
        ],
        "env": {
            "DRUID_CLUSTERS": "dev=http://localhost:8088 stage=http://localhost:8089 prod=http://localhost:8090"
        }
    }
}

Druid MCP

This repository provides an MCP server for read-only access to one or more Apache Druid clusters.
This is particularly useful for ad-hoc data analysis and comparison across Druid clusters.
For example, if you have multiple environments, each with their own Druid cluster, but ingesting data from the same
origin, then you could use a simple prompt like this to run a complex cross-cluster comparison:

> Check and compare the datasource for SumUp across all Druid clusters.

The AI agent should then list the Druid clusters, list their datasources, explore their schemas, segments, tasks, and
their data distribution all by itself, and ultimately present you a nice summary.

Overview

The Druid MCP server enables AI applications to interact with Apache Druid through the Model Context Protocol (MCP). It provides a standardized interface for querying and exploring Druid datasources, making it easy to integrate Druid data into AI workflows.

Features

- Multi-Cluster Support: Connect to and query multiple Druid clusters simultaneously
- Query Execution: SQL and native JSON queries
- Datasource Management: List, explore, and inspect datasource schemas
- Ingestion Monitoring: Supervisor and task status tracking
- Cluster Operations: Service health monitoring and segment analysis
- Lookup Management: Query and inspect lookup tables
- Smart Analysis Prompts: Pre-built prompts for common data analysis tasks
- Schema Caching: Efficient caching with 5-minute TTL for better performance in resources only

Prerequisites

- Python 3.11+
- Access to an Apache Druid cluster
- MCP-compatible client (e.g., Claude Desktop)

Installation

Install dependencies using uv:

uv install

Or with pip:

pip install -e .

Configuration

Multi-Cluster Support

Configure multiple Druid clusters with whitespace-separated key=value pairs:

```bash

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.