Overview
Powerdrill MCP Server is an MCP-based backend that exposes tools to interact with Powerdrill datasets using Powerdrill User ID and a Project API Key. It enables authenticated access to manage datasets, list available data sources, create and monitor analysis jobs, and organize work through sessions. The server provides a suite of MCP endpoints (examples include mcp_powerdrill_list_datasets, mcp_powerdrill_get_dataset_overview, mcp_powerdrill_create_job, mcp_powerdrill_create_session, mcp_powerdrill_list_data_sources, mcp_powerdrill_list_sessions, mcp_powerdrill_create_dataset, and mcp_powerdrill_create_data_source_from_local_file) to perform common data analysis workflows. It supports integration with Claude Desktop and Cursor, allowing users to connect via npm/npx or a local Node.js installation. The README also describes quick setup scripts, environment variable configuration, and a manual installation path. The server can run NLQ-based questions, upload local files as data sources, and manage datasets and sessions to enable collaborative, AI-powered data insights.
Features
Authenticate with Powerdrill using User ID and Project API Key
Securely authenticate to access datasets and manage resources.
List available datasets in your Powerdrill account
Query and retrieve the datasets you can access.
Get detailed information about specific datasets
Fetch metadata, descriptions, and exploration questions for datasets.
Create and run jobs on datasets with natural language questions
Submit NLQ-based analytics jobs and receive results.
Integration with Claude Desktop and other MCP-compatible clients
Connect the MCP server to Claude Desktop and other MCP clients for workflows.
Who Is This For?
- Data Analysts:Run NLQ-based analysis on Powerdrill datasets and extract insights efficiently.
- Developers:Integrate the MCP server with Claude Desktop, Cursor, and other MCP clients to access datasets.
- Team Administrators:Manage credentials, datasets, sessions, and configurations for Powerdrill teams securely.
