A professional-grade AI skill pack for automating SQL generation, Python-based data analysis, and visual business reporting.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install pro-data-analyst
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 pro-data-analyst 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 Analyst Pro?
Data Analyst Pro is a comprehensive suite designed to turn raw data into professional insights. It provides a robust framework for handling complex data tasks, ranging from generating intricate SQL queries to performing advanced statistical analysis using Python and Pandas. This skill is built for professionals who need to bridge the gap between technical data manipulation and executive-level reporting.
By leveraging the power of Openclaw Skills, this tool ensures that your data processing remains local and secure. It offers a structured approach to data science workflows, including automated data cleaning, anomaly detection, and a library of over 30 SQL templates. Whether you are a developer, a data analyst, or a product manager, this skill accelerates your analytical throughput while maintaining high technical standards.
Data Analyst Pro Use Cases
- Automating the creation of complex SQL queries for funnel and RFM analysis.
- Performing rapid exploratory data analysis (EDA) on local CSV or Excel files.
- Generating recurring weekly or monthly sales reports with automated visualizations.
- Conducting statistical significance tests like T-tests and ANOVA for product experiments.
- Cleaning and transforming messy datasets by identifying missing values and outliers.
How Data Analyst Pro Works
- Input source identification: The user provides a data schema, a database connection description, or a local data file.
- Pattern recognition: The skill analyzes the data structure to identify dates, categories, and numerical fields.
- Logic generation: Based on user prompts, the AI generates optimized SQL code or Python scripts using libraries like Pandas and Scipy.
- Local execution: The generated code runs within the user's secure environment to process the data.
- Output synthesis: The skill produces a final report in Markdown, including key performance indicators (KPIs), visual charts, and actionable insights.
Data Analyst Pro Setup
To deploy Data Analyst Pro within your environment, ensure you have the necessary dependencies installed for data processing.
# Install the core analytical stack
pip install pandas matplotlib seaborn scipy
# Add the skill to your local Openclaw Skills library
openclaw install data-analyst-pro
Once installed, you can trigger the skill by providing context about your database schema or uploading a dataset for analysis.
Data Analyst Pro Data Schema & Taxonomy
The skill organizes its operations into specialized modules for consistency and speed:
| Module | Data Type | Description |
|---|---|---|
| SQL Templates | Structured Query Language | Pre-defined patterns for growth, retention, and cohorts. |
| Python Analytics | Pandas/NumPy Scripts | Automated cleaning, merging, and aggregation logic. |
| Visualization | Matplotlib/Seaborn | Code for generating trend lines, heatmaps, and distributions. |
| Reporting | Markdown | Templates for executive summaries and detailed findings. |
Data Analyst Pro Advanced Features
- Intelligent Data Type Recognition: Automatically suggests the best analysis method based on the input data format.
- Automated Anomaly Detection: Proactively flags duplicates, missing values, and statistical outliers.
- Visualization Recommendation Engine: Recommends the most effective chart types (e.g., Heatmaps for correlation, Boxplots for distribution).
- Privacy-First Analysis: Designed for Openclaw Skills to ensure no sensitive data is ever uploaded to external servers.
- Multi-Step Reporting: Generates full Markdown reports with embedded visual assets and statistical summaries.
SKILL.md
Loading
Related Openclaw Skills
Meditation App Promo Video
A professional AI video generation tool designed to create emotionally resonant promotional content and App Store previews for meditation and mindfulness applications.
Fake Completion Diagnosis (VeriClaw)
A diagnostic intent alias for VeriClaw that identifies and resolves instances where AI agents falsely claim to have completed a task.
Fund AI Assistant
A local-first investment tracking tool that leverages LLMs for deep quantitative fund analysis and automated portfolio management.
AI Hallucination Remediation
A specialized intent alias for VeriClaw focused on detecting, correcting, and remediating AI hallucinations and agent workflow failures.
Claude Code Security Scan
A comprehensive security auditing tool for Claude Code configurations designed to detect vulnerabilities, misconfigurations, and injection risks.
Outlook via Maton Gateway
Access and manage Microsoft Outlook email, calendar, and contacts via the Maton Gateway for seamless AI agent integration.
Featured*
