data-integrity-guardian

Reviews database migrations and models for safety, integrity, privacy compliance.

5|1|Updated Aug 26, 2025

Search Tags:#database migration #data integrity #data validation #transaction management #data governance #privacy compliance

Ready to run

npx skills add https://github.com/hollandkevint/thinkhaven --skill data-integrity-guardian-hollandkevint

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: data-integrity-guardian
Source: https://github.com/hollandkevint/thinkhaven/tree/main/.gemini/skills/data-integrity-guardian
Command: npx skills add https://github.com/hollandkevint/thinkhaven --skill data-integrity-guardian-hollandkevint

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill proactively identifies and mitigates risks associated with database migrations, data models, and persistent data code, ensuring the safety, consistency, and privacy of your data.

Core Features & Use Cases

Migration Safety Review: Analyzes database migrations for potential data loss, rollback issues, and performance impacts.
Data Constraint Validation: Verifies the presence and correctness of data validations, uniqueness constraints, and foreign key relationships.
Transaction Boundary Checks: Ensures atomic operations are properly transactional and avoids deadlocks.
Referential Integrity Preservation: Guards against orphaned records and improper cascade behaviors.
Privacy Compliance: Assesses PII handling, encryption, and adherence to regulations like GDPR.
Use Case: Before deploying a new database schema change, use this Skill to review the migration scripts for any potential data corruption or privacy violations.

Quick Start

Review the attached database migration script for potential data integrity issues.

Frequently Asked Questions about data-integrity-guardian

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I check database migration scripts for potential data loss before deploying?▼

To check database migration scripts for data loss, you can review them for migration reversibility, rollback issues, and constraint validation to ensure persistent data safety and consistency before deployment.

What is referential integrity and how do I prevent orphaned records during schema changes?▼

Referential integrity prevents orphaned records by enforcing foreign key relationships. You preserve it during schema changes by verifying cascade behaviors and constraint validation within your data models.

How do I ensure transaction atomicity and avoid deadlocks in persistent data code?▼

To ensure transaction atomicity and avoid deadlocks, you need transaction boundary checks that verify operations are properly transactional, preventing partial updates and maintaining data consistency.

Can I automate GDPR and CCPA privacy compliance checks for my database schema?▼

You can automate privacy compliance checks by reviewing persistent data code for PII handling, encryption, and adherence to GDPR and CCPA regulations to mitigate privacy violation risks.

Does data integrity review work with existing data models to validate uniqueness constraints?▼

Data integrity review works with existing data models by verifying the presence and correctness of data validations, uniqueness constraints, and foreign key relationships to prevent data corruption.