-
Database
Implement soft deletes without breaking queries
Adds deleted_at handling with every query updated to respect it, plus a purge path for real deletion.
Free Prompt
What This Does / How This Helps
Adds trash-can deletion: records disappear for users but stay recoverable, with every single query updated to respect the deleted flag and a purge path so data doesn't pile up forever. Soft deletes done halfway are worse than no soft deletes. The deleted post vanishes from the list page but still shows up in counts, search results, and the direct URL. The prompt's value is the completeness sweep: every query path audited, including the easy-to-forget ones like exports and uniqueness checks. The purge plan matters too: 'deleted' data you keep forever is still data you have to protect and disclose, so there's a real deletion path at the end of the retention window.
Want to skip doing this by hand?
Fortivibe audits your app for all of the areas these prompts cover (and more).