07 · Tables A→ZI · Version, time-travel & recover
Restore to a UTC timestamp
Reset a table to its state at a point in time. Destructive - discards everything after it.
restore_table resets a table to its state at a point in time. Use it when
you know roughly when things were good but not the exact version number.
Heads up
Destructive: all versions after the target timestamp are
discarded. Read the history and confirm before
running it.
Restore
eddytor restore table eddytor sales orders --timestamp "2026-06-15T14:30:00Z"restore_table(table="eddytor.cfg_xxx.<uuid>_orders", timestamp="2026-06-15T14:30:00Z")Open the table → History → pick the point in time → Restore.
Heads up
The timestamp must be ISO 8601 UTC - e.g.
"2026-06-15T14:30:00Z". Read candidate timestamps straight from
get_table_history (they're UTC) rather than
converting from local time.Safe procedure
get_table_history→ find the UTC timestamp of the last good state.- Confirm - no undo.
restore_table(table, timestamp="…Z").profile_table+validate_constraints.
Vacuum applies here too: you can't restore to a point whose files have been pruned.