database-schema-validator

What problem does it solve?

Manual database schema validation is error-prone and time-consuming, leading to data inconsistencies, migration failures, and production bugs. This skill automates the rigorous checking of your database schema, Kysely types, and migrations, preventing costly errors before they happen.

Core Features & Use Cases

• Schema Type Validation: Automatically verify Kysely schema type definitions, column consistency, and foreign key relationships.
• Migration Safety Analysis: Detect unsafe migrations (e.g., data loss risks), validate file structure, and ensure rollback compatibility.
• Best Practices Enforcement: Check for proper indexing, primary key definitions, and naming convention compliance.
• Use Case: Before deploying a new feature, use this skill to automatically scan your entire database setup. It will flag any type mismatches, missing foreign keys, or potentially destructive migrations, allowing you to fix them proactively and avoid production outages.

Quick Start

Validate the database schema and all pending migrations for the current project.