An LLM-powered data analyst skill that translates natural language queries into read-only SQL, analyzes results, and generates interactive HTML visualizations.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install data-analyst-visualization
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-analyst-visualization 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 Intelligent Data Analysis Assistant?
The Intelligent Data Analysis Assistant is a powerful, LLM-driven capability designed to democratize business intelligence and data operations. Built to function seamlessly within the Openclaw Skills ecosystem, this skill enables users without any technical or SQL background to query their databases directly using natural language. By converting raw user queries into optimized, read-only SQL statement executions against structured databases or local file assets, it simplifies complex analytical loops.
Whether you are executing ad-hoc reporting, looking for root causes of metrics drops, or comparing quarterly trends, this skill bridges the gap between raw data storage and actionable insights. By using Openclaw Skills like this one, organizations can automate repetitive analytical tasks, generate instant interactive charts, and foster data-driven decision-making across all teams.
Intelligent Data Analysis Assistant Use Cases
- Ad-hoc Business Intelligence: Non-technical managers asking questions like "Sales by region last month?" and receiving immediate visual breakdowns.
- Report Automation: Automatically pulling monthly metrics, formatting them into structured ASCII trend tables, and exporting visual reports.
- Interactive Trend Analysis: Exploring historical patterns and root-cause issues through natural language refinements (e.g., asking "Why did sales drop?" after seeing a decline).
- Cross-Platform Data Exploration: Querying local Excel, CSV, or JSON datasets alongside production cloud warehouses like Snowflake and BigQuery without manual data preparation.
How Intelligent Data Analysis Assistant Works
- Intent Parsing: The skill parses natural language queries to understand analytical intents, metrics, and filter dimensions.
- SQL Generation: It automatically translates the validated intent into read-only SQL tailored to the specific database dialect (MySQL, PostgreSQL, Snowflake, SQLite, etc.).
- Query Execution: Connects to the configured database or reads local files (Excel/JSON/CSV) to execute the read-only query securely.
- Result Analysis: Synthesizes the retrieved data, applying privacy masks and formatting raw numbers into concise metrics.
- Dual-Layer Visualization: Outputs a quick text-based summary in the chat, while simultaneously generating a complete, interactive HTML page populated with Chart.js charts.
- Multi-Turn Refinement: Allows users to iteratively filter, switch dimensions, or perform root-cause analysis on the existing context.
Intelligent Data Analysis Assistant Setup
To deploy this tool as part of your Openclaw Skills workspace, set up your configuration and install any required database adapters.
# Install the data analytics visualization skill dependencies
npm install chart.js
# Or if using Python environment for local file reading
pip install pandas openpyxl
Configure your environment variables for database connectivity in your .env file:
DB_TYPE=postgresql # or mysql, snowflake, sqlite, bigquery, redshift
DB_HOST=your-database-host.com
DB_USER=your_read_only_user
DB_PASSWORD=your_secure_password
DB_NAME=analytics_db
For local file analysis, place your .xlsx, .csv, or .json files in your workspace directory. The skill will automatically generate an overview (row counts, types, sample rows) upon first reading.
Intelligent Data Analysis Assistant Data Schema & Taxonomy
This Openclaw Skills component organizes and structures output assets to ensure complete reproducibility and separate analytical summaries from raw data visualizations.
| Directory / File | Type | Description |
|---|---|---|
{domain}_chart.html |
Generated File | Self-contained, interactive HTML dashboard populated with Chart.js visualization. |
references/data-sources.md |
Configuration Reference | File detailing supported database dialects, Excel reading, and connection strings. |
references/visualization-template.md |
Template | HTML/JS scaffolding blueprint used to render visual charts dynamically. |
Analytical Summary Structure
For inline chat interactions, the output schema strictly follows this taxonomy:
- Results Title: Identifies the core query objective.
- Metrics Table: High-level structured key-value pairs of metrics.
- Trend Graph: Quick-view ASCII trend bars visualizing growth/decline.
- Analysis Narrative: Unordered list summarizing core operational takeaways.
Intelligent Data Analysis Assistant Advanced Features
- Interactive Multi-Turn Refinements: Continuously drill down ("Only show East China"), switch dimensions ("Group by month"), or compare temporal intervals ("vs last quarter") in active conversation.
- Automated Schema Mapping: Auto-inspects local CSV and Excel sheets, generating immediate row count, data types, and initial sample previews.
- Bulletproof Read-Only Safety: Enforces strict SELECT-only query execution to prevent unauthorized data manipulation or deletions.
- Smart Query Control: Prompts the operator for pagination limits on large datasets and auto-masks personally identifiable information (PII) to maintain compliance.
SKILL.md
Loading
Related Openclaw Skills
Storyboard Master
Storyboard Master is an advanced video storyboard and shooting script generator that transforms creative briefs into production-ready, highly detailed visual plans.
Shopify Draggable
A modern, dependency-free JavaScript library for building highly customizable drag-and-drop interfaces like sortable lists, kanbans, and custom grid reorganization.
text-to-svg
An advanced AI-driven utility that translates natural language descriptions directly into fully compliant, responsive SVG vector graphic code.
Full-Link Data Analysis Engine
An advanced seven-layer analytical engine that converts business agendas into structured, cross-validated reports using dynamically generated Python code.
WeChat Mini Program Automator
Automate UI operations, data injection, and end-to-end testing for WeChat Mini Programs directly inside WeChat DevTools.
PerryTS
PerryTS is a cutting-edge native TypeScript compiler that bypasses V8 and Node.js by transforming TypeScript code directly into optimized binaries via SWC parsing and LLVM code generation.
Featured*
