Detect and remediate orphaned database records in Laravel environments.
npx skills add https://github.com/edulazaro/laraclaude --skill lc-orphaned-records
Please help me install this Agent Skill. Skill: lc:orphaned-records Source: https://github.com/edulazaro/laraclaude/tree/main/skills/orphaned-records Command: npx skills add https://github.com/edulazaro/laraclaude --skill lc-orphaned-records
This skill solves the issue of data integrity in Laravel applications by identifying database records that reference non-existent parent records, which can cause application errors and inconsistent data states.
Run the lc:orphaned-records skill to analyze all database tables for orphaned records and report the findings.
High-intent search queries and answers about installing and using this skill.
Orphaned records in Laravel are found by parsing migration files and executing database queries via Docker to detect foreign keys referencing non-existent parents. The Skill validates data integrity by distinguishing between hard-deleted and soft-deleted parent records.
The best way to clean up orphaned data safely is by using soft-delete awareness to distinguish truly orphaned records from those pointing to soft-deleted parents. The Skill proposes deleting orphans, nullifying foreign keys, or generating cleanup migrations with mandatory user confirmation.
Yes, this orphaned records cleanup operates within Laravel environments by parsing existing migration files and executing database queries directly through Docker containers, requiring no additional external dependencies to validate data integrity.
To generate a cleanup migration for data integrity violations, the Skill analyzes foreign key constraints and proposes remediation actions. With mandatory user confirmation, it can automatically generate cleanup migrations to delete orphans or nullify foreign keys.
Before remediating foreign key violations, ensure you distinguish between hard-deleted and soft-deleted parent records to avoid breaking soft-deleted Laravel relationships. The Skill enforces mandatory user confirmation before executing any deletion, foreign key nullification, or cleanup migration actions.
edulazaroAutomate Laravel database migration testing and repair in Docker containers.
Camilo8902Audits and repairs database integrity issues like orphaned records and constraint violations.
cas-bigdatalabValidate foreign key values against a reference set to identify orphaned records.
edulazaroAnalyzes Laravel migrations and Eloquent models to detect foreign key discrepancies.
