database-schema-migrations

What problem does it solve?

Designing robust PostgreSQL schemas, generating deterministic Sequelize migrations, and implementing well-structured models and associations is error-prone and time-consuming. This Skill provides a structured approach to manage schema changes, enforce naming conventions, and keep migrations, seeds, and models in sync across teams.

Core Features & Use Cases

• Schema design guidance: best practices for tables, types, constraints, indexing, and naming conventions.
• Migration workflows: creating, applying, testing, and rolling back migrations using Sequelize CLI.
• Model & association patterns: standard approaches for hasMany, belongsTo, and many-to-many with join tables.
• Use Case: when adding a new feature requiring new tables and foreign keys, scaffold migrations and models consistently.

Quick Start

Run the generator script to scaffold a new model and its migration, then apply the migration to update the database.