-
Deployment
Verify your database backups actually restore
Confirm backups exist, run on schedule, and can actually be restored before you need them.
Free Prompt
Verify my database backup setup end to end. An untested backup is a wish, and I don't want to find out on the worst day of the launch that mine is broken.
Check each of these:
1. Backups exist and run automatically. Confirm the schedule (daily minimum for a live app, ideally point-in-time recovery for anything transactional) and confirm recent backup files or snapshots are present with sensible retention (a week of dailies at minimum; longer for compliance if I need it).
2. Backups live somewhere separate from the production database. A backup in the same account/region that gets deleted when the account is compromised or the region goes down is not a backup.
3. Restore actually works. Restore the most recent backup into a temporary database, run a few sanity queries against it (row counts on key tables, a spot check of a recent record), and confirm the restored data matches what's live. This is the step everyone skips and it's the whole point.
4. Document the restore procedure: exact steps to restore into production or a new instance, who has the credentials to do it, and roughly how long a full restore takes (so I know whether the RTO is minutes or hours).
5. If I'm using a hosted database (RDS, Neon, Supabase, etc.), confirm point-in-time recovery is enabled and confirm I know how to invoke it, not just that it's turned on.
Don't accept 'the platform handles it' as verification. The deliverable is a documented restore run against a real backup, the runbook checked into the repo, and any gaps flagged with a fix (missing schedule, missing off-site copy, or unclear procedure).
What This Does / How This Helps
This confirms your backups exist, run on schedule, live somewhere the production account can't nuke, and, most importantly, actually restore into a working database. The common story is 'we had backups' followed by 'we couldn't restore them'. Silent backup failures are extremely common because nobody notices until they need one. Doing a real restore, once, before launch, is the difference between a bad afternoon and a company-ending week.
Want to skip doing this by hand?
Fortivibe audits your app for all of the areas these prompts cover (and more).