Workflow · Ship

Database migration rehearsal

Run a risky schema migration against a restored copy of production first, measure it, and only then schedule the real one.

When to use it

A migration touches a large table, changes a column type, or you are not sure the rollback still works afterwards.

Crew constellation: Kapten at the centre, linked to Bosun, Helmsman, Lookout.BosunStage 1HelmsmanStage 2LookoutStage 3Kapten1 step · orchestrates
Kapten briefs each specialist in stage order and merges what they send back.
Specialists
4
Stages
4
Tier
Plan → Act
Duration
Depends on data size

Start it with one prompt.

Paste it into Claude Code, Claude Desktop or Cursor once Kapten is connected. Replace the names with yours; Kapten asks for anything it cannot infer.

Connect your agent
prompt
Rehearse migration 0042_split_orders against a copy of production. Tell me how long it locks, and whether the previous release still works after it.
Simulated run
  1. You ask

    › Rehearse migration 0042_split_orders against a copy of production. Tell me how long it locks, and whether the previous release still works after it.

  2. Gate 01 · stops for your approval

    Approve restoring the snapshot

  3. Stage 1

    • BosunInfrastructure

      Restore a copy

      Restores the latest production snapshot into an isolated, short-lived environment.

  4. Stage 2

    • HelmsmanReleases

      Run the migration

      Applies the migration and records its duration and the locks it takes.

  5. Stage 3

    • LookoutObservability & incidents

      Test both releases

      Runs the current and the previous release against the migrated schema to check the rollback path.

  6. Stage 4

    • KaptenOrchestration

      Go / no-go report

      Duration, locking, rollback safety and a recommended window. The rehearsal copy is then deleted.

  7. You get

    • Measured migration duration and locks
    • Rollback compatibility verdict
    • A recommended release window

Related guide

Rollbacks that survive a schema migration

Read the guide ↗

More workflows

Keep the crew busy.

Build with Kapten

Start with one service.
Build from there.

Tell us what you want to deploy. We review each request and follow up about fit and onboarding on your preferred cloud.

Free during early access. No card required. Cloud usage billed separately.