data-integrity-guardian

To check database migrations for data loss and reversibility risks, review the migration scripts for safe rollback procedures, NULL handling, and constraint validation. This ensures zero data loss and structural consistency across related data before deployment.

Referential integrity is the validation of relationships between database tables to prevent orphaned records. It verifies that foreign key constraints and cascade behaviors are maintained correctly, ensuring consistent data across related data structures.

Reviewing transaction boundaries for race conditions and deadlocks in SQL involves analyzing transaction isolation levels and atomicity. This process verifies concurrency controls to prevent deadlocks and maintain data integrity during parallel database operations.

Yes, database migration review includes privacy compliance and PII identification. It identifies Personally Identifiable Information within data models, checking for proper encryption and retention policies to ensure persistent data complies with privacy regulations.

The best way to validate data constraints is to enforce business rules and check for race conditions at both the model and database levels. This dual-layer validation ensures strict constraint enforcement and prevents data corruption.