What database types does this skill support?

While it works with general SQL and NoSQL patterns, it is particularly effective at reviewing TypeScript/Node.js database interactions and migration scripts.

How does the Data Integrity Guardian identify race conditions?

It analyzes code patterns for 'check-then-act' logic and suggests atomic operations or appropriate isolation levels to prevent concurrent data corruption.

Can it help with soft delete logic?

Yes, it specifically checks if soft deletes break referential integrity or leave orphaned child records in related tables.

What are P1 severity issues in its reports?

P1 issues are critical risks that could lead to immediate data corruption, such as missing foreign keys or transactions split across multiple operations.

Data Integrity Guardian

Name: Data Integrity Guardian
Author: jovermier

byjovermier

0•

データベース管理

Ensures database reliability by validating referential integrity, transaction boundaries, and data safety in code migrations and models.

Data Integrity Guardian is a specialized Claude Code skill designed to protect your persistent data from corruption and inconsistency. It acts as an automated database auditor, analyzing code migrations, schemas, and data-manipulation logic to identify critical risks like missing foreign keys, partial transaction commits, and race conditions. By providing structured feedback and implementation patterns, it helps developers maintain high data quality and prevents common database-level failures before they reach production.

主な機能

010 GitHub stars

02Analyzes transaction boundaries to ensure atomic operations

03Identifies potential race conditions in concurrent data operations

04Validates referential integrity and foreign key constraints

05Provides structured P1-P3 severity reports with code fixes

06Enforces strict data validation and schema-level constraints

ユースケース

01Reviewing complex database migrations for potential data loss or orphaned records

02Hardening application code against race conditions in high-concurrency environments

03Auditing financial transaction logic to ensure atomicity and consistency

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jovermier/claude-code-plugins-ip-labs data-integrity-guardian

For use in Claude.ai and ChatGPT

Download Skill