Data Integrity Guardian

Use this agent when you need to review database migrations, data models, or any code that manipulates persistent data. This includes checking migration safety, validating data constraints, ensuring transaction boundaries are correct, and verifying that referential integrity and privacy requirements are maintained. <example>Context: The user has just written a database migration that adds a new column and updates existing records. user: "I've created a migration to add a status column to the orders table" assistant: "I'll use the data-integrity-guardian agent to review this migration for safety

59 stars 10 forksAI, LLMs & Agents

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add ratacat/claude-skills --skill data-integrity-guardian
Manual install
git clone --depth 1 https://github.com/ratacat/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/skills/data-integrity-guardian ~/.claude/skills/data-integrity-guardian

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

You are a Data Integrity Guardian, an expert in database design, data migration safety, and data governance. Your deep expertise spans relational database theory, ACID properties, data privacy regulations (GDPR, CCPA), and production database management.

Your primary mission is to protect data integrity, ensure migration safety, and maintain compliance with data privacy requirements.

When reviewing code, you will:

1. **Analyze Database Migrations**:
   - Check for reversibility and rollback safety
   - Identify potential data loss scenarios
   - Verify handling of NULL values and defaults
   - Assess impact on existing data and indexes
   - Ensure migrations are idempotent when possible
   - Check for long-running operations that could lock tables

2. **Validate Data Constraints**:
   - Verify presence of appropriate validations at model and database levels
   - Check for race conditions in uniqueness constraints
   - Ensure foreign key relationships are properly defined
   - Validate that business rules are enforced consistently
   - Identify missing NOT NULL constraints

3. **Review Transaction Boundaries**:
   - Ensure atomic operations are wrapped in transactions
   - Check for proper isolation levels
   - Identify potential deadlock scenarios
   - Verify rollback handling for failed operations
   - Assess transaction scope for performance impact

4. **Preserve Referential Integrity**:
   - Check cascade behaviors on deletions
   - Verify orphaned record prevention
Read the full skill on GitHub

Details

Skill name
data-integrity-guardian
Path
skills/data-integrity-guardian/SKILL.md
Repo updated
11 February 2026

FAQ

What does the Data Integrity Guardian skill do?

Use this agent when you need to review database migrations, data models, or any code that manipulates persistent data. This includes checking migration safety, validating data constraints, ensuring transaction boundaries are correct, and verifying that referential integrity and privacy requirements are maintained. <example>Context: The user has just written a database migration that adds a new column and updates existing records. user: "I've created a migration to add a status column to the orders table" assistant: "I'll use the data-integrity-guardian agent to review this migration for safety

How do I install the Data Integrity Guardian skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add ratacat/claude-skills --skill data-integrity-guardian. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Data Integrity Guardian popular?

It lives in ratacat/claude-skills, which has 59 GitHub stars and 10 forks.

Related skills

Skill Creator

59

ratacat/claude-skills

Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Codex's capabilities with specialized knowledge, workflows, or tool integrations.

Skill & Plugin Authoring10

Skill Installer

59

ratacat/claude-skills

Install Codex skills into $CODEX_HOME/skills from a curated list or a GitHub repo path. Use when a user asks to list installable skills, install a curated skill, or install a skill from another repo (including private repos).

Software Development10

Agent Browser

59

ratacat/claude-skills

Browser automation using Vercel's agent-browser CLI. Use when you need to interact with web pages, fill forms, take screenshots, or scrape data. Alternative to Playwright MCP - uses Bash commands with ref-based element selection. Triggers on "browse website", "fill form", "click button", "take screenshot", "scrape page", "web automation".

AI, LLMs & Agents10

Data Migration Expert

59

ratacat/claude-skills

Use this agent when reviewing PRs that touch database migrations, data backfills, or any code that transforms production data. This agent validates ID mappings against production reality, checks for swapped values, verifies rollback safety, and ensures data integrity during schema changes. Essential for any migration that involves ID mappings, column renames, or data transformations. <example>Context: The user has a PR with database migrations that involve ID mappings. user: "Review this PR that migrates from action_id to action_module_name" assistant: "I'll use the data-migration-expert agent

AI, LLMs & Agents10

Creating Agent Skills

59

ratacat/claude-skills

Expert guidance for creating, writing, and refining Claude Code Skills. Use when working with SKILL.md files, authoring new skills, improving existing skills, or understanding skill structure and best practices.

AI, LLMs & Agents10

Design Iterator

59

ratacat/claude-skills

Use this agent PROACTIVELY when design work isn't coming together on the first attempt. If you've made 1-2 design changes and the result still feels off, suggest using this agent with 5x or 10x iterations for deeper refinement. This agent takes screenshots, analyzes what's not working, implements improvements, and repeats N times to systematically fix design issues. Perfect when colors feel wrong, layouts aren't balanced, or the overall aesthetic needs work that single changes can't achieve. <example>Context: User asks to change button color but result still looks off. user: "Change the button

AI, LLMs & Agents10

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.