Backfill Script Review
Reviews a one-off data script for the three properties it needs — resumable, idempotent, rate-limited — before it is run at 2am.
Free — no card needed
Create a free account
to open Backfill Script Review — and the other 364 prompts across 21 categories.
Already have an account?
Running it, start to finish
- Confirm the script is idempotent and resumable before anything else.
- Run it on a copy, then a small limited batch in production.
- Verify the limited batch before releasing the full run.
What you get back
The output this produces, every time.
- Checks idempotency and resumability first, since scripts get interrupted and re-run.
- Requires key-based pagination over offset, which silently skips and repeats rows on live data.
- Demands a dry run that shows actual sample changes rather than a count.
Getting better results
Where this usually goes wrong, and how to avoid it.
- Never use offset pagination on live data. Rows shift under you, so an offset walk skips some and processes others twice, silently.
- Run a small limited batch first. Then verify before continuing. The full run should never be the first run against production.
- Rate-limit against the database. A backfill that saturates the connection pool takes down the application it was written to fix.
More Coding prompts
All Coding →- Coding
Refactor With a Safety Net
Plans a refactor as a sequence of individually safe, individually shippable steps, with the characterisation tests that make each one verifiable.
ClaudeChatGPT000Open → - Coding
Review for the Bug, Not the Style
A code review that hunts correctness failures and states the exact input that breaks each one, instead of listing naming preferences.
ClaudeChatGPTGemini000Open → - Coding
Database Migration Plan
Plans a schema change that ships without downtime, in steps that are each independently safe and reversible.
ClaudeChatGPT000Open →
Written for The AI University. Every prompt in this library is original work — authored, tested and revised here, not collected from elsewhere. 365 of them, free with an account.