Powerdrill MCP Server

What is Powerdrill MCP Server?

A Model Context Protocol (MCP) server that provides tools to interact with Powerdrill datasets, authenticated with Powerdrill User ID and Project API Key. It is intended for AI data analysis individually or with a team via Powerdrill.

How to use Powerdrill MCP Server?

Install via npm (npm install -g @powerdrillai/powerdrill-mcp or npx -y @powerdrillai/powerdrill-mcp@latest) or through Smithery. Set the environment variables POWERDRILL_USER_ID and POWERDRILL_PROJECT_API_KEY (or use a .env file), then start the server with powerdrill-mcp or npm start. Integrate with MCP‑compatible clients like Claude Desktop or Cursor by adding the server configuration (recommended npx method) in the client’s settings.

Key features of Powerdrill MCP Server

• Authenticate using Powerdrill User ID and Project API Key
• List available datasets in your Powerdrill account
• Get detailed information about specific datasets
• Create and run jobs on datasets with natural language questions
• Group related jobs into sessions
• List data sources within a dataset

Use cases of Powerdrill MCP Server

• Ask “What datasets are available?” to list all datasets in your account.
• Create a new dataset with a name and description directly from a chat.
• Upload a local file (CSV, Excel, PDF) as a data source to a dataset.
• Run a natural language analysis job, e.g., “How has the trend changed over time?”
• Create a session to organize multiple analysis jobs on related topics.

FAQ from Powerdrill MCP Server

What credentials are required to use Powerdrill MCP Server?

You need a Powerdrill Team account with a valid User ID and Project API Key. Sign up at Powerdrill, then find these in your account settings under the API section.

How do I configure environment variables for Powerdrill MCP Server?

Set POWERDRILL_USER_ID and POWERDRILL_PROJECT_API_KEY as environment variables, or create a .env file with those values. The server reads them at startup.

Which MCP-compatible clients are supported?

The server works with Claude Desktop, Cursor, Cline, Windsurf, and other MCP‑compatible clients. Setup instructions for Claude Desktop and Cursor are provided in the README.

Can I stream job results?

Yes, the mcp_powerdrill_create_job tool includes a stream parameter (default: false). Set it to true to stream results.

How do I get the Powerdrill User ID and Project API Key?

Sign up for a Powerdrill Team account, go to your account settings, and locate the API section. Video tutorials for creating a team and setting up API credentials are linked in the README.