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 "Install 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-mcplist 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: databricks-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
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
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.Last updated610MIT
- AlicenseCqualityDmaintenanceA read-only MCP server that enables users to query Databricks SQL, browse metadata, and monitor Delta Lake tables. It also supports tracking Databricks Jobs, DLT Pipelines, and cluster metrics through natural language interfaces.Last updated254MIT
- 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.Last updated41MIT
- Alicense-qualityBmaintenanceMCP server providing read-only access to SQL Server databases for AI assistants, enabling schema exploration, query execution, and foreign key inference with token-efficient TOON responses.Last updated1MIT
Related MCP Connectors
Driflyte MCP server which lets AI assistants query topic-specific knowledge from web and GitHub.
Official Microsoft MCP Server to query Microsoft Entra data using natural language
Read-only MCP server for wafergraph.com's semiconductor & AI supply-chain data: 30 tools, no auth.
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/yeongbin-hwang/imply-druid-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server