An MCP server that provides tools to interact with Powerdrill datasets, enabling smart AI data analysis and insights.
If you want an AI assistant working directly with Powerdrill, the powerdrill mcp server is the bridge. An MCP server that provides tools to interact with Powerdrill datasets, enabling smart AI data analysis and insights.
A Model Context Protocol (MCP) server that provides tools to interact with Powerdrill datasets, authenticated with Powerdrill User ID and Project API Key.
Once connected, the assistant can call these 7 tools directly:
mcp_powerdrill_list_datasets — Parameters: - limit (optional): Maximum number of datasets to returnmcp_powerdrill_get_dataset_overview — Gets detailed overview information about a specific datasetmcp_powerdrill_create_job — Creates a job to analyze data with natural language questionsmcp_powerdrill_create_session — Parameters: - name (required): The session name, which can be up to 128 characters in length - output_language (optional, default: "AUTO"): The language inmcp_powerdrill_list_data_sources — Parameters: - datasetId (required): The ID of the dataset to list data sources from - pageNumber (optional, default: 1): The page number to start listing -mcp_powerdrill_list_sessions — Parameters: - pageNumber (optional): The page number to start listing (default: 1) - pageSize (optional): The number of items on a single page (default: 10) -mcp_powerdrill_create_dataset — Parameters: - name (required): The dataset name, which can be up to 128 characters in length - description (optional): The dataset description, which can be upThe server is distributed via npm as @smithery/cli, so most clients can run it without a manual build step. Add it to your MCP client's configuration and restart the client to pick it up — the copy-paste configs for Claude Desktop, Claude Code and Cursor are on this page.
Before the server will start you need to supply 2 environment variables: POWERDRILL_USER_ID, POWERDRILL_PROJECT_API_KEY. Keep credentials in your client's env block or a secrets manager rather than committing them.
To use this MCP server, you'll need a Powerdrill account with valid API credentials (User ID and API Key). Here's how to obtain them: 1. Sign up for a Powerdrill Team account if you haven't already 2. Navigate to your account settings 3. Look for the API section where you'll find your: - User ID: A unique identifier for your account - API Key: Your authentication token for API access
Developer-tool servers are usually the first ones people connect, because they turn "help me with this code" into an assistant that can actually read the repo and act on it. Powerdrill sits in that group, and the shape of its toolset — mcp_powerdrill_list_datasets, mcp_powerdrill_get_dataset_overview, mcp_powerdrill_create_job among others — tells you what it is really for. Worth comparing against the other developer tools servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.
| Tool | What it does |
|---|---|
| mcp_powerdrill_list_datasets | Parameters: - limit (optional): Maximum number of datasets to return |
| mcp_powerdrill_get_dataset_overview | Gets detailed overview information about a specific dataset. |
| mcp_powerdrill_create_job | Creates a job to analyze data with natural language questions. |
| mcp_powerdrill_create_session | Parameters: - name (required): The session name, which can be up to 128 characters in length - output_language (optional, default: "AUTO"): The language in which the output is generated. Options include: "AUTO", "EN", "E |
| mcp_powerdrill_list_data_sources | Parameters: - datasetId (required): The ID of the dataset to list data sources from - pageNumber (optional, default: 1): The page number to start listing - pageSize (optional, default: 10): The number of items on a singl |
| mcp_powerdrill_list_sessions | Parameters: - pageNumber (optional): The page number to start listing (default: 1) - pageSize (optional): The number of items on a single page (default: 10) - search (optional): Search for sessions by name |
| mcp_powerdrill_create_dataset | Parameters: - name (required): The dataset name, which can be up to 128 characters in length - description (optional): The dataset description, which can be up to 128 characters in length |
{
"mcpServers": {
"powerdrill": {
"command": "npx",
"args": ["-y", "@smithery/cli"],
"env": {
"POWERDRILL_USER_ID": "your-value",
"POWERDRILL_PROJECT_API_KEY": "your-value"
}
}
}
}Add to claude_desktop_config.json, then restart Claude Desktop.
To use this MCP server, you'll need a Powerdrill account with valid API credentials (User ID and API Key). Here's how to obtain them: 1. Sign up for a Powerdrill Team account if you haven't already 2. Navigate to your account settings 3. Look for the API section where you'll find your: - User ID: A unique identifier for your account - API Key: Your authentication token for API access
| Variable | Description | Required |
|---|---|---|
| POWERDRILL_USER_ID | Configuration value read at startup. | Optional |
| POWERDRILL_PROJECT_API_KEY | Credential the server authenticates with. | Yes |
Kill hallucinated APIs — version-accurate, up-to-date library documentation injected straight into context.
Microsoft's official browser automation server — drive a real browser through the accessibility tree, no screenshots needed.
GitHub's official server — repos, issues, pull requests, Actions and code security, straight from your assistant.
Issue tracking at the speed of conversation — Linear's official hosted server with OAuth and zero install.
Local repository surgery — status, diffs, commits, branches and history for any repo on disk.
Timezone sanity for AI — current time anywhere and correct conversions, without the model doing date math.