data-integrity-auditor
CommunityEnsure data accuracy and fix issues.
Authorzinohome
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill automatically detects and helps fix critical data integrity issues within your database, preventing data corruption and ensuring reliable information.
Core Features & Use Cases
- Orphaned Record Detection: Identifies records that reference non-existent parent records (e.g., orders without users).
- Broken Foreign Key Checks: Finds instances where relationships between tables are violated.
- Constraint Violation Audits: Detects issues like duplicate unique fields or invalid data ranges (e.g., negative prices).
- Missing Field Identification: Flags records that lack essential data.
- Automated Fix Scripts: Provides scripts to resolve common integrity problems.
- Prevention Guidance: Offers SQL examples for adding database constraints to prevent future issues.
- Use Case: Run a comprehensive audit to find all orders with invalid user IDs, products with negative prices, and duplicate email addresses, then use the provided scripts to clean them up.
Quick Start
Run the data integrity audit script to check for and report on any data inconsistencies.
Dependency Matrix
Required Modules
prisma
Components
scriptsreferences
💻 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: data-integrity-auditor Download link: https://github.com/zinohome/CozyChat/archive/main.zip#data-integrity-auditor 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 223,000+ vetted skills library on demand.