skills.rest
marchatton
marchattonCOMMUNITY
Explore all skills by this author →
Website𝕏@marchattonhereGitHub

data-integrity-guardian

Review database migrations, data models, and data manipulation code for integrity and privacy compliance.

5|Updated Oct 22, 2025
Search Tags:#database migration#data integrity#data modeling#data governance#privacy compliance#sql review
One-click install
npx skills add https://github.com/marchatton/agent-skills --skill data-integrity-guardian-marchatton
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-integrity-guardian
Source: https://github.com/marchatton/agent-skills/tree/main/.agents/skills/05-review/data-integrity-guardian
Command: npx skills add https://github.com/marchatton/agent-skills --skill data-integrity-guardian-marchatton

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the critical need to ensure the safety and integrity of persistent data by meticulously reviewing database migrations, data models, and any code that manipulates data. It prevents data loss, corruption, and privacy breaches.

Core Features & Use Cases

  • Database Migration Review: Analyzes migrations for safety, reversibility, and potential data loss.
  • Data Constraint Validation: Verifies data models and database constraints for accuracy and consistency.
  • Transaction Management: Ensures proper transaction boundaries, isolation, and rollback handling.
  • Referential Integrity Checks: Confirms that relationships between data are maintained correctly.
  • Privacy Compliance: Assesses adherence to data privacy regulations like GDPR and CCPA.
  • Use Case: Before deploying a new database schema change, use this Skill to review the migration scripts, ensuring no existing data will be compromised and all privacy requirements are met.

Quick Start

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

Frequently Asked Questions about data-integrity-guardian

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

FAQPage Schema
How do I review database migrations for potential data loss before deployment?▼

To review database migrations for potential data loss, analyze migration scripts for safety, reversibility, and transaction boundaries. This ensures zero data loss during deployments by verifying rollback handling and confirming that schema changes do not compromise existing records.

How do I validate ORM data models and database constraints for consistency?▼

Validating ORM data models and database constraints involves verifying referential integrity and data accuracy. This process confirms that relationships between data entities are maintained correctly and that constraints prevent invalid data entries.

How can I audit data access patterns for GDPR and CCPA privacy compliance?▼

Auditing data access patterns for GDPR and CCPA compliance requires assessing how Personally Identifiable Information (PII) is handled. This ensures adherence to privacy regulations by verifying secure data handling practices within applications.

What is the best way to ensure proper transaction management and rollback handling in SQL scripts?▼

Ensuring proper transaction management in SQL scripts requires analyzing transaction boundaries and isolation levels. This approach prevents data corruption by guaranteeing that failed database operations roll back safely without leaving partial updates.

When should I check referential integrity during database schema changes?▼

You should check referential integrity during database schema changes to confirm relationships between data are maintained correctly. Validating referential integrity prevents orphaned records and data corruption when modifying relational database structures.

Related Skills

Explore More Software Engineering Skills→
TorbenMerraldTorbenMerrald
1

Backend Models

Define and enforce database models and entity schemas across ORM and migration scripts.

Community
Advanced
praburajasekaranpraburajasekaran

data-integrity-guardian

Review database migration scripts for data integrity and privacy compliance.

Community
Advanced
pcasarettopcasaretto

data-integrity-guardian

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

Community
Advanced
CENKSSSCENKSSS

database-testing

Validate database schemas, data integrity, migrations, transactions, and query performance.

Community
Advanced