A sophisticated data exploration skill that uses the Powerdrill API to transform raw files into interactive insights, charts, and tables via natural language.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install powerdrill-skills
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install powerdrill-skills using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Powerdrill Data Analysis?
The Powerdrill Data Analysis skill is a powerful integration for Openclaw Skills designed to simplify complex data workflows. It allows developers and analysts to interact with datasets using conversational queries instead of writing manual SQL or complex scripts. By utilizing the Powerdrill REST API v2, the skill handles everything from dataset management and file synchronization to the generation of visual charts and analytical summaries.
This skill is particularly valuable for teams that need to process diverse file formats—such as CSV, PDF, Excel, and JSON—and extract meaningful patterns quickly. As part of the Openclaw Skills ecosystem, it provides a seamless bridge between raw data storage and AI-driven intelligence, making data-driven decision-making more accessible through a standardized Python client and CLI interface.
Powerdrill Data Analysis Use Cases
- Automatically uploading and analyzing quarterly sales reports or financial spreadsheets.
- Generating visual data trends and charts directly from raw CSV or Excel data sources.
- Performing deep-dive research into document collections using natural language search and summarization.
- Building automated data pipelines that create temporary datasets for session-based analysis and cleanup.
- Integrating AI-powered data exploration into existing workflows within Openclaw Skills.
How Powerdrill Data Analysis Works
- Configure the environment with your Powerdrill User ID and Project API Key to authenticate with the API.
- Create a new dataset container or search for an existing one using the dataset management functions.
- Upload local files or provide public URLs to ingest data into the chosen dataset.
- Trigger the synchronization process and wait for the system to index the data for analysis.
- Initialize an analysis session to maintain conversational context for sequential questions.
- Run natural language jobs to query the data, which returns text insights, tables, and visualization URLs.
- Use the cleanup utilities to remove sessions or datasets once the analysis is finished to maintain a clean environment.
Powerdrill Data Analysis Setup
To utilize this skill within Openclaw Skills, first ensure you have your Powerdrill credentials. Install the required requests library and set your environment variables:
pip install requests
export POWERDRILL_USER_ID="your_user_id"
export POWERDRILL_PROJECT_API_KEY="your_project_api_key"
You can verify the setup by listing your current datasets via the CLI:
python scripts/powerdrill_client.py list-datasets
Powerdrill Data Analysis Data Schema & Taxonomy
The skill manages data through a structured hierarchy of Datasets, Data Sources, and Sessions. Analysis results are returned in blocks as described below:
| Block Type | Description | Data Included |
|---|---|---|
| MESSAGE | Analytical Insight | Text-based response to the user query |
| TABLE | Structured Data | URL to a downloadable file (CSV/TSV) |
| IMAGE | Visualization | URL to a generated chart or graph |
| SOURCES | Citations | List of references used to generate the answer |
| QUESTIONS | Suggestions | Recommended follow-up questions for exploration |
All generated URLs for tables and images are temporary and should be accessed immediately before expiration.
Powerdrill Data Analysis Advanced Features
- Conversational context retention through persistent analysis sessions.
- Support for a wide array of file formats including .docx, .pptx, .mdx, and .tsv.
- Streaming job support for real-time data processing and immediate feedback.
- Automated polling mechanisms for reliable multi-file synchronization.
- Comprehensive cleanup functions to automate resource management within Openclaw Skills.
SKILL.md
Loading
Related Openclaw Skills
Powerdrill Data Analysis
A sophisticated AI skill for querying, visualizing, and analyzing datasets using the Powerdrill API.
apipick Telegram Phone Checker
A specialized tool for checking Telegram registration status and retrieving profile metadata for any international phone number.
apipick Public Holidays
A high-performance API integration for retrieving international public holiday schedules across 100+ countries.
apipick IP Geolocation
A powerful IP intelligence tool for retrieving detailed geographic and network metadata for any IPv4 or IPv6 address.
2slides
An AI-powered skill for generating professional presentations and slide decks from text content, documents, or reference images via the 2slides API.
i18n for Next.js
A comprehensive implementation guide and toolset for full internationalization (i18n) and localized SEO in Next.js App Router applications.
Featured*
