What is the recommended Flyway naming convention?

The skill follows the V{version}__{description}.sql pattern, using double underscores and padded numbers (e.g., V001__init.sql) for consistent sorting and clarity.

How can I add indexes to large tables without locking them?

Use the CREATE INDEX CONCURRENTLY command. Note that this requires setting flyway.postgresql.transactional.lock=false in your Flyway configuration as it cannot run within a standard transaction.

How do I safely add a NOT NULL column to an existing table?

The recommended pattern is to first add the column with a default value for existing rows, or update nulls manually, before applying the NOT NULL constraint to avoid migration failures.

Does this skill support undoing migrations?

Yes, it provides patterns for 'U' (Undo) scripts, which are used by Flyway Teams and Enterprise editions to roll back specific schema changes.

Flyway Database Migrations

Name: Flyway Database Migrations
Author: ashchupliak

byashchupliak

•

データベース管理

Manages database schema changes and versioning through standardized Flyway migration patterns and PostgreSQL best practices.

概要

This skill provides a comprehensive framework for managing PostgreSQL database migrations using Flyway. It establishes strict naming conventions, safe DDL patterns for adding or dropping columns, and advanced techniques like idempotent scripts and concurrent indexing to avoid table locks. Whether you are initializing a new schema, performing data normalization, or configuring Gradle-based migration workflows, this skill ensures your database evolution is versioned, reproducible, and production-safe.

主な機能

Safe PostgreSQL DDL patterns for zero-downtime schema modifications
Performance-optimized indexing using CONCURRENTLY to prevent table locking
Idempotent PL/pgSQL scripts for resilient migration execution
Standardized Flyway naming conventions for versioned and undo migrations
1 GitHub stars
Batch data migration patterns for handling large datasets efficiently

ユースケース

Scaling database schemas in production without manual intervention or downtime
Synchronizing database structures across multi-developer teams and environments
Automating complex data normalization tasks during application upgrades

概要

主な機能

Safe PostgreSQL DDL patterns for zero-downtime schema modifications
Performance-optimized indexing using CONCURRENTLY to prevent table locking
Idempotent PL/pgSQL scripts for resilient migration execution
Standardized Flyway naming conventions for versioned and undo migrations
1 GitHub stars
Batch data migration patterns for handling large datasets efficiently

ユースケース

Scaling database schemas in production without manual intervention or downtime
Synchronizing database structures across multi-developer teams and environments
Automating complex data normalization tasks during application upgrades