A professional data analysis framework designed to extract actionable insights through SQL, data validation, and strategic visualization.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install 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 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 Analyst?
The Analyst skill provides a comprehensive methodology for developers and data professionals to navigate complex datasets with precision. Built for the Openclaw Skills ecosystem, it focuses on the philosophy that analysis without action is trivia, guiding users to surface the real questions behind every query. It bridges the gap between technical data extraction and executive-level communication.
By implementing this skill, users benefit from a structured approach to SQL optimization, data quality assurance, and insight-led reporting. Whether you are troubleshooting performance or identifying business trends, the Analyst skill ensures your findings are reproducible, validated, and aligned with stakeholder needs.
Analyst Use Cases
- Clarifying business decisions by framing actionable data questions.
- Validating dataset integrity to eliminate duplicates and source definition errors.
- Building performant SQL queries using Common Table Expressions (CTEs) and window functions.
- Creating purposeful visualizations that match data types to specific trends or comparisons.
- Presenting findings to stakeholders with executive summaries that lead with insights.
How Analyst Works
- Framing: Start by identifying the specific decision that needs to be made and surfacing the hypothesis.
- Validation: Conduct a data quality check, verifying row counts, null rates, and uniqueness to ensure reliable inputs.
- Querying: Develop readable and performant SQL scripts using CTEs and window functions for aggregation.
- Segmentation: Apply analytical cuts like cohort analysis or time-series seasonality to uncover patterns hidden in aggregates.
- Visualization: Select the appropriate chart type—line for trends, bar for comparisons, or histogram for distributions.
- Communication: Summarize findings by leading with the insight and providing actionable recommendations.
Analyst Setup
To deploy the Analyst skill within your environment, ensure your agent has access to your SQL database or data warehouse. You can initialize this skill using the following command within the Openclaw Skills framework:
# Initialize the Analyst skill for your data project
clawdbot install analyst
Ensure your local environment is configured with the necessary SQL drivers and reporting tools as defined in your project manifest.
Analyst Data Schema & Taxonomy
The Analyst skill organizes its workflow and findings through a structured metadata taxonomy to ensure reproducibility:
| Component | Organization Method |
|---|---|
| SQL Scripts | CTE-based structures with documented assumptions and filters |
| Data Quality | Metadata tables tracking null rates, uniqueness, and date ranges |
| Visualization | Markdown-integrated chart specifications and axis labeling |
| Documentation | Insight-first reports with version control history |
| Automation | Scheduled scripts for recurring reporting tasks |
Analyst Advanced Features
- Advanced SQL techniques including CASE statements for categorization and rank-based window functions.
- Cohort analysis capabilities to reveal user behavior patterns over specific joining periods.
- Seasonality awareness for time-series analysis to prevent inaccurate month-over-month comparisons.
- Standardized reporting protocols that prioritize confidence levels and reproducibility.
- Strategic push-back mechanisms to refine stakeholder requests into high-value data questions.
SKILL.md
Loading
Related Openclaw Skills
Analysis System Health Check
A comprehensive system self-diagnosis tool for auditing workspace health, security configurations, and operational efficiency.
Amsterdam
A comprehensive AI-driven knowledge base for navigating Amsterdam as a visitor, tech professional, or resident.
Amazon
A comprehensive AI agent skill for navigating the Amazon ecosystem as a buyer, seller, or affiliate partner.
Alipay
A professional-grade integration skill for implementing secure, signed Alipay payment flows and managing production-ready checkout operations.
Analytics
Implement privacy-centric analytics platforms with production-ready API patterns and regulatory compliance.
Analyze
A rigorous analytical framework that transforms raw input into prioritized, actionable insights and decisions.
Featured*
