Data Synthesizer CLI — Free Demo (Windows x64)
===============================================

Offline relational mock-data generator from SQL DDL.
No internet required for the default engine. No API key.
Fake/mock data only.

LIMITS
------
Free demo: maximum 1000 rows per table.

WHAT IT DOES
------------
1. Reads your CREATE TABLE schema (.sql)
2. Generates synthetic rows with valid foreign keys
3. Writes JSON or a ready-to-run SQL INSERT seed script

QUICK START
-----------
1. Keep your schema .sql next to DataSynthesizerCLI.exe
   (samples are included: test_schema.sql and ecommerce_schema.sql)

2. Open PowerShell in this folder and run:

   .\DataSynthesizerCLI.exe test_schema.sql -r 100 --format sql -o seed.sql

3. Create your real tables from the DDL, then run seed.sql in your database.

USEFUL FLAGS
------------
  -r, --rows <n>           Rows per table (max 1000 in demo)
  -o, --output <file>      Output path (.json or .sql)
  -f, --format json|sql    Output format (Default: json)
                           A .sql output name also implies SQL format
  --seed <n>               Reproducible offline generation
  --ai                     Optional Claude mode (needs ANTHROPIC_API_KEY)
  --max-retries <n>        AI validation retries (Default: 3)
  -h, --help               Show help

EXAMPLES
--------
  .\DataSynthesizerCLI.exe test_schema.sql -r 50 -o mock_data.json
  .\DataSynthesizerCLI.exe ecommerce_schema.sql -r 200 --format sql -o seed.sql
  .\DataSynthesizerCLI.exe my_schema.sql -o seed.sql --seed 42

NOTES
-----
- Generates synthetic/fake data only. Do not use as real PII.
- Default mode is fully offline (no network).
- Parent tables are inserted before children so foreign keys stay valid.
- Works offline after download.
