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 best practices and naming conventions.

Core Features & Use Cases

• Schema Auditing: Checks for naming convention violations, type inconsistencies, improper nullability, and missing constraints.
• Violation Reporting: Generates a detailed report of all identified issues with severity levels (error, warning, info).
• Fix Recommendations: Provides specific SQL or code-based recommendations for resolving each violation.
• Auto-fix Migrations: Generates SQL migration scripts to automatically apply common fixes.
• Use Case: Ensure all new database tables and columns adhere to the company's established naming standards and data integrity rules before they are deployed to production.

Quick Start

Run the schema consistency checker to audit the current database schema and generate a report of violations.