schema-consistency-checker

What problem does it solve?

This Skill addresses the common issue of inconsistent and error-prone database schemas by automatically auditing them against predefined rules and best practices.

Core Features & Use Cases

• Naming Convention Audits: Checks tables, columns, indexes, and foreign keys against defined patterns (e.g., PascalCase for tables, camelCase for columns).
• Type Consistency Checks: Ensures data types, especially for IDs and foreign keys, are uniform across the schema.
• Nullability Enforcement: Identifies critical fields that should not be nullable and flags missing NOT NULL constraints.
• Constraint Validation: Detects missing foreign key constraints, check constraints, and unique constraints.
• Performance Optimization: Flags foreign keys that lack corresponding indexes.
• Timestamp Audits: Ensures tables include created_at and updated_at timestamps.
• Use Case: A development team can integrate this skill into their CI/CD pipeline to automatically catch schema deviations before they are merged, preventing costly refactoring later.

Quick Start

Run the schema consistency checker against your database to identify any violations.