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.
Install
npx skills add senoritadeveloper01/claude-skills --skill flyway-migrationsgit 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-migrationsPersonal 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;Details
- Skill name
flyway-migrations- Repository
- senoritadeveloper01/claude-skills
- 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
5senoritadeveloper01/claude-skills
Use this skill when generating or reviewing Java code to ensure readability, maintainability, correctness, and modern best practices.
Persistence Jpa
5senoritadeveloper01/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.
Spring Boot Core
5senoritadeveloper01/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.
Wp Migrate
9morrealev/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.
SQL Reviewer
9shisuidata/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。
Writing SQL
9borkweb/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.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.