Schema Migration Planner
Plan safe database schema evolution and zero-downtime change rollout for Kotlin plus Spring systems using Flyway, Liquibase, or equivalent migration tooling. Use when changing tables, columns, constraints, indexes, or data shape in systems with live traffic, rolling deploys, large datasets, or backward-compatibility requirements between old and new application versions.
Install
npx skills add JetBrains/skills --skill schema-migration-plannergit clone --depth 1 https://github.com/JetBrains/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/schema-migration-planner ~/.claude/skills/schema-migration-plannerPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Schema Migration Planner Source mapping: Tier 3 specialized skill derived from `Kotlin_Spring_Developer_Pipeline.md` (`SK-11`). ## Mission Change schema without breaking live traffic, deployment order, or rollback safety. Treat schema evolution as a multi-step compatibility exercise, not a single DDL statement. ## Read First - Current schema and the desired target shape. - Current code path, target code path, and deployment model. - Table sizes, traffic pattern, lock sensitivity, and replication or CDC constraints. - The actual migration tool and dialect in use. - Backfill capability, rollout windows, and rollback expectations. ## Planning Workflow 1. Identify whether the change is additive, destructive, semantic, or data-moving. 2. Determine whether old and new application versions must coexist. 3. Plan the rollout in phases: - expand - dual write or compatibility layer - backfill - switch reads - contract 4. Decide whether rollback is realistic or whether roll-forward is the safer operational model. 5. Define smoke checks, validation queries, and observability around the migration. ## Core Migration Rules - Add before remove. - Make old code tolerate new schema before making new code require it. - Backfill separately from latency-sensitive request paths whenever possible. - Use explicit indexes and constraints as part of the migration design, not as an afterthought.
Details
- Skill name
schema-migration-planner- Repository
- JetBrains/skills
- Path
schema-migration-planner/SKILL.md- Repo updated
- 21 October 2026
FAQ
What does the Schema Migration Planner skill do?
Plan safe database schema evolution and zero-downtime change rollout for Kotlin plus Spring systems using Flyway, Liquibase, or equivalent migration tooling. Use when changing tables, columns, constraints, indexes, or data shape in systems with live traffic, rolling deploys, large datasets, or backward-compatibility requirements between old and new application versions.
How do I install the Schema Migration Planner skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add JetBrains/skills --skill schema-migration-planner. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Schema Migration Planner popular?
It lives in JetBrains/skills, which has 398 GitHub stars and 35 forks.
Related skills
Deploy to Vercel
398JetBrains/skills
Deploy applications and websites to Vercel. Use when the user requests deployment actions like "deploy my app", "deploy and give me the link", "push this live", or "create a preview deployment".
Vercel React Native Skills
398JetBrains/skills
React Native and Expo best practices for building performant mobile apps. Use when building React Native components, optimizing list performance, implementing animations, or working with native modules. Triggers on tasks involving React Native, Expo, mobile performance, or native platform APIs.
Vitest
398JetBrains/skills
Vitest fast unit testing framework powered by Vite with Jest-compatible API. Use when writing tests, mocking, configuring coverage, or working with test filtering and fixtures.
Supabase Postgres Best Practices
398JetBrains/skills
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Performance Concurrency Advisor
398JetBrains/skills
Analyze and improve performance, throughput, latency, and concurrency behavior in Kotlin plus Spring services using real evidence from metrics, traces, SQL, thread or heap signals, and code paths. Use when endpoints are slow, pools saturate, coroutines or reactive flows block unexpectedly, N+1 or contention appears, or caching and parallelism decisions need precise, non-generic guidance.
Transaction Consistency Designer
398JetBrains/skills
Design safe transaction boundaries, rollback behavior, idempotency, locking, and consistency strategies for Kotlin + Spring business workflows. Use when a feature writes to the database, spans multiple repositories, publishes messages, calls external systems, suffers from partial commits or duplicate processing, or needs precise `@Transactional`, propagation, or isolation guidance.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.