How I Anonymized Relational SQL Dumps Without Breaking Foreign-Key Relationships

Описание и применение

CloakDB — инструмент для анонимизации SQL‑дампов, сохраняющий связи между таблицами, используя детерминированное псевдонимирование и потоковую обработку.

Задача

Anonymizing relational SQL dumps often breaks foreign-key relationships, rendering the data useless for development and testing.

Результат

CloakDB preserves relational integrity while anonymizing sensitive data, enabling safe use of production snapshots for development and testing.

Рабочий процесс

• Scan SQL dump for potential PII (emails, names, phone numbers, IPs, etc.)
• Preview detected fields and proposed transformations
• Apply deterministic pseudonymization mapping to replace each unique value consistently
• Mask values according to chosen strategy
• Stream the transformed data to produce the anonymized SQL dump

Доказательства

CloakDB maintains consistent mappings during processing

Источник

The tool can scan for potential PII such as email addresses, names, phone numbers, IP addresses, Turkish identification numbers, credit card numbers

Источник