pgVolvra gives Postgres a real undo button for bad SQL

Muhammad Aqeel: Undo for Postgres, without losing the rest of your day

A missing WHERE clause can turn one second of bad SQL into an afternoon of senior engineers hand-reconciling rows. pgVolvra records every row change on chosen tables in plain SQL and PL/pgSQL, then reverses exactly the affected changes while leaving later legitimate edits intact. It adds a read-only as_of view of the past, a warning when a statement touches too many rows, and an external archive that can replay hours of work lost after a backup restore. It runs on managed Postgres without extensions or superuser rights.

There is no force flag, and I left it out on purpose, because a force flag always gets used eventually and always on the worst day.

More from this day

2026-10-29