Generates standardized Flyway SQL migrations optimized for DDD scaffolds without foreign key constraints.
The Flyway Migration Generator is a specialized skill designed to automate the creation of database migration scripts within Java Domain-Driven Design (DDD) projects. It strictly adheres to architectural patterns that favor application-level integrity over database-level foreign keys, ensuring cleaner domain boundaries and easier scaling. The skill automatically handles versioned naming, generates indexes for performance-critical status and time-based queries, and incorporates safe backfill plans when adding non-nullable columns to existing tables, making database evolution predictable and production-ready.
Key Features
01Enforcement of FK-less architectural rules for domain decoupling
02Integrated data backfill logic for new NOT NULL constraints
03Automated SQL migration generation with sequential versioning
04Automated check constraint generation for status enums and invariants
05Smart indexing for status-based and time-based query patterns
060 GitHub stars
Use Cases
01Adding mandatory columns to existing tables with automated data migration
02Expanding database schema for new domain entities in a Java microservice
03Optimizing infrastructure performance by adding missing claim-query indexes
