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

数据库管理

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.

主要功能

0 GitHub stars
Analyzes transaction boundaries to ensure atomic operations
Identifies potential race conditions in concurrent data operations
Validates referential integrity and foreign key constraints
Provides structured P1-P3 severity reports with code fixes
Enforces strict data validation and schema-level constraints

使用场景

Reviewing complex database migrations for potential data loss or orphaned records
Hardening application code against race conditions in high-concurrency environments
Auditing financial transaction logic to ensure atomicity and consistency

关于

主要功能

0 GitHub stars
Analyzes transaction boundaries to ensure atomic operations
Identifies potential race conditions in concurrent data operations
Validates referential integrity and foreign key constraints
Provides structured P1-P3 severity reports with code fixes
Enforces strict data validation and schema-level constraints

使用场景

Reviewing complex database migrations for potential data loss or orphaned records
Hardening application code against race conditions in high-concurrency environments
Auditing financial transaction logic to ensure atomicity and consistency