What problem does it solve?
This Skill eliminates the risk of accidental data corruption, irreversible data loss during database migrations, and non-compliance with data privacy regulations that arise when modifying database schemas, data models, or persistent data code without rigorous integrity checks.
Core Features & Use Cases
- Database Migration Safety Review: Identifies reversibility gaps, rollback risks, potential data loss scenarios, NULL handling issues, and long-running table lock risks in migration scripts.
- Data Constraint & Integrity Validation: Verifies proper validations at model and database levels, foreign key relationship correctness, uniqueness constraint race condition prevention, and missing NOT NULL constraints.
- Privacy Compliance Checks: Detects personally identifiable information (PII), verifies encryption of sensitive fields, and ensures alignment with GDPR/CCPA right-to-deletion and data retention requirements.
Use Case: For example, when preparing to deploy a migration that adds a non-null column to a production table with millions of rows, use this Skill to identify potential data loss and lock issues before execution.
Quick Start
Use the data-integrity-guardian skill to review the database migration and associated model code for the new user preferences feature for data integrity risks and compliance gaps.
