A high-performance local data analysis engine that uses SQL and Python to process complex datasets with total privacy.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install data-skill
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 data-skill 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 Data Analysis Assistant?
The Data Analysis Assistant is an advanced integration for Openclaw Skills designed to handle high-frequency, complex data tasks in daily office scenarios. Unlike traditional AI tools that struggle with large files, this skill operates on a Local Code Execution paradigm. It moves away from reading data into the context window, instead utilizing Python scripts and SQLite to perform heavy lifting directly on your machine.
By leveraging this Openclaw Skills extension, developers and analysts can perform data cleaning, cross-table queries, and semantic extraction while maintaining strict data privacy. The system is built for reliability, using non-destructive operations and an undo mechanism to ensure that your original datasets remain untouched while you experiment with data manipulation and reporting.
Data Analysis Assistant Use Cases
- Processing massive Excel, CSV, or WPS (.et) files without hitting LLM token limits.
- Performing cross-table SQL joins and complex aggregations on local databases.
- Generating interactive ECharts visualizations including 3D charts and geographic maps.
- Automating data cleaning tasks like deduplication and missing value handling.
- Executing fuzzy joins and semantic extraction for mismatched data strings.
How Data Analysis Assistant Works
- Data Ingestion: The agent identifies uploaded files and uses a local importer script to convert them into a structured SQLite database.
- Schema Analysis: It automatically runs PRAGMA checks to understand table structures and metadata without manual input.
- Local Computation: Based on user requests, the agent generates and executes SQL or Python code locally via the RunCommand interface.
- Visualization & Rendering: For charts, the skill utilizes a template-based engine to generate interactive HTML reports served via a local HTTP server.
- Export & Reporting: Finalized datasets are exported back to Excel or CSV formats, accompanied by a Markdown summary report.
Data Analysis Assistant Setup
To get started with this component of Openclaw Skills, ensure your workspace has Python and SQLite installed, then initialize your environment:
# Install required dependencies
pip install pandas sqlite3 thefuzz openpyxl
# Import your first dataset to initialize the workspace database
python scripts/data_importer.py "your_data.xlsx" --db workspace.db
Data Analysis Assistant Data Schema & Taxonomy
The skill manages data through a structured local hierarchy to ensure consistency and easy cleanup:
| Directory/File | Purpose |
|---|---|
workspace.db |
The central SQLite database storing all imported tables and views. |
outputs/html/ |
Storage for generated interactive charts and visual reports. |
outputs/configs/ |
JSON configurations used by the chart generation engine. |
references/metrics.md |
A persistent store for business definitions and metric calculation logic. |
references/prompts/ |
Templates for ECharts configurations and data structures. |
Data Analysis Assistant Advanced Features
- Undo Mechanism: Automatically creates versioned tables (v2, v3) for all structural changes to allow easy rollbacks.
- Metrics Management: A persistent metrics store ensures that future SQL generation remains consistent with established business logic.
- Automated Geocoding: Built-in support for mapping coordinates in geographic visualizations.
- Intelligent Deduplication: MD5 hashing prevents redundant imports of identical files, saving storage and processing time.
- Automated Data Maintenance: Includes a cleaner script to prune metadata and tables older than 30 days.
SKILL.md
Loading
Related Openclaw Skills
Nearby Beaches
A specialized geolocation skill for AI agents to discover and filter beaches based on real-time coordinates.
Practical News Monitor
A robust news monitoring framework for Openclaw Skills designed to track high-value keywords like geopolitics, oil, and gold across multiple data sources.
System Healthcheck
A three-tier system health monitoring tool with a heartbeat mechanism designed for high-availability AI agent environments.
Createrepo Skill
A professional RPM repository management tool for creating, updating, and synchronizing YUM/DNF repositories with full metadata support.
WinForms to Qt Mapper
A professional migration toolkit designed to transition legacy C# WinForms applications into high-performance, layered Qt C++ architectures.
Knorish
A powerful integration for Knorish that allows AI agents to manage online courses, enrollments, and marketing funnels through the Membrane ecosystem.
Featured*
