Technical Integration Guide

API Access

Powerdrill exposes a RESTful API that allows developers to trigger agent workflows, upload datasets, and retrieve results programmatically. Authenticate using an API key obtained from your account dashboard.

curl -X POST https://api.powerdrill.ai/v1/query \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "dataset_id": "ds_abc123",
    "question": "What is the month-over-month revenue trend?"
  }'

Key Concepts

Datasets — Upload structured files (CSV, XLSX) or connect SQL/cloud sources. Each dataset receives a unique dataset_id.
Agent Sessions — Queries are processed by a multi-agent pipeline; responses include text, chart data (JSON), and metadata.
RAG Layer — Unstructured documents (PDFs, reports) can be added to a knowledge base and queried alongside structured data.
Webhooks — Configure webhooks to receive async results for long-running agent tasks.

Supported Integrations

Connect via native connectors or API to sources such as PostgreSQL, MySQL, Google Sheets, S3, and file uploads.