data-integrity-guardian

What problem does it solve?

This Skill acts as a data integrity guardian, auditing migrations, data models, and governance rules to prevent data loss, preserve referential integrity, and ensure compliance with privacy regulations.

Core Features & Use Cases

• Migration safety reviews: evaluate reversibility, rollback safety, idempotency, and potential data loss.
• Constraint and integrity validation: verify NOT NULL constraints, foreign keys, unique constraints, and race conditions; ensure business rules are consistently enforced.
• Transactional integrity and governance: ensure atomic operations, proper isolation, and robust rollback handling; apply across complex multi-step migrations.
• Privacy and compliance support: identify PII, ensure data minimization, maintain audit trails, and support GDPR/CCPA data requests.

Quick Start

• To begin, provide the migration script and related schema details to the data-integrity-guardian and request a safety review.
• Example: User asks: "Please review the add_status_to_orders migration for safety and data integrity." Assistant responds with a structured assessment covering reversibility, constraints, and privacy considerations.