AI Report Builder

SKILL.md

---
name: ai-report-builder
description: "AI Report Builder — Upload CSV/Excel, AI analyzes data and generates professional reports (charts + narrative). Supports monthly/financial/sales reports. Triggers: auto report, generate report, data report, monthly report, financial report, sales report, data analysis."
triggers:
  - auto report
  - generate report
  - data report
  - monthly report
  - financial report
  - sales report
  - data analysis
allowed-tools: Bash(python3)
---

# AI Report Builder

Upload data (CSV/Excel) → AI analyzes → generates professional reports (charts + narrative + formatting).

---

## Quick Start

```bash
python3 scripts/generator.py --input data.csv --output report.xlsx --template monthly_operation
python3 scripts/generator.py --input sales.xlsx --output monthly.xlsx --template sales
```

---

## Tiered Features

| Feature              | FREE              | PRO               |
|----------------------|:-----------------:|:-----------------:|
| Total uses           | 5 (lifetime)      | Unlimited         |
| Chart types          | Line only         | Line only         |
| AI narrative analysis | —                 | Yes               |
| Multi-sheet Excel    | —                 | Yes               |
| PDF export           | —                 | —                 |
| Price                | Free              | $0.01/report      |

---

## Core Features

- **Multi-format support**: CSV, Excel (.xlsx/.xls)
- **AI-powered analysis**: OpenAI-compatible API
- **Chart generation**: Line, bar, pie, scatter, histogram
- **Multi-sheet Excel reports**: Professional formatting
- **Template system**: Monthly, financial, sales, data comparison, custom

---

## Usage

```bash
python3 scripts/generator.py \
  --input data.csv \
  --output report.xlsx \
  --template monthly_operation \
  --ai-provider openai \
  --ai-model gpt-4o-mini \
  --no-ai
```

**Arguments:**
- `--input/-i`: Data file path (CSV/Excel) — required
- `--output/-o`: Output report path (default: report.xlsx)
- `--template/-t`: Template type (monthly_operation/financial/sales/data_comparison/custom)
- `--ai-provider`: AI provider (openai/deepseek)
- `--ai-model`: AI model name
- `--no-ai`: Skip AI analysis (charts only)
- `--sheet`: Excel sheet name

---

## Supported Templates

| Template | Description |
|----------|-------------|
| `monthly_operation` | Monthly operational report |
| `financial` | Financial analysis report |
| `sales` | Sales performance report |
| `data_comparison` | Period-over-period comparison |
| `custom` | Custom format |

---

## Directory Structure

```
ai-report-builder/
├── SKILL.md
├── requirements.txt
├── scripts/
│   ├── generator.py      # CLI entry point
│   └── __init__.py
└── core/
    ├── parser.py         # Data parsing (pandas)
    ├── charts.py         # Chart generation (matplotlib)
    ├── ai_analyzer.py    # AI analysis (OpenAI-compatible)
    ├── report_builder.py # Excel multi-sheet builder
    ├── quota.py          # Quota management
    └── templates.py      # Template system
```

---

## Billing

- **Pay-per-call**: $0.0100 USDT per execution via SkillPay.me
- **Balance insufficient**: Payment URL returned — user tops up at `https://skillpay.me/ai-report-builder`
- **External data flow**: `FEISHU_USER_ID` transmitted to `skillpay.me/api/v1/billing` for billing identification only; not stored or shared with any third party
- **Billing model**: Each report generation = 1 call = $0.0100 USDT
- **Privacy**: FEISHU_USER_ID is used solely to identify the billing account; no personal data is retained or shared beyond the payment processor

---

## Required Environment Variables

| Variable | Description |
|----------|-------------|
| `SKILL_BILLING_API_KEY` | SkillPay Builder API Key |
| `SKILL_BILLING_SKILL_ID` | SkillPay Skill ID (`ai-report-builder`) |
| `FEISHU_USER_ID` | User open_id for billing (passed by Feishu runtime) |

---

## License

MIT