Data Maintenance Commands

Commands for synchronizing, exporting, and maintaining operational data.

Financial Sync (sc-finance-sync)

Command	Description
sync:stripe	Sync Stripe transactions to local database
sync:qbo	Sync QuickBooks Online transactions
sync:all	Full daily sync pipeline (Stripe + QBO + matching + alerts)

Database Export (pg-export)

Command	Description
pg-export	Export PostgreSQL tables or queries to CSV files

Commit Tracking (github-automator)

Command	Description
gha sync	Sync commits from GitHub to local SQLite database
gha commits	Query commits from local database

Infrastructure Database (ra-infrastructure)

Command	Description
inv db health	Check inventory database health
inv db migrate	Run database migrations
inv db seed	Seed database with initial data
inv db stats	Show database statistics

Typical Workflow

Daily Financial Reconciliation

1. sync:all runs automatically at 6 AM via cron
2. Check results: docker logs sc-finance-sync --tail 50
3. For ad-hoc syncs: docker exec sc-finance-sync npm run sync:stripe 2026-02-01 2026-02-28

Database Export

1. pg-export --list-tables to discover available tables
2. pg-export --table=contact --where="active = true" for filtered export
3. pg-export --all --output=./backup for full database dump to CSV

Commit Audit

1. python -m src.cli sync --org symphonycore-org to pull latest commits
2. python -m src.cli commits --since 2026-02-01 --stats to review activity