Info Commands¶
View migration status and history.
queen status¶
Show migration status.
Uses the global --json flag for JSON output.
Examples¶
Version | Name | Status | Applied At
--------|-------------------|----------|---------------------------
001 | create_users | Applied | 2026-02-01 10:30:00
002 | add_timestamps | Applied | 2026-02-01 10:30:05
003 | create_tags | Applied | 2026-02-02 14:20:00
004 | add_posts_status | Pending | -
Applied: 3 | Pending: 1
Status Types¶
- Applied -- Migration successfully applied.
- Pending -- Registered but not yet applied.
- Modified -- Applied but checksum changed (migration code modified after applying).
queen log¶
Display migration history with metadata.
| Flag | Type | Default | Description |
|---|---|---|---|
--last |
int | 0 | Show last N migrations (0 = all) |
--since |
string | "" | Show migrations since date (YYYY-MM-DD) |
--with-duration |
bool | false | Show execution duration |
--with-meta |
bool | false | Show all metadata (applied_by, hostname, etc.) |
--reverse |
bool | false | Show in reverse order (newest first) |
Examples¶
queen log
queen log --last 10
queen log --with-duration --with-meta
queen log --since 2026-02-01
queen log --reverse
Output:
Version: 003
Name: add_posts_table
Applied: 2026-02-07 14:32:15
Duration: 124ms
Checksum: a3f2e1d9
Applied by: user@host
Use Cases¶
- Audit trail: Track who applied migrations and when.
- Performance analysis:
queen log --json | jq '.[] | select(.duration_ms > 1000)'
queen version¶
Show current migration version.
Examples¶
Faster than queen status when only the version is needed.
queen diff¶
Compare two migration versions.
Takes exactly 2 arguments. Supports special keywords: current, latest, and relative versions (+3, -2).
| Flag | Type | Default | Description |
|---|---|---|---|
--show-sql |
bool | false | Show SQL statements for each migration |