skills.rest
udecode
udecodeOFFICIAL
Explore all skills by this author →
WebsiteGitHub

data-integrity-guardian

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

240|75|Updated Jul 13, 2023
Search Tags:#database migration#data integrity#transaction management#data governance#referential integrity#privacy compliance
One-click install
npx skills add https://github.com/udecode/plate-playground-template --skill data-integrity-guardian-udecode
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-integrity-guardian
Source: https://github.com/udecode/plate-playground-template/tree/main/.codex/skills/data-integrity-guardian
Command: npx skills add https://github.com/udecode/plate-playground-template --skill data-integrity-guardian-udecode

SYSTEM DOCUMENTATION & REQUIREMENTS

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

  • Database Migration Review: Analyzes migrations for safety, reversibility, and potential data loss.
  • Data Constraint Validation: Verifies the presence and correctness of data validations and constraints.
  • Transaction Boundary Assessment: Reviews transaction scopes for atomicity, isolation, and deadlock prevention.
  • Referential Integrity Checks: Ensures foreign key relationships and cascade behaviors are handled correctly.
  • Privacy Compliance: Identifies PII and checks for adherence to data privacy regulations.
  • Use Case: Before deploying a new database schema change, use this Skill to review the migration script for any potential issues that could lead to data corruption or downtime.

Quick Start

Use the data-integrity-guardian skill to review the attached database migration script for safety concerns.

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?▼

To check database migration scripts for data loss, review them for safety, reversibility, and potential data corruption risks before deployment to ensure data integrity and prevent downtime.

What are transaction boundaries and how do I prevent deadlocks in persistent data code?▼

Transaction boundaries define the scope of database operations for atomicity and isolation. Reviewing transaction scopes helps ensure deadlock prevention and maintains ACID properties in persistent data code.

How do I verify referential integrity and cascade behaviors in a relational data model?▼

Verifying referential integrity involves checking foreign key relationships and cascade behaviors in your data model to ensure they are handled correctly and maintain database consistency.

How do I identify PII and check data privacy compliance in database schemas?▼

Identify PII and check data privacy compliance by reviewing database schemas and persistent data code for adherence to data privacy regulations, ensuring sensitive information is properly governed.

Does this approach work for validating data constraints in production database management?▼

Yes, validating data constraints is suitable for production database management. It verifies the presence and correctness of data validations to ensure the safety and consistency of production data.

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
CristoVenturesCristoVentures
2

data-integrity-guardian

Analyze database migrations and data models for integrity and compliance.

Official
Advanced
pohlai88pohlai88

database-testing

Validate database schemas, data integrity, migrations, and ACID properties.

Community
Advanced
AvihusittonAvihusitton

logic-lens

Detect logic flaws, race conditions, and security risks in code reviews.

Community
Intermediate