Paste a schema, detect likely PII columns, get masking SQL instantly.
Open the PII Detector →Before copying production data into staging or dev, sensitive columns need to be masked. MetaDataLoop scans your CREATE TABLE schema for 15+ categories of likely-PII columns by name heuristics — emails, names, SSNs, cards, addresses, health data — then generates dialect-aware UPDATE statements to mask them.
Sample values and the dialect-native type they map to.
| Sample value | Inferred type |
|---|---|
| email, name columns | MD5() hash (HASHBYTES on SQL Server) |
| phone, SSN, card, account | Partial mask — last 4 digits kept |
| address, IP, gender | Fixed placeholder value |
| password, secret, token | Full redaction → [REDACTED] |
| date of birth | Set to NULL |
CREATE TABLE customers ( id SERIAL PRIMARY KEY, first_name VARCHAR(50), email VARCHAR(255) NOT NULL, phone VARCHAR(20), ssn VARCHAR(11) );
UPDATE "customers"
SET
"first_name" = MD5("first_name"),
"email" = CONCAT(MD5("email"), '@masked.example.com'),
"phone" = CONCAT('XXX-XXX-', RIGHT("phone", 4)),
"ssn" = CONCAT('XXX-XX-', RIGHT("ssn", 4));
No signup, no install — runs entirely in your browser.
Open the PII Detector →