SSoT Reconcile

When to Use

Run at the start of every session (quick mode) so you load the live state of every active customer instead of relying on stale memory. Run full weekly or before major work. Run fix after full to apply codified auto-fixes.

Use when:

• Starting a new session and need to know which customers exist, what state they're in, what's open
• Suspecting drift between PG and Aitable (after seeing a memory/doc reference that contradicts a live row)
• Before fixing a "broken" customer-facing thing — confirm whether it's actually broken in PG vs just stale in a mirror
• After a session that touched many tenants, to verify the cleanup landed everywhere

NOT for: schema/column drift (use schema-integrity), migration validation, Prisma/Drizzle build issues.

Critical Rules