Greenmask

Greenmask is an open source utility for logical database backup dumping, anonymization, synthetic data generation and restoration for PostgreSQL. It has ported PostgreSQL libraries and is backward-compatible with the existing PostgreSQL utilities.

It is stateless and requires no changes to the database schema. Transformers mask or replace sensitive values, with a deterministic option so that the same input always gives the same output and references stay consistent across tables. Database subsetting reduces the size of the copy while keeping referential integrity. The result is a production-like database for development, testing and CI environments.

Greenmask is open source under the Apache 2.0 licence. A commercial offering adds automated provisioning of production-like environments.