Database Content Extractor

# Extract all tables to CSV (default)
python scripts/db_extract.py course.db

# Extract to JSON
python scripts/db_extract.py course.db -f json

# Extract to Markdown (best for LLM context)
python scripts/db_extract.py course.db -f markdown

# All formats with schema documentation
python scripts/db_extract.py course.db -f all --schema -o ./output

# Extract course DB with schema docs for context
python scripts/db_extract.py course.db -f markdown --schema -o ./course_content

# Only specific tables
python scripts/db_extract.py app.db --tables users,posts,comments

# Exclude system tables
python scripts/db_extract.py app.db --exclude sqlite_sequence,migrations

# Limit markdown rows for large tables (keeps files manageable)
python scripts/db_extract.py large.db -f markdown --max-rows 50

python scripts/db_extract.py DATABASE [OPTIONS]

Arguments:
  DATABASE              Path to SQLite database file

Options:
  -o, --output DIR      Output directory (default: ./extracted)
  -f, --format FORMAT   csv|json|markdown|all (default: csv)
  --tables TABLES       Comma-separated table list
  --exclude TABLES      Tables to skip
  --schema              Include _schema.md documentation
  --max-rows N          Row limit for markdown (default: 100)
  -q, --quiet           Suppress progress output

output/
├── _schema.md          # Schema documentation (if --schema)
├── csv/                # (if format=all)
│   ├── table1.csv
│   └── table2.csv
├── json/
│   └── ...
└── markdown/
    └── ...