Restore your PostgreSQL database to a precise moment, or from a pg_dump (2026)
A failed migration, a table emptied by mistake: your database goes back to the moment before, with a simple request to your AI. A safety backup is taken first, and in production, nothing happens without your approval.
By Aloïs Oddon, co-founder of Nextmap. Facts checked on November 19, 2026.
The short version. Made a mistake in your data? Your AI restores your PostgreSQL database to yesterday at 6 pm, or imports a pg_dump. A safety backup comes first. What matters, like deleting a database, waits for a person’s approval.
Prerequisites
- An app deployed on while, with its PostgreSQL database.
- Your AI, connected to while over MCP.
Step 1: Tell your AI where to go back to
You, to your AI: Restore the database to yesterday at 6 pm.
Your AI prepares the restore, to the moment you asked for, and gives you a link.
Step 2: Approve
You open the link and approve, or an administrator does, depending on your permissions. A safety backup is taken first, then the restored database takes the place of the old one.
What your AI does
Your database archives its write-ahead log continuously and takes a full backup every day, with nothing for you to declare: that’s what lets it go back to a precise moment1. Your AI picks the point to go back to, a backup or a moment, within the 14 days they are kept. The restored database is created separately, then takes the place of the old one: nothing is overwritten before you approve.

Check that a backup really works
You, to your AI: Take a backup and check it.
Your AI starts a backup, followed right away by a test: a throwaway database is created from it, and its tables are read back.
Import a pg_dump export
You, to your AI: Import our Heroku export into the database.
Your AI uploads the export, then loads it into your database with pg_restore, separately from your app2.
Find the rows involved before you go back
You, to your AI: Show me the orders deleted since yesterday.
Your AI reads your database in SQL over MCP, with your permissions on the data and without being able to write to it, and shows you the rows involved before you choose the moment.
Go back to the previous version
You, to your AI: Go back to the previous version.
In the 30 minutes after a production release, the previous version comes back in a second. After that, it takes a few seconds. Once the previous version is back, your AI reads what broke in while’s logs, fixes it and deploys again.
In the docs: PostgreSQL databases, Tested backups and Versions and rollback.
Next steps
Sources
- PostgreSQL, continuous archiving and point-in-time recovery, accessed November 2, 2026
- PostgreSQL, the pg_restore command, accessed November 2, 2026