Database Schema Review

Core Workflow

1. Identify the domain model, queries, write patterns, data lifecycle, and database engine assumptions.
2. Review tables, columns, types, relationships, constraints, indexes, uniqueness, nullability, and migration path.
3. Check data integrity, tenant/user boundaries, privacy, auditability, and deletion or retention needs.
4. Compare schema design against API and product access patterns.
5. Flag migration, backfill, locking, rollback, and performance risks.
6. Recommend concrete schema changes and validation checks.

Safety Rules