Does this skill work with existing data that might be messy?

Yes. The skill includes a specific workflow to scan existing datasets, generate violation reports, and create cleanup scripts before you apply any new constraints.

How does it handle potential performance impacts of constraints?

The skill includes instructions for performance analysis using EXPLAIN ANALYZE and suggests appropriate indexing to support constraint validation overhead.

Which database systems are supported?

The skill provides specialized patterns and documentation for PostgreSQL, MySQL, and SQL Server.

Can it handle validation beyond simple data types?

Absolutely. It supports range checks, regex-based format validation, referential integrity (foreign keys), and complex business rules via triggers.

Database Integrity & Data Validation

Name: Database Integrity & Data Validation
Author: jeremylongshore

byjeremylongshore

•

897

データベース管理

Ensures database reliability by implementing comprehensive data validation rules, integrity constraints, and automated cleanup scripts.

概要

The Database Integrity & Data Validation skill automates the critical process of hardening database schemas to prevent data corruption and ensure business rule compliance. It systematically analyzes your existing schema, identifies validation gaps, and generates robust SQL constraints including CHECK, FOREIGN KEY, and NOT NULL definitions. Beyond simple type checking, it handles complex format validation via regex and provides a structured workflow for identifying and cleaning legacy data that violates new rules, ensuring a safe transition to stricter data integrity standards.

主な機能

Automated generation of SQL constraints (CHECK, FK, NOT NULL)
897 GitHub stars
Automated data cleanup script generation (UPDATE/DELETE)
Cross-platform support for PostgreSQL, MySQL, and SQL Server
Comprehensive data violation reporting for existing records
Support for complex business logic via database triggers

ユースケース

Implementing automated format validation for fields like emails and phone numbers
Hardening production schemas with stricter data validation rules
Auditing and cleaning legacy data inconsistencies before migrations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills validating-database-integrity

For use in Claude.ai and ChatGPT

Download Skill

GitHub

概要