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

来源