skills.rest
HZeroxium
HZeroxiumCOMMUNITY
Explore all skills by this author →
GitHub

java-sql-schema-migrations

Plan and execute expand/contract SQL schema migrations across Java databases.

1|Updated Jan 19, 2026
Search Tags:#database#migrations#backend#sql#zero-downtime#risk-management#expand-contract
One-click install
npx skills add https://github.com/HZeroxium/cursorkit --skill java-sql-schema-migrations
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: java-sql-schema-migrations
Source: https://github.com/HZeroxium/cursorkit/tree/main/lib/skills/java-backend/java-sql-schema-migrations
Command: npx skills add https://github.com/HZeroxium/cursorkit --skill java-sql-schema-migrations

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Safely evolving SQL schemas in production without downtime by providing a repeatable, tool-agnostic expand/contract migration playbook.

Core Features & Use Cases

  • Expand/Migrate/Backfill/Switch/Contract workflow for zero-downtime schema changes
  • Guardrails for risk assessment, rollback strategies, and observability
  • Tool-agnostic guidance compatible with Flyway, Liquibase, or plain SQL migrations

Quick Start

Plan and execute an expand/contract migration for a live schema, starting with an additive change and a controlled backfill.

Frequently Asked Questions about java-sql-schema-migrations

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I perform zero-downtime SQL schema migrations in a Java backend?▼

Zero-downtime SQL schema migrations use an expand/contract playbook to evolve databases safely through expand, migrate, backfill, switch, and contract phases without service interruption.

What is the expand/contract pattern for database migrations?▼

The expand/contract pattern separates schema changes into additive expand steps and removal contract steps, allowing backward-compatible database migrations and safe rollbacks during production deployments.

Does this migration approach work with both Flyway and Liquibase?▼

Yes, the zero-downtime migration playbook is tool-agnostic and provides guardrails compatible with Flyway, Liquibase, or plain custom SQL migrations in Java backend environments.

How do I backfill data during a zero-downtime schema change?▼

Data backfill occurs during the migrate phase of the expand/contract workflow, updating existing rows incrementally while the application remains online and maintains backwards compatibility.

What are the limitations of zero-downtime migrations with expand/contract?▼

Zero-downtime migrations require strict adherence to guardrails and backwards compatibility, meaning contract phases must wait until all dependent services fully migrate to the new schema.

Related Skills

Explore More Software Engineering Skills→
cwijayasundaracwijayasundara
3

checking-migration-safety

Validate reversible database schema changes for backward compatibility.

Community
Advanced
highflame-aihighflame-ai
4

ship

Orchestrate parallel subagent analysis for pre-merge code review and post-deployment verification.

Official
Advanced
loianeloiane
50

flyway-or-liquibase-detection

Detect Flyway or Liquibase usage from pom.xml dependencies and migration directories.

Community
Intermediate
a53alia53ali

database-migration

Guide database schema migrations with expand/contract patterns and rollback strategies.

Community
Advanced