- Powerdrill
Powerdrill
What is Powerdrill?
Powerdrill is a Model Context Protocol (MCP) server designed to provide tools for interacting with Powerdrill datasets, ensuring secure access through user authentication.
How to use Powerdrill?
To use Powerdrill, install the MCP server via npm, configure your environment variables with your Powerdrill User ID and Project API Key, and run the server. You can then interact with datasets using natural language queries.
Key features of Powerdrill?
- Secure authentication with User ID and Project API Key
- Listing and detailed information retrieval of datasets
- Job creation and execution on datasets using natural language
- Integration with Claude Desktop and other MCP-compatible clients
Use cases of Powerdrill?
- Analyzing sales data trends over time.
- Creating data analysis sessions for collaborative projects.
- Retrieving detailed dataset information for reporting.
FAQ from Powerdrill?
- What is the purpose of the MCP server?
The MCP server allows users to securely interact with their datasets without the risk of accidental data deletion.
- How do I authenticate?
You authenticate using your Powerdrill User ID and Project API Key, which can be obtained from your account settings.
- Can I modify data using this server?
The current implementation is read-only for security reasons. To modify data, you need to use the Powerdrill web interface.
Server Config
{
"mcpServers": {
"powerdrill": {
"command": "npx",
"args": [
"-y",
"@powerdrillai/powerdrill-mcp@latest"
],
"env": {
"POWERDRILL_USER_ID": "<YOUR_POWERDRILL_USER_ID>",
"POWERDRILL_PROJECT_API_KEY": "YOUR_POWERDRILL_PROJECT_API_KEY"
}
}
}
}