database-migration-standard

What problem does it solve?

Implement production-grade Sequelize migrations with Neon PostgreSQL, multi-environment support, zero-downtime migrations, seeding strategies, and rollback procedures. This Skill provides structured patterns and best practices to reliably evolve database schemas across environments while preserving data integrity and minimizing downtime.

Core Features & Use Cases

• Transactional migrations: All migrations run inside transactions with explicit up() and down() stanzas to guarantee atomicity.
• Zero-downtime changes: Employ safe patterns like adding nullable columns, creating new structures, and then swapping to avoid downtime.
• Multi-environment support: Provides scripts and configuration for local, develop, and production deployments with consistent workflows and rollback strategies.
• Seed data and versioning: Includes seeders with fixed IDs and versioned migrations to maintain consistent environments.

Quick Start

Start by bootstrapping your local environment with the standard migration workflow to create and migrate the initial schema.