Flyway Migrations

Use this skill when creating or reviewing Flyway database migrations in a Spring Boot project. Covers schema evolution, data migrations, zero-downtime strategies, and PostgreSQL best practices.

5 stars 1 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add senoritadeveloper01/claude-skills --skill flyway-migrations
Manual install
git clone --depth 1 https://github.com/senoritadeveloper01/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/.claude/skills/flyway-migrations ~/.claude/skills/flyway-migrations

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Flyway Migrations

## Scope
Apply this skill when working on:
- Flyway migration scripts (`V1__`, `V2__`, etc.)
- schema evolution (DDL)
- data migrations (DML)
- production database changes
- PostgreSQL schema design

---

## Core Principles

- Every database change must be implemented via a migration — never modify production databases manually
- Migrations are **forward-only** — never edit applied migrations
- Separate **schema (DDL)** and **data (DML)** migrations
- Migrations must be **immutable once applied**
- Always test migrations on production-like data

---

## Flyway Naming & Structure

- Use versioned scripts:
    - `V1__init.sql`
    - `V2__add_user_table.sql`
- Use clear, descriptive names
- Keep each migration small and focused
- Avoid combining multiple concerns in one migration

---

## Migration Safety Rules

Before applying a migration:

- No full table locks on large tables
- New columns must be:
    - nullable OR
    - have default values
- Indexes must be created safely (see below)
- Large updates must be batched
- Rollback strategy must be known (even if forward-only)

---

## PostgreSQL Safe Patterns

### Adding Columns

```sql
-- SAFE
ALTER TABLE users ADD COLUMN avatar_url TEXT;

-- SAFE (Postgres 11+)
ALTER TABLE users ADD COLUMN is_active BOOLEAN NOT NULL DEFAULT true;

-- UNSAFE
ALTER TABLE users ADD COLUMN role TEXT NOT NULL;
Read the full skill on GitHub

Details

Skill name
flyway-migrations
Path
.claude/skills/flyway-migrations/SKILL.md
Repo updated
24 March 2026

FAQ

What does the Flyway Migrations skill do?

Use this skill when creating or reviewing Flyway database migrations in a Spring Boot project. Covers schema evolution, data migrations, zero-downtime strategies, and PostgreSQL best practices.

How do I install the Flyway Migrations skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add senoritadeveloper01/claude-skills --skill flyway-migrations. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Flyway Migrations popular?

It lives in senoritadeveloper01/claude-skills, which has 5 GitHub stars and 1 forks.

Related skills

Java Best Practices

5

senoritadeveloper01/claude-skills

Use this skill when generating or reviewing Java code to ensure readability, maintainability, correctness, and modern best practices.

Software Development

Persistence Jpa

5

senoritadeveloper01/claude-skills

Use this skill when working with JPA entities, repositories, and persistence logic in a Spring Boot project. Combines domain-driven persistence design with Java correctness, performance awareness, and testability.

Software Development

Spring Boot Core

5

senoritadeveloper01/claude-skills

Use this skill when creating or updating Spring Boot application code in this repository, including REST controllers, services, DTOs, validation, exception handling, configuration, and general project structure.

Software Development

Wp Migrate

9

morrealev/wordpress-manager

This skill should be used when the user asks to "migrate a site", "move WordPress", "transfer my site", "clone site", "copy site to new hosting", or mentions any WordPress migration between hosts or platforms. Covers full site, content-only, and database migrations.

Databases

SQL Reviewer

9

shisuidata/ss-data-skills

Use when reviewing SQL for data development. Checks logic correctness, metric consistency, joins, aggregations, deduplication, null handling, date boundaries, partition filters, performance risks, engine-specific issues, and safer rewrite suggestions. 中文触发词:SQL 审查、SQL Review、SQL 算错、慢 SQL。

Databases

Writing SQL

9

borkweb/skills

Apply the project’s vertical SQL formatting when authoring or reviewing actual SQL, including migrations and embedded queries. No exception for short queries; generic database discussion does not activate it.

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.