masterdata-validator

Validate master data CSV files by comparing them against a schema JSON definition. This Skill checks column types, NOT NULL constraints, ENUM values, and PRIMARY KEY integrity, then outputs a corrected CSV, Markdown validation report, and detailed logs for audit purposes.

Yes, the Skill automatically repairs and reconciles CSV files by filling missing columns, normalizing data types, and applying schema constraints. It outputs both the corrected CSV and a detailed log of all modifications made.

Schema validation enforces ENUM constraints to match allowed values, NOT NULL constraints to flag missing required data, and PRIMARY KEY constraints to ensure uniqueness. All violations are logged and can trigger automated corrections.

Run the validation script before deploying master data to production. The Skill generates a Markdown report and corrected CSV, enabling automated quality gates that block invalid data from reaching downstream systems.

The Skill outputs three artifacts: a corrected CSV file with auto-fixes applied, a Markdown validation report documenting all changes, and detailed logs for audit and maintenance tracking.