---
title: "Schema Migration Planner: review, setup & limitations · Undominated.ai"
canonical: https://undominated.ai/skills/jetbrains-schema-migration-planner/
description: "Plans database schema changes as phased expand, dual-write, backfill, switch-read, contract sequences with explicit lock, replication and rollback-safety analysis, instead of a single DDL statement."
---

# Schema Migration Planner: review, setup & limitations · Undominated.ai

> Plans database schema changes as phased expand, dual-write, backfill, switch-read, contract sequences with explicit lock, replication and rollback-safety analysis, instead of a single DDL statement.

[← Explore all skills](/skills/)

DATABASES / JetBrains

# Schema Migration Planner

Plans database schema changes as phased expand, dual-write, backfill, switch-read, contract sequences with explicit lock, replication and rollback-safety analysis, instead of a single DDL statement.

 [See setup guidance ↓](#setup)[Original source ↗](https://github.com/JetBrains/skills/tree/e0f258b5cfed145015cb3e48da9a97947f7c4ed7/schema-migration-planner)

SOURCE REVIEW

 Reviewed 2026-10-13
 Evidence 6 linked sources
 Publisher JetBrains
 Licence [MIT (upstream Kotlin backend agent skills) ↗](https://github.com/yalishevant/kotlin-backend-agent-skills/blob/fd0ed521d22efd28221d532c9abab97af0b9bf0e/LICENSE)
 Revision e0f258b5cfed
 [Read what was—and wasn’t—checked ↓](#review)

“Plan safe database schema evolution and zero-downtime change rollout for Kotlin plus Spring systems using Flyway, Liquibase, or equivalent migration tooling.”

 [JetBrains · upstream description ↗](https://github.com/JetBrains/skills/blob/e0f258b5cfed145015cb3e48da9a97947f7c4ed7/schema-migration-planner/SKILL.md) Our analysis follows below.

01 / THE REASONING

## Why this made the selection.

 - Encodes expand/contract migration as a planning contract: classify the change as additive, destructive, semantic or data-moving, decide whether old and new application versions must coexist, then phase the rollout and treat cleanup as a separate step behind an explicit proof threshold.
- Names operational traps: non-null column adds that rewrite or lock large tables, backfills that saturate replicas and CDC consumers while primary write latency looks fine, renames that are copy-switch-drop plans in disguise.
- The output contract forces operational-risk and verification sections, so a run produces a reviewable migration plan rather than correct-but-dangerous SQL.

### A good fit for

 - Planning a zero-downtime migration on a live, high-traffic table
- Reviewing a migration PR for lock, backfill, replication and rollback risk
- Deciding whether roll-forward is safer than rollback after data has already changed

### Weigh up before choosing

 - Framed for Kotlin plus Spring services; the workflow is dialect-generic but the tooling notes lean on Flyway and Liquibase in that ecosystem.
- No worked SQL or reference files — the skill is heuristics plus an output contract, so the agent must supply the dialect-specific DDL and verify lock behaviour against the actual database version.
- Operational claims (lock behaviour, backfill load, replication lag) are planning prompts, not measured guidance for a specific engine.
- The author: Kotlin credit is added by the JetBrains mirror. The upstream SKILL.md names no author, and the upstream repository now sits under the personal account yalishevant with an MIT licence naming Anton Yalyshev.
- The JetBrains/skills README disclaims the catalogue as provided for demonstration and educational purposes only and asks you to test each skill before relying on it.
- The upstream repository moved: https://api.github.com/repos/Kotlin/kotlin-backend-agent-skills now returns yalishevant/kotlin-backend-agent-skills, a personal account (checked 2026-10-13). The pins and the MIT licence are unchanged.

02 / THE REVIEW RECORD

## What we actually inspected.

Source review has boundaries. A clear record is more useful than a “safe” badge.

### Material inspected

 - schema-migration-planner/SKILL.md (JetBrains mirror, complete, 107 lines)
- schema-migration-planner/agents/openai.yaml (identical to upstream)
- upstream yalishevant/kotlin-backend-agent-skills schema-migration-planner SKILL.md
- upstream yalishevant/kotlin-backend-agent-skills LICENSE
- JetBrains/skills README mirror policy
- https://github.com/Kotlin/kotlin-backend-agent-skills (answers HTTP 301 to yalishevant/kotlin-backend-agent-skills)
- mirror SKILL.md diffed against the upstream SKILL.md at fd0ed521d22efd28221d532c9abab97af0b9bf0e

### Our findings

 - The planning workflow classifies the change first and makes old/new code coexistence an explicit decision before any rollout phase is planned.
- Guardrails forbid direct destructive DDL on live systems without a phased plan and refuse to assume rollback is safe once data has been transformed.
- A diff against the upstream SKILL.md at fd0ed521d22efd28221d532c9abab97af0b9bf0e shows the mirror adds four frontmatter lines (metadata, short-description, author: Kotlin, source) and nothing else; the upstream file has no author field. agents/openai.yaml is identical in both.
- Upstream health: https://github.com/Kotlin/kotlin-backend-agent-skills, which the mirror’s metadata.source and README name, now answers HTTP 301 to yalishevant/kotlin-backend-agent-skills, a personal account (https://api.github.com/repos/Kotlin/kotlin-backend-agent-skills returns full_name yalishevant/kotlin-backend-agent-skills, owner type User). fd0ed521d22efd28221d532c9abab97af0b9bf0e is still that repository’s head, and its LICENSE (MIT, copyright 2026 Anton Yalyshev) is unchanged (checked 2026-10-13).

### Not established by this review

 - No migration was planned against a real schema and no SQL was executed.
- Lock, backfill and replication behaviour claims were not measured on any database.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

## Add a skill to your workflow.

[Upstream setup instructions ↗](https://github.com/vercel-labs/skills/blob/7407f3893ad4dceab546ac002c3ef806e4000c73/README.md)

DOCUMENTED COMMAND

 npx skills add JetBrains/skills/schema-migration-planner --skill schema-migration-planner Copy command ↗

Run in your terminal to choose your AI tools, project or global scope, and installation method. This short command follows the current upstream version; the review covers the revision shown above.

 Optional: install the reviewed revision

Keeps the original source and installer version where recorded, while leaving your AI tools and installation scope for you to choose.

 npx skills add https://github.com/JetBrains/skills/tree/e0f258b5cfed145015cb3e48da9a97947f7c4ed7/schema-migration-planner --skill schema-migration-planner Copy reviewed-revision command ↗ - Install the complete skill directory; the agents profile travels with the SKILL.md.
- Bring the current schema, target shape and deployment model; expect a phased plan with an explicit compatibility story, not a single migration script.

### Before you start

 - Node.js/npm for the installer
- An agent that supports the Agent Skills format
- Schema access, table sizes and the migration tool actually in use

### Compatibility

Agent Skills-compatible coding agents · Any SQL schema managed with a migration tool; Flyway and Liquibase named as examples · Kotlin plus Spring framing adapts to other stacks

### Reads schema and migration files; writes migration plans and SQL

 - Read schema definitions, migration scripts and deployment configuration
- Write migration files and phased rollout plans when authorized
- Executing planned DDL on a live database remains the user's decision, not the skill's

### Cost model

MIT-licensed instruction package; running actual migrations carries its own operational risk and cost.

04 / FOLLOW THE EVIDENCE

## The source trail.

Our notes are separate from the original resource. Check upstream before adopting a new version.

 - [Skill definition at reviewed revision ↗](https://github.com/JetBrains/skills/blob/e0f258b5cfed145015cb3e48da9a97947f7c4ed7/schema-migration-planner/SKILL.md) Checked 2026-10-13 https://github.com/JetBrains/skills/blob/e0f258b5cfed145015cb3e48da9a97947f7c4ed7/schema-migration-planner/SKILL.md Supports: summary, upstreamDescription, whySelected, bestFor, limitations, review, access
- [Upstream skill definition (Kotlin backend agent skills origin) ↗](https://github.com/yalishevant/kotlin-backend-agent-skills/blob/fd0ed521d22efd28221d532c9abab97af0b9bf0e/.agents/skills/schema-migration-planner/SKILL.md) Checked 2026-10-13 https://github.com/yalishevant/kotlin-backend-agent-skills/blob/fd0ed521d22efd28221d532c9abab97af0b9bf0e/.agents/skills/schema-migration-planner/SKILL.md Supports: review, limitations
- [Upstream licence (MIT) ↗](https://github.com/yalishevant/kotlin-backend-agent-skills/blob/fd0ed521d22efd28221d532c9abab97af0b9bf0e/LICENSE) Checked 2026-10-13 https://github.com/yalishevant/kotlin-backend-agent-skills/blob/fd0ed521d22efd28221d532c9abab97af0b9bf0e/LICENSE Supports: license
- [Former upstream location (HTTP 301 to yalishevant/kotlin-backend-agent-skills) ↗](https://github.com/Kotlin/kotlin-backend-agent-skills) Checked 2026-10-13 https://github.com/Kotlin/kotlin-backend-agent-skills Supports: review, limitations
- [Mirror policy: JetBrains-filtered, JetBrains-verified snapshot with source links and CI skill scanning ↗](https://github.com/JetBrains/skills/blob/e0f258b5cfed145015cb3e48da9a97947f7c4ed7/README.md) Checked 2026-10-13 https://github.com/JetBrains/skills/blob/e0f258b5cfed145015cb3e48da9a97947f7c4ed7/README.md Supports: review, install, limitations
- [Skills installer source formats and selective installation ↗](https://github.com/vercel-labs/skills/blob/7407f3893ad4dceab546ac002c3ef806e4000c73/README.md) Checked 2026-10-13 https://github.com/vercel-labs/skills/blob/7407f3893ad4dceab546ac002c3ef806e4000c73/README.md Supports: install

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### CockroachDB SQL ↗ Cockroach Labs skill that turns a natural-language request into CockroachDB SQL, applies the relevant rule files with 00-fundamental-principles.md first, and tells the agent to run EXPLAIN on every generated query when a cluster connection is available.](/skills/cockroachlabs-cockroachdb-sql/)[### dbt Documentation Maintenance ↗ Audits descriptions in a dbt manifest and drafts missing model or column documentation in the project’s existing style.](/skills/dbt-labs-maintaining-dbt-documentation/)[### DuckDB read file ↗ DuckDB's read-file skill: one DuckDB CLI command that picks a reader by file extension and returns a file's schema, row count and first 20 rows, for local paths or HTTPS, S3, GCS and Azure URLs.](/skills/duckdb-read-file/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Choose a toolkit](/tools/)
- [Inspect execution hosts](/agents/)
- [Check tool access](/mcp-servers/)
- [Check project dependencies](/check-repo/)
