PostgreSQL Anonymizer: Declarative Data Masking for Postgres

2025-01-17

PostgreSQL Anonymizer is a powerful database extension enabling declarative definition of data masking rules directly within the database schema. It supports multiple masking methods including static, dynamic masking, and anonymous dumps, offering various masking functions like randomization, faking, partial scrambling, and custom functions. Designed for anonymization-by-design, it protects sensitive data like PII and commercially sensitive information during development. The extension includes detection functions to suggest columns needing anonymization. Quick start via Docker, complete tutorials, and success stories from organizations like the French Public Finances Directorate General (DGFiP) and bioMérieux are provided.