data-integrity-guardian

Migration safety reviews evaluate reversibility, rollback capability, and idempotency to prevent data loss. The data-integrity-guardian audits migration scripts for potential issues before deployment, checking for constraint violations, incomplete rollbacks, and unsafe schema changes that could corrupt or delete data.

Referential integrity validation verifies foreign keys, NOT NULL constraints, unique constraints, and race conditions are preserved during migrations. The guardian ensures business rules remain consistently enforced across schema modifications and identifies constraints that could be violated by data transformations.

Privacy and compliance support identifies personally identifiable information, ensures data minimization, maintains audit trails, and facilitates GDPR and CCPA data requests. The guardian reviews migrations to confirm sensitive data is handled according to regulatory requirements and organizational policies.

Yes. The guardian validates atomic operations, proper isolation levels, and robust rollback handling for complex multi-step migrations. It ensures transactional boundaries are maintained and that partial failures are handled safely without leaving data in inconsistent states.

Provide the migration script and related schema details to receive a structured assessment covering reversibility, constraint validation, transactional safety, and compliance considerations. This proactive review identifies risks and ensures the migration meets safety and governance requirements before deployment.