validating-database-integrity

## Overview This skill empowers Claude to implement comprehensive data validation at both the database and application levels, ensuring data integrity and adherence to defined rules. It leverages the data-validation-engine plugin to automate the process of defining and enforcing validation rules. ## How It Works 1. **Rule Definition**: Claude analyzes the request and identifies the specific data validation requirements (e.g., data types, ranges, formats). 2. **Validation Implementation**: Claude uses the data-validation-engine plugin to generate and apply the necessary validation rules to the database schema or application logic. 3. **Verification**: Claude confirms the successful implementation of the validation rules and reports any errors or conflicts. ## When to Use This Skill This skill activates when you need to: - Implement data validation for a new database schema. - Enforce data integrity constraints on existing database tables. - Validate data input within an application to prevent invalid data from being stored. ## Examples ### Example 1: Implementing Data Type Validation User request: "Implement data validation to ensure the 'age' column in the 'users' table is an integer." The skill will: 1. Use the data-validation-engine plugin to add a constraint to the 'users' table, enforcing that the 'age' column must contain integer values. 2. Verify that the constraint is active and prevents non-integer values from being inserted into the 'age' column. ### Exampl...