/install data-analyst-visualization
Intelligent Data Analysis Assistant
Talk to your data through natural language. No SQL or technical background required for data query, analysis, and visualization.
Workflow
User question → Parse intent → Generate SQL → Execute query → Analyze results → Visualize → Output conclusions
Core Capabilities
1. Natural Language → SQL
Chinese questions auto-converted to SQL:
| User Question | SQL |
|---|---|
| "Sales by region last month?" | SELECT region, SUM(amount) FROM sales WHERE month='2026-04' GROUP BY region |
| "Which product has the highest return rate?" | SELECT product, COUNT(*) FROM orders WHERE status='returned' GROUP BY product ORDER BY 2 DESC LIMIT 1 |
| "Compare user growth vs same period last year" | SELECT DATE_TRUNC('month', created_at), COUNT(*) FROM users WHERE created_at >= NOW() - INTERVAL '1 year' GROUP BY 1 ORDER BY 1 |
2. Data Visualization
Results output in two layers:
- Layer 1: Inline Markdown summary (metrics table + ASCII trend + conclusions)
- Layer 2: Standalone HTML page (Chart.js interactive charts), see references/visualization-template.md
3. Multi-turn Conversation
| Mode | Description |
|---|---|
| Refine | "Only show East China" → append filter |
| Switch dimension | "Group by month" → re-aggregate |
| Root cause | "Why did it drop?" → drill down |
| Compare | "vs last quarter?" → time comparison |
4. File Data Reading
Supports Excel (.xlsx/.xls), JSON/JSONL, CSV file reading. See references/data-sources.md.
5. Database Connections
MySQL / PostgreSQL / Snowflake / SQLite / BigQuery / Redshift. See references/data-sources.md.
Output Format
Inline chat output:
📊 Results: {title}
─────────────────────────────
{metrics table}
📈 Trend:
{ASCII trend bars}
📋 Analysis:
1. ...
For charts, auto-generate HTML page → write to {domain}_chart.html → report path.
Notes
- SQL limited to read-only SELECT
- Privacy fields auto-masked
- Large datasets prompt for LIMIT
- Vague questions trigger clarifying questions
- Uses mock data when no data source configured
- File reading auto-outputs overview (row count, columns, types, first 5 rows)
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install data-analyst-visualization - After installation, invoke the skill by name or use
/data-analyst-visualization - Provide required inputs per the skill's parameter spec and get structured output
What is Intelligent Data Analysis Assistant?
LLM-powered intelligent data analysis assistant supporting natural language queries, SQL generation, visualization, and multi-turn conversation. Suitable for... It is an AI Agent Skill for Claude Code / OpenClaw, with 47 downloads so far.
How do I install Intelligent Data Analysis Assistant?
Run "/install data-analyst-visualization" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Intelligent Data Analysis Assistant free?
Yes, Intelligent Data Analysis Assistant is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Intelligent Data Analysis Assistant support?
Intelligent Data Analysis Assistant is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Intelligent Data Analysis Assistant?
It is built and maintained by OpenLark (@openlark); the current version is v1.0.0.