Powerdrill

Created By
powerdrillaia year ago
Overview

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?

  1. Analyzing sales data trends over time.
  2. Creating data analysis sessions for collaborative projects.
  3. 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"
      }
    }
  }
}
Project Info
Created At
a year ago
Updated At
a year ago
Author Name
powerdrillai
Star
-
Language
-
License
-

Recommend Servers

View All
Scratchpad Mcp
@MikePressure

scratchpad-mcp is an MCP server that gives AI agents persistent, token-efficient storage. It solves a specific waste problem: agents constantly re-read files they've already seen, re-summarize documents they've already processed, and re-load context they've already understood. Every one of those round-trips burns tokens for no new information. This server fixes that with eight tools designed around how agents actually work: Versioned writes. write_file automatically versions every write and keeps the 10 most recent versions per file. Storage is append-only on success and atomic on failure partial writes can't corrupt state. Structured diffs. read_file accepts a since_version parameter and returns a JSON line-diff against that prior version instead of the full content. Agents that have already seen v1 can ask "what changed in v3?" and get a small structured payload they can reason about, not the entire file again. Append-only logs. append_log and read_log give agents an event-stream they can replay. Cursor-based pagination (since_entry + last_entry_id + has_more) means an agent can checkpoint where it left off and resume cheaply. On-demand summaries. summarize_file calls Claude Haiku to summarize files over ~2000 estimated tokens. Summaries are cached per file version, so repeat calls on an unchanged file cost nothing. The threshold is enforced server-side you can't accidentally pay to summarize something small. Per-agent isolation. Every operation is scoped by an agent_id parameter, so one server instance can serve many agents without leaking state between them. Storage limits. 1 MB per file write, 64 KB per log entry, 1000 files / 100k log entries / 100 MB total per agent sane multi-tenant guardrails out of the box. Backed by a single SQLite file (Postgres migration is on the roadmap). All SQL is parameterized, paths are validated against a strict allowlist, and the security model is documented honestly it's safe for one-user-per-process deployments today, and the V2 plan derives agent_id from the caller's API key for true multi-tenancy. Build agents that remember what they've already seen.

a day ago