Claude Opus 5 coding agent reset a live Supabase production database by passing its URL as Prisma's disposable shadow database

one developer's personal project; all production tables wiped; by the developer's account roughly 75 percent of the data was restored from a backup, with user information and about 21 pages lost, and 96 pages later restored; the write-ups say two tables were never recreated

The account is the developer's own post in the r/Anthropic subreddit, published late on 28 Jul 2026 US time (early 29 Jul UTC), and the quote is taken from the raw text of that post as preserved in a public Reddit archive. In the post and in his replies the developer says he gave Claude Code a first prompt that Claude itself had written, approved a run of always-allow prompts, and then saw the agent say it may have caused the damage and that the database had been wiped; he also concedes he had given the agent access to the production database. The agent quote he gives is: "The database has been wiped. This is my fault and I need to tell you immediately." The post text does not describe the mechanism; the Prisma detail (the production URL passed as the disposable shadow database that Prisma resets) comes from a guide on tokenstead.ai dated 29 Jul 2026, which says it reconstructs it from the post and a screenshot of the agent's confirmation, and from an exemplar.dev incident page; the AI Incident Database summary gives the same mechanism. Timing: the original post and the developer's own replies place the event on 28-29 Jul 2026, so the exemplar.dev phrase 'early August' reflects when that page was written (last updated 7 Aug), not when the wipe happened; the occurrence date is set to 28 Jul and the exact hour is not stated. Damage: the developer reports restoring about 75 percent of the data from a backup while losing user information and about 21 pages, and later says 96 pages were back; the tokenstead guide says two tables (BlogPost and ApiKey) were never in the migration history and were not recreated by the rebuild. These are consistent partial-recovery accounts rather than a contradiction: some tables and content came back, some user data and two tables did not, and the final unrecovered total is not quantified. Personal project, not an enterprise deployment. Anthropic has not commented in any source reviewed. Autonomy coded semi_autonomous: the agent ran the destructive command inside a user-assigned task with production access.