pilotbase.pro

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 free

More free data tools