Auto Report Generator Skill

Features

Upload data (CSV/Excel) → AI analyzes → generates professional reports (charts + narrative + formatting) — one-click monthly/weekly reports.

Core Files

• SKILL.md - This file
• scripts/generator.py - Main generator script (CLI entry point)
• core/parser.py - Data parsing (pandas)
• core/charts.py - Chart generation (matplotlib/xlsxwriter)
• core/ai_analyzer.py - AI analysis (OpenAI-compatible API)
• core/report_builder.py - Report building (multi-sheet Excel)
• core/quota.py - Quota management (Free: 5 uses absolute count)
• core/templates.py - Template system
• core/token_validator.py - API key verification
• scripts/quick_report.sh - Quick generation script

Installation

pip install pandas openpyxl xlsxwriter matplotlib pillow -q

Usage

Call via Skill system scripts/generator.py with arguments:

• --file Data file path
• --template Template type (monthly/financial/sales/comparison/custom)
• --ai-provider AI provider (openai/deepseek)
• --ai-model AI model
• --tier Subscription tier (FREE/STD/PRO/MAX)
• --output Output path

Pricing

Token Prefix

REPORT-FREE / REPORT-STD / REPORT-PRO / REPORT-MAX

Directory Structure

auto-report-generator/
├── SKILL.md
├── README.md
├── requirements.txt
├── CLAWHUB.md
├── SKILLHUB.md
├── scripts/
│   ├── generator.py     # CLI entry point
│   ├── quick_report.sh   # Quick generation script
│   └── __init__.py
└── core/
    ├── parser.py         # Data parsing
    ├── charts.py         # Chart generation
    ├── ai_analyzer.py   # AI analysis
    ├── report_builder.py # Excel report builder
    ├── quota.py         # Quota management
    ├── templates.py      # Template system
    └── token_validator.py # API key verification

License

MIT

> For paid plans, visit YK-Global.com