About erasureMap
Paste your schema (pg_dump, mysqldump or SQLite .schema), pick the users table, and see every foreign key that points at it, directly or through other tables, with its ON DELETE rule and whether the child column has an index. Columns that look like a user reference or personal data but have no foreign key (user_id, actor_id, created_by, email, phone, ip_address) are listed apart. Then copy a children-first delete and anonymise script for PostgreSQL, MySQL or SQLite, plus the leftover-count queries to run afterwards. Everything is read in your browser tab.
Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.
From the makers
Pilotbase: one admin app for PostgreSQL, MySQL, MongoDB, Redis and more, with an AI agent built in.
Get Pilotbase freeMore free data tools
sqlBeautify
Format, highlight and fix SQL as you type
sqlCompare
Diff two SQL files like git, after formatting both
downtimeAlert
We check your URL, API or stats page every 30 seconds and email you when it's down
sqlTranslate
Convert SQL between 14 dialects
explainViewer
See where a Postgres query spends its time
keysetBuilder
Keyset pagination queries from your ORDER BY