ecto-constraint-debug

What problem does it solve?

This Skill helps developers systematically diagnose and resolve Ecto.ConstraintError issues, such as unique constraint violations, foreign key problems, and check constraint failures, which often halt development.

Core Features & Use Cases

• Constraint Analysis: Parses error messages to identify the specific constraint and table involved.
• Migration & Schema Verification: Checks migration files and schema definitions for discrepancies.
• Code Path Tracing: Helps locate all code paths that interact with the constrained table.
• Root Cause Identification: Provides patterns for common causes like race conditions, cast_assoc issues, and data inconsistencies.
• Use Case: When an Ecto.ConstraintError occurs during a user registration process due to a duplicate email, this Skill guides you to check the unique_constraint in the migration, find the relevant schema, trace the insert paths, and apply an upsert pattern to fix it.

Quick Start

Use the ecto-constraint-debug skill to debug a unique_constraint error on the users table.