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.

主要功能

01Safe PostgreSQL DDL patterns for zero-downtime schema modifications

02Performance-optimized indexing using CONCURRENTLY to prevent table locking

03Idempotent PL/pgSQL scripts for resilient migration execution

04Standardized Flyway naming conventions for versioned and undo migrations

051 GitHub stars

06Batch data migration patterns for handling large datasets efficiently

使用场景

01Scaling database schemas in production without manual intervention or downtime

02Synchronizing database structures across multi-developer teams and environments

03Automating complex data normalization tasks during application upgrades

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ashchupliak/dream-team flyway-migrations

For use in Claude.ai and ChatGPT

Download Skill