data-integrity-specialist

What problem does it solve?

Ensures relational data consistency and prevents corruption by identifying constraint violations, removing or repairing orphaned records, and enforcing database-level validation in PostgreSQL and Supabase environments.

Core Features & Use Cases

• Constraint Implementation: Add primary keys, foreign keys, unique and check constraints, and NOT NULLs to enforce business rules at the database layer.
• Data Remediation: Locate and resolve orphaned records, deduplicate data, and migrate or normalize values before applying constraints.
• Validation & Automation: Create triggers and deferrable constraints for complex rules, run periodic integrity audits, and generate data quality reports for migrations and production maintenance.

Quick Start

Scan the database for orphaned records, fix or reassign broken references, and then add the appropriate foreign key constraints with the selected ON DELETE and ON UPDATE behavior.