skills.rest
CristoVentures
CristoVenturesOFFICIAL
Explore all skills by this author →
GitHub

data-integrity-guardian

Analyze database migrations and data models for integrity and compliance.

2|Updated Apr 14, 2026
Search Tags:#data-integrity#database-migrations#data-governance#referential-integrity#audit-trails#privacy-compliance
One-click install
npx skills add https://github.com/CristoVentures/LocalCents --skill data-integrity-guardian-cristoventures
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-integrity-guardian
Source: https://github.com/CristoVentures/LocalCents/tree/main/.agent/skills/data-integrity-guardian
Command: npx skills add https://github.com/CristoVentures/LocalCents --skill data-integrity-guardian-cristoventures

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps teams review database migrations, data models, and data-manipulation code to prevent data loss, uphold referential integrity, and ensure privacy compliance in production systems.

Core Features & Use Cases

  • Migration safety analysis: assess reversibility, rollback safety, and potential data loss.
  • Constraint and integrity checks: validate NOT NULL constraints, foreign keys, and race-condition risks in uniqueness.
  • Transaction and auditing: verify atomic operations, proper isolation, and audit trails for data access.
  • Privacy governance: identify PII, encryption needs, retention policies, and GDPR/CCPA compliance.

Quick Start

Run the data-integrity-guardian to review your latest migration patch for safety, data constraints, and privacy compliance before deployment.

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 migrations for data loss and rollback safety?▼

Database migration safety is verified by analyzing reversibility, validating rollback procedures, and enforcing transactional boundaries. This prevents data loss and ensures schema updates maintain referential integrity before production deployment.

What is referential integrity and how does it apply to schema updates?▼

Referential integrity maintains consistent relationships between database tables during schema updates by validating foreign keys and NOT NULL constraints. This prevents orphaned records and upholds data model accuracy in production environments.

How do I ensure GDPR and CCPA compliance during ETL pipelines?▼

Ensure GDPR and CCPA compliance during ETL pipelines by identifying personally identifiable information, verifying encryption requirements, and enforcing data retention policies. This validates privacy governance throughout the data manipulation process.

Does this data governance approach work for production database audits?▼

Yes, data governance audits work for production databases by verifying atomic operations, proper transaction isolation, and audit trails for data access. This ensures regulatory compliance and referential integrity in live production environments.

What are the limitations of idempotent migration guidance?▼

Idempotent migration guidance analyzes data models and manipulation code to recommend safe rollback procedures and constraint validation. It does not automatically execute schema changes, requiring developers to manually implement the suggested transactional boundaries.

Related Skills

Explore More Data & Analytics Skills→
zhangzhang-111-izhangzhang-111-i
2

database-designer

Analyzes SQL/JSON schemas and generates optimized migration scripts.

Community
Advanced
AI-Foundry-CoreAI-Foundry-Core
4

database-migration

Execute database migrations across ORMs with rollback-safe procedures.

Official
Advanced
danieldev24danieldev24

ci-cd-and-automation

Automates CI/CD pipeline setup and quality gates for code verification.

Community
Advanced
harivansh-afkharivansh-afk
3

axiom-database-migration

Plan additive SQLite, GRDB, and SwiftData migrations.

Community
Advanced