code-check-data-integrity
CommunitySafeguard migrations, deletes, and persisted state.
Software Engineering#data integrity#migration safety#schema backfill#orphan rows#delete cascade#uniqueness constraints#seed drift
Authorwebdevcody
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill prevents production data breakage by auditing whether schema, migration, persistence, imports, deletes, or background jobs preserve existing rows, constraints, and related child data.
Core Features & Use Cases
- NOT NULL & backfill safety checks: Detects new NOT NULL columns added without defaults or backfill steps that would fail on existing data.
- Orphan and cascade risk analysis: Flags deletes/destroys/removals that can leave orphaned child rows or external side effects (files, cache, webhook subscriptions).
- Uniqueness enforcement review: Finds cases where code assumes uniqueness but the database schema does not enforce it.
- Seed/fixture drift detection: Compares fixtures against the updated schema to catch missing/removed required fields.
- Destructive migration warnings: Highlights irreversible operations like DROP COLUMN/TABLE/TRUNCATE to prompt backup and rollback planning.
Quick Start
Run the code-check-data-integrity scan after you modify a migration, schema, delete/destroy logic, or background job that affects persisted state.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: code-check-data-integrity Download link: https://github.com/webdevcody/go-mailing-list/archive/main.zip#code-check-data-integrity Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.