skills.rest
hollandkevint
hollandkevintCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/hollandkevint/thinkhaven --skill data-integrity-guardian-hollandkevint
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
udecodeudecode
240

data-integrity-guardian

Review database migrations, data models, and persistent data code for safety and integrity.

Official
Advanced
jikig-aijikig-ai
12

data-integrity-guardian

Review database migrations for rollback safety, constraints, and PII risks.

Official
Advanced
gztcodegztcode

requesting-code-review

Automate code review with static security scanning, quality gates, and an independent reviewer subagent.

Community
Advanced
ksmuvvaksmuvva

Privacy Checker Skill

Detect PII and anonymize datasets with compliance checks for GDPR, HIPAA, and CCPA.

Community
Advanced