Data Compare Engine

SKILL.md

# Data Compare Engine

AI-powered data comparison tool for matching and analyzing differences between two CSV/Excel files.

## Features

- **File Parsing**: Auto-detect encoding, parse CSV and Excel files
- **AI Column Matching**: Automatically identify columns with the same meaning across two files
- **Precise Comparison**: Exact match / left-only / right-only / modified row detection
- **Difference Report**: Markdown report with counts, percentages, and amount differences
- **CSV Export**: Export all differences to CSV files

## Usage

### Environment Variables

| Variable | Required | Description |
|----------|----------|-------------|
| `OPENAI_API_KEY` | Yes | OpenAI API Key (for AI column matching) |
| `AI_MODEL` | No | AI model, defaults to `gpt-4o`. Also supports `claude-3-5`, `glm-4` |

### How It Works

1. Upload two data files (CSV or Excel)
2. System automatically:
   - Parses file content
   - Uses AI to identify corresponding columns
   - Executes data comparison
   - Generates difference report

### Output

- **Markdown Report**: Summary of comparison results
- **CSV Files**: All difference rows (left-only / right-only / modified)

## Pricing

| Tier | Price | Description |
|------|-------|-------------|
| FREE | Free | 10 uses total, 200 rows max per use |
| PRO | $0.01 USDT/use | 5,000 rows per use |

## Billing

This skill uses SkillPay for per-use billing. Each comparison operation costs $0.01 USDT.

Set `SKILLPAY_API_KEY` environment variable for billing.

## Env Variables

- `OPENAI_API_KEY`: Your OpenAI API key
- `AI_MODEL`: Model to use (gpt-4o, claude-3-5, glm-4)
- `SKILLPAY_API_KEY`: SkillPay billing API key

## Limits

- File size: max 10MB
- FREE tier: 200 rows per use
- PRO tier: 5,000 rows per use

## Purchase

For PRO tier, visit: https://skillpay.me/data-compare-engine