drill-mcp
OfficialServer Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DRILL_URL | No | The URL of the Drillbit REST API (e.g., http://localhost:8047). Corresponds to the --url CLI flag. | |
| DRILL_USER | No | The username for Drill authentication. Can only be set via this environment variable or a config file; there is no --user CLI flag. | |
| DRILL_PASSWORD | No | The password for Drill authentication. Can only be set via this environment variable or a config file; there is no --password CLI flag. |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| run_queryC | Run a single SQL statement against Drill and return its rows. |
| list_schemasA | List every schema visible on the cluster. |
| list_tablesB | List the tables in one schema. |
| describe_tableA | List a table's columns with their types and nullability. |
| list_storage_pluginsA | List storage plugin configurations, with all secrets redacted. |
| cluster_statusA | Report Drillbit membership and overall cluster status. |
| list_profilesA | List recent and running query profiles, newest first. |
| get_profileA | Fetch the full profile for one query id. |
| cancel_queryB | Cancel a running query by its query id. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 9 tools
Each tool targets a distinct resource and action: query execution, schema/table listing, table description, storage plugin configs, cluster status, and query profile management. There is no overlap in purpose, so an agent can reliably select the correct tool.
Most tools follow a consistent verb_noun pattern using snake_case (run_query, list_schemas, list_tables, describe_table, list_storage_plugins, list_profiles, get_profile, cancel_query). The only deviation is 'cluster_status', which lacks an explicit verb but remains clear and readable.
With 9 tools, the set is well-scoped for a Drill MCP server. It covers metadata exploration, query execution, cluster health, and query management without unnecessary bloat, fitting comfortably within the ideal 3-15 range.
The server covers the core lifecycle of query interaction: running a query, inspecting profiles, and canceling. It also provides comprehensive metadata browsing via schemas, tables, and columns. Minor gaps exist such as lack of write operations or cross-schema table listing, but these are not critical for typical read-oriented Drill usage.