Database Sweep

Database Sweep Skill (Gemini Edition)

Projection table health check and migration tracking across all ONEX databases, leveraging Gemini's massive context window to correlate schema definitions with runtime state and identify drift.

Workflow

1. Table Discovery: Gemini cross-references pg_tables with Drizzle schema definitions in omnidash to identify expected vs actual tables.
2. Health Check: Audits each table for row count, staleness, and timestamp column existence.
3. Migration Tracking: Verifies migration state (Alembic/Drizzle) across all ONEX databases, comparing on-disk files with applied head positions.
4. Schema Fingerprinting: Captures and hash-compares sorted column definitions to detect manual schema drift not captured by migrations.
5. Remediation: Auto-creates Linear tickets for stale tables, pending migrations, or failed states.

Gemini Advantages