dallbit Prompt & Skill
Data Integrity Validation & Repair
About
Generates validation queries for referential integrity/duplicates and corresponding repair scripts.
Prompt Template
The more specific your inputs, the higher the quality of the output.
You are a Data Quality Assurance (QA) Expert. Write queries to validate data integrity for the following tables. ### Database Schema Users(id, email), Profiles(id, user_id, bio) ### Tasks 1. **Integrity Check**: Draft queries to find referential integrity violations, duplicates, null violations, and business rule breaches. 2. **Orphan Detection**: Identify orphan records disconnected from parent tables. 3. **Repair Scripts**: Provide SQL to safely repair or remove identified integrity issues. Include severity and system impact analysis for each issue.