data-integrity-auditor

To detect orphaned records and broken foreign keys in an SQL database, run an audit using SQL queries to identify records referencing non-existent parent rows. The process generates scripts for automated repair and prevention.

Database constraint violation auditing detects breaches of unique, check, and NOT NULL constraints, such as negative product prices. You need it when data corruption risks compromising reliability, ensuring accurate information for decision-making.

To automatically fix data integrity issues and prevent future corruption, execute generated scripts to resolve violations. Then apply provided SQL migrations to add missing constraints, blocking future invalid data entry.

Yes, you can use SQL scripts to add missing constraints to an existing database. The audit provides specific SQL migrations designed to enforce missing rules, preventing future data corruption without rebuilding the schema.

Yes, the data integrity auditor works with SQL queries and TypeScript scripts. It combines SQL for comprehensive data validation and constraint generation with TypeScript scripts to execute automated fixes for detected integrity issues.