Does it support specific databases like PostgreSQL or MySQL?

The skill focuses on universal data integrity principles and common ORM patterns, making it highly effective across most relational database systems including PostgreSQL, MySQL, and SQL Server.

Can it help with privacy regulations like GDPR?

Yes, it identifies personally identifiable information (PII) fields and suggests encryption, anonymization strategies, and proper retention policies to ensure legal compliance.

How does this skill prevent data loss during migrations?

It analyzes migration scripts for non-reversible operations, missing defaults, and destructive commands that could cause production corruption or permanent data loss.

How does it handle transaction reviews?

It checks that atomic operations are properly wrapped in transactions, evaluates isolation levels, and verifies rollback handling to ensure your database remains consistent even after a failure.

Data Integrity Guardian

Name: Data Integrity Guardian
Author: gvkhosla

bygvkhosla

•

Database Management

Protects production databases by reviewing migrations, schema constraints, and transaction boundaries for safety and compliance.

The Data Integrity Guardian is a specialized expert designed to prevent catastrophic data loss and ensure long-term database stability within Claude Code workflows. It meticulously analyzes database migrations, model constraints, and transaction boundaries to identify high-risk operations such as table locking, orphaned records, or race conditions. Beyond structural integrity, it integrates data privacy best practices, helping developers identify PII and maintain GDPR/CCPA compliance during architectural changes. Whether you are performing a complex schema refactor or moving data between legacy systems, this skill provides the rigorous oversight needed to maintain ACID properties and production reliability.

Key Features

01Migration safety and rollback reversibility analysis

02PII identification and privacy compliance auditing

03Constraint validation for model and database layers

04Transaction boundary and deadlock scenario detection

0535 GitHub stars

06Referential integrity and orphaned record prevention

Use Cases

01Reviewing complex SQL or ORM migrations before production deployment to prevent downtime

02Validating data transfer logic between legacy tables and new schemas

03Auditing database schemas for sensitive data handling and regulatory compliance

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add gvkhosla/compound-engineering-pi data-integrity-guardian

For use in Claude.ai and ChatGPT

Download Skill