Skip to main content
subagent CX Codex

flyway-expert — Claude Code subagent: Flyway migrations

flyway-expert — a subagent that handles Flyway database migrations: versioning scripts, checking them before production, keeping a rollback plan ready. Useful once migrations pile up.

MIT ★ 1,029 updated 2025-10-15

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/agents/flyway-expert.md
Open on GitHub

What flyway-expert does

The agent covers schema versioning in Flyway: writing and ordering migration scripts, tracking upgrade paths between Flyway versions, and keeping changes straight across several environments. Flyway configuration and CI/CD wiring get the same attention.

What's inside is a set of working rules, not code. Migrations should be idempotent and reversible, each one is tested in staging before it touches production, a backup comes first, and filenames follow one convention. The agent also wants auditing and logging switched on, with migration docs kept current.

Expect pushback on sloppy scripts. Anything one-way or unvalidated gets rewritten, since idempotency and rollback sit at the core of its approach. Output: migration scripts, a Flyway config file, documentation and a recovery guide.

What it helps with

  • version Flyway migrations with clear filenames
  • check that scripts are idempotent and reversible
  • write a rollback plan before a schema release
  • wire migrations into a CI/CD pipeline
  • spread schema changes across several environments

Example prompts for the agent

  • Check the Flyway migrations here and tell me which scripts break on a second run.
  • Write a rollback plan for the latest migration, step by step.
  • Set up the Flyway config with placeholders for staging and production.

How to install flyway-expert

Manually: put the files in place

.claude/agents/flyway-expert.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean

Questions about flyway-expert

How do I install flyway-expert in Claude Code?

Copy the agent file to .claude/agents/flyway-expert.md in your project root, where Claude picks it up.

What does flyway-expert do?

It helps run database migrations through Flyway: script versioning, version compatibility, schema across environments, rollback and CI/CD integration.

What does it check migrations against?

Idempotency and reversibility for every migration, validation before production, a backup ahead of the run, and one naming convention for scripts.

Source text

flyway-expert.md · MIT
---
name: flyway-expert
description: Master Flyway for database migrations, versioning, and schema management. Optimizes migration scripts, ensures version compatibility, and improves deployment processes.
model: claude-sonnet-4-20250514
---

## Focus Areas

- Database version control using Flyway
- Writing and organizing migration scripts
- Version compatibility and upgrade paths
- Handling large-scale database migrations
- Automating migration processes
- Database schema management with Flyway
- Managing multiple database environments
- Rollback strategies and recovery plans
- Integration with CI/CD pipelines
- Flyway configuration and settings optimization

## Approach

- Start with a clear database versioning strategy
- Organize migration scripts in a consistent manner
- Ensure all migrations are idempotent and reversible
- Validate migrations before applying them to production
- Monitor database changes and migration statuses
- Automate migrations in deployment workflows
- Use Flyway's placeholders and configurations effectively
- Test migrations thoroughly in a staging environment
- Rollback carefully and prepare recovery strategies
- Keep Flyway and database documentation up-to-date

## Quality Checklist

- All migrations are tested and validated
- Scripts are organized and versioned correctly
- Migration processes are automated and repeatable
- Comprehensive rollback procedures are in place
- Consistent naming conventions for scripts
- Regular backups are taken before migrations
- Placeholders and configurations are used correctly
- Migrations are optimized for performance
- Auditing and logging for migrations are enabled
- Documentation for migrations is current and accurate

## Output

- A series of well-structured migration scripts
- Automated migration deployment process
- Detailed Flyway configuration file
- Documentation covering all migration steps
- A rollback and recovery guide
- Reports on migration status and performance
- Version control repository for migration scripts
- Integration setup for CI/CD pipeline
- A testing framework for migration validation
- Recommendations for optimizing Flyway usage

© 0xfurai · MIT · 0xfurai/claude-code-subagents

Similar subagents

All subagents for DevOps and infrastructure →
055-design-parallel-change Juan Antonio Breña Moral The 055-design-parallel-change skill guides you through designing safe database schema changes when old and new application versions must run simultaneously. It breaks complex migrations into three separately deployable phases. CX Codex +1 172installs 313-frameworks-spring-db-migrations-flyway Juan Antonio Breña Moral 313-frameworks-spring-db-migrations-flyway — a skill for adding and reviewing Flyway migrations in Spring Boot: Maven dependencies, db/migration scripts, spring.flyway.* settings and migration ordering. CX Codex +1 389installs migration JuliusBrussee migration enforces reversible, compatibility-safe transitions for schema, data, and API updates. Useful whenever data loss or rollout downtime is unacceptable. CX Codex +1 127,700installs convex-migrate-rehearse convex convex-migrate-rehearse is a Claude Code skill that rehearses schema changes and data backfills on a production snapshot in preview, then applies the verified process to production. CX Codex +1 43,800installs database-patterns c0x12c database-patterns hands your agent a fixed set of database rules: column types, UUID keys, soft deletes and migration templates. Useful when it writes tables or repositories. CX Codex +1 ★ 111repo stars dms-schema-conversion aws This Claude Code skill manages schema migrations between different database engines with AWS DMS Schema Conversion. It handles project setup, compatibility checks, and schema or SQL conversion. CX Codex +1 5,500installs

From the same set137

The whole set →
stripe-expert stripe-expert is a Claude Code subagent for building Stripe API integrations, processing payments, and managing subscriptions. It handles tasks involving billing, webhooks, and payment workflows. CX Codex ★ 1,029repo stars fiber-expert fiber-expert — a Claude subagent for fiber work: natural and synthetic types, manufacturing, textile uses and market trends. Built for industry questions rather than code. CX Codex ★ 1,029repo stars opentelemetry-expert opentelemetry-expert configures OpenTelemetry tracing, metrics, and logs while handling context propagation and sampling strategies. CX Codex ★ 1,029repo stars liquibase-expert The liquibase-expert subagent helps manage Liquibase schema changes, validate changeSets, and prepare rollbacks. Use it when working on database migrations. CX Codex ★ 1,029repo stars html-expert html-expert — a subagent that builds semantic, accessible markup aligned with WCAG rules. It cleans up document structure, meta tags, and form elements. CX Codex ★ 1,029repo stars actix-expert actix-expert — a Claude Code subagent for Actix and Rust web work, covering routes, middleware, errors, tests, and performance checks. CX Codex ★ 1,029repo stars elixir-expert elixir-expert — an Elixir-focused subagent for Claude: pattern matching, supervision trees, GenServers, Phoenix channels and ExUnit tests, with Dialyzer in the checklist. CX Codex ★ 1,029repo stars grafana-expert grafana-expert designs Grafana dashboards, configures alert rules, and optimizes queries for metrics backends. CX Codex ★ 1,029repo stars

Project sponsors

Companies that keep this analytics open