imply-druid-mcp
Provides read-only access to Apache Druid databases, enabling SQL query execution, table exploration, dashboard and data cube operations through the Imly Cloud API.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@imply-druid-mcp list all tables in my Druid project"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
imply-druid-mcp
A read-only MCP (Model Context Protocol) server for Imply Cloud/Druid databases. Query and explore your Druid data through Claude and other AI assistants.
Features
Supported ✅
SQL Query Execution
Synchronous query execution
Asynchronous query execution (for large datasets)
Query Management
Check query status
Retrieve query results
Cancel running queries
Table Operations
List all tables in project
Get table schema details
Dashboard Operations
List all dashboards
Get dashboard details
Data Cube Operations
List all data cubes
Get data cube details
Execute Pivot SQL queries
Not Supported ❌
Data Ingestion
Table/Schema Creation or Modification
User/Permission Management
Supervisor Management
Related MCP server: starrocks-mcp
Tools
Query Tools
Tool | Description |
| Execute a SQL query synchronously and return results immediately |
| Execute a SQL query asynchronously for large datasets. Returns a query ID |
| Retrieve results from an async query using query ID |
| Check the execution status of an async query |
| Cancel a running async query |
Table Tools
Tool | Description |
| List all tables (datasources) in the Druid project |
| Get detailed schema information for a specific table |
Dashboard Tools
Tool | Description |
| List all dashboards in the Imply project |
| Get detailed information about a specific dashboard |
Data Cube Tools
Tool | Description |
| List all data cubes in the Imply project |
| Get detailed data cube information including dimensions and measures |
| Execute Pivot SQL query against a data cube |
API Mapping
This MCP server maps to the Imply Polaris API:
MCP Tool | Imply API Endpoint |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Installation
Using uvx (Recommended)
uvx imply-druid-mcpUsing pip
pip install imply-druid-mcp
imply-druid-mcpUsing pipx
pipx install imply-druid-mcp
imply-druid-mcpConfiguration
Environment Variable | Required | Default | Description |
| Yes | - | Imply Cloud organization name |
| Yes | - | Region (e.g., |
| Yes | - | Cloud provider: |
| Yes | - | Imply project ID |
| Yes* | - | Imply API key |
| Yes* | - | OAuth access token (alternative) |
| No |
| Logging level |
| No |
| Default query timeout (ms) |
| No |
| Maximum SQL query length |
*Either IMPLY_API_KEY or IMPLY_ACCESS_TOKEN is required.
Claude Desktop Setup
Add to your Claude Desktop config file:
macOS:
~/Library/Application Support/Claude/claude_desktop_config.jsonWindows:
%APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"imply-druid": {
"command": "uvx",
"args": ["imply-druid-mcp"],
"env": {
"IMPLY_ORGANIZATION": "your-org",
"IMPLY_REGION": "us-east-1",
"IMPLY_CLOUD_PROVIDER": "aws",
"IMPLY_PROJECT_ID": "your-project-id",
"IMPLY_API_KEY": "your-api-key"
}
}
}
}Usage Examples
User: Show me all tables in my Druid project
Claude: [Uses list_tables]
- wikipedia (datasource)
- events (datasource)
- metrics (datasource)User: Query the top 10 records from wikipedia table
Claude: [Uses execute_sql_query with "SELECT * FROM wikipedia LIMIT 10"]
[Results displayed]User: Show me all data cubes
Claude: [Uses list_data_cubes]
- sales_cube: Sales Analytics (source: sales_table)
- events_cube: Events Tracking (source: events)User: Query the sales data cube for top cities
Claude: [Uses query_data_cube with Pivot SQL syntax]
SELECT "DIM:city" AS "City", MEASURE_BY_ID('total_sales') AS "Sales"
FROM "datacube"."sales_cube"
ORDER BY 2 DESC
LIMIT 10Development
git clone https://github.com/yeongbin-hwang/imply-druid-mcp.git
cd imply-druid-mcp
pip install -e ".[dev]"License
MIT License - see LICENSE for details.
Resources
Available Tools
12 toolscancel_queryB
Cancel a running query.
Inputs: query_id (required).
execute_async_queryA
Execute an asynchronous SQL query for large datasets or long-running queries. Returns a query ID.
Inputs: sql (required), timeout_ms.
execute_sql_queryA
Execute a SQL query against Druid and return results. Use this for synchronous queries on small datasets.
Inputs: sql (required), timeout_ms.
get_dashboardB
Get detailed information about a specific dashboard including its configuration.
Inputs: dashboard_id (required).
get_data_cubeA
Get detailed information about a specific data cube including dimensions and measures.
Inputs: cube_id (required).
get_query_resultsB
Get results from an asynchronous query using its query ID.
Inputs: query_id (required).
get_query_statusC
Check the status of an asynchronous query.
Inputs: query_id (required).
get_table_schemaC
Get detailed schema information for a specific table.
Inputs: table_name (required).
list_dashboardsA
List all dashboards in the Imply project with their metadata.
Inputs: no named parameters.
list_data_cubesA
List all data cubes in the Imply project with their metadata.
Inputs: no named parameters.
list_tablesA
List all tables in the Druid project with their metadata.
Inputs: no named parameters.
query_data_cubeA
Execute SQL query against a data cube (Pivot). Use 'source' from list_data_cubes. Syntax: FROM "datacube"."SOURCE", "DIM:dimension_name", MEASURE_BY_ID('measure_id')
Inputs: query_string (required), exact_results_only.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 12 tools
Each tool has a clear, distinct purpose. Sync and async queries are separated, and the data cube query uses a different syntax. No two tools appear to do the same thing.
All tool names follow a consistent verb_noun pattern (e.g., list_*, get_*, execute_*, cancel_*, query_*). No mixing of conventions or vague verbs.
12 tools appropriately cover the core functionalities of querying Druid, managing dashboards, data cubes, and tables. Not too few nor too many.
The tool set provides full lifecycle coverage for querying (sync, async, cancellation, status, results) and browsing resources (list, get details, schema). No obvious gaps for a query-oriented server.
Maintenance
Related MCP Connectors
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Read-only Google Analytics 4 MCP server for AI assistants.
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Related MCP Servers
- AlicenseBqualityCmaintenanceA Model Context Protocol (MCP) server that provides read-only TDengine database queries for AI assistants, allowing users to execute queries, explore database structures, and investigate data directly from AI-powered tools.611MIT
- AlicenseAqualityDmaintenanceA read-only MCP server that enables users to query and explore StarRocks databases through AI assistants like Claude. It supports SQL execution, schema discovery, and secure LDAP authentication for data analysis and metadata exploration.41MIT
- AlicenseAqualityBmaintenanceA read-only MCP server that exposes SQL database access to LLMs, supporting multiple database types, compact columnar results, pagination, and file export.720 npmMIT
- FlicenseNot gradedqualityDmaintenanceA read-only MCP server that enables AI agents to explore database schemas and execute safe queries on PostgreSQL and MySQL.-