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

Description and use

CloakDB is a tool for anonymizing SQL dumps that preserves table relationships through deterministic pseudonymization and streaming processing.

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