spawn migration status

Usage

spawn migration status

Displays a table showing the status of all migrations from both the filesystem and database.

Output columns

• Migration — Migration directory name
• Filesystem — ✓ if up.sql exists, ✗ otherwise
• Pinned — ✓ if lock.toml exists, ✗ otherwise
• Database — ✓ if recorded in _spawn.migration_history, ✗ otherwise
• Status — Current state:
  • ✓ Applied — Successfully applied
  • ⊙ Adopted — Marked as applied without running
  • ⚠ Attempted — Previous attempt failed
  • ✗ Failed — Last execution failed
  • ○ Pending — Not yet applied

Example output

┌─────────────────────────────────┬────────────┬────────┬──────────┬───────────┐
│ Migration                       │ Filesystem │ Pinned │ Database │ Status    │
├─────────────────────────────────┼────────────┼────────┼──────────┼───────────┤
│ 20260131120000-add-users-table  │ ✓          │ ✓      │ ✓        │ ✓ Applied │
│ 20260131130000-add-posts-table  │ ✓          │ ✗      │ ✗        │ ○ Pending │
└─────────────────────────────────┴────────────┴────────┴──────────┴───────────┘

Example

spawn migration status

Options

Option	Description
-e, --environment <name>	Override the environment for the target config.
--target <name>	Select which target from spawn.toml to use.
--config-file <path>	Path to config file. Defaults to spawn.toml.
-d, --debug	Turn on debug output.