Data

What This Skill Does

The Data skill is a comprehensive toolkit designed to manage the entire lifecycle of information, transforming raw, messy inputs into actionable intelligence. Whether you are dealing with SQL databases, complex JSON APIs, or fragmented CSV/Excel files, this skill acts as your automated data engineer and analyst. It handles extraction, cleaning, normalization, statistical analysis, and high-quality visualization, ensuring that your data workflows are reproducible, documented, and accurate.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal: clawhub install openclaw/skills/skills/ivangdavila/data Ensure you have appropriate permissions to establish connections to your designated data sources or local file directories before initiating the first run.

Use Cases

• Database Engineering: Automatically generate complex SQL queries, optimize joins, and design schemas based on business requirements.
• Data Cleaning: Automate the detection and resolution of null values, duplicate entries, and inconsistent formatting in large datasets.
• Exploratory Data Analysis (EDA): Perform statistical profiling, identify correlations, and surface anomalies in new or unfamiliar datasets.
• Business Intelligence: Create recurring reports, interactive dashboards, and visual representations of KPIs to support executive decision-making.
• Scientific Research: Conduct rigorous statistical testing and ensure data pipeline reproducibility for academic or technical documentation.

Example Prompts

1. "Clean the sales.csv file, fill missing values in the 'revenue' column with the mean, remove duplicates, and then tell me which region had the highest growth last quarter."
2. "Connect to the PostgreSQL analytics database and write a query to extract the last 30 days of user activity, then visualize the daily sign-up trend as a line chart."
3. "Analyze this JSON dataset of weather patterns. Perform an exploratory analysis to check for data drift and calculate the correlation between humidity and equipment failure rates."

Tips & Limitations

• Transparency: Always request a preview of transformations. The skill is designed to be transparent, documenting the 'why' and 'how' of every modification made to your data.
• Security: When connecting to external APIs or production databases, ensure you provide credentials via secure environment variables rather than hardcoding them into your prompts.
• Validation: Remember that while the skill automates cleaning, it relies on your input regarding domain-specific business rules. Always verify the results of automated cleaning on critical production sets.
• Data Privacy: Avoid passing sensitive PII or unredacted financial information through public API connections without appropriate masking. Always adhere to your organization's internal data governance policies when using the Agent to process sensitive information.