Greenmask

What Greenmask is

Greenmask is a free, open-source utility for logical database dumps, data anonymization, synthetic data generation, and restoration. It fully supports PostgreSQL 11 and later; MySQL is listed as beta and in progress. Its subsetting tools create smaller development databases while maintaining referential integrity, including cyclic and polymorphic references. Transformations can be deterministic or random, use dynamic parameters and conditional rules, and carry through partitions and foreign-key relationships. Users can build custom transformers that exchange data through standard input and output, or start from provided templates. Storage options include local directories, S3-compatible storage, Azure Blob Storage, and SSH/SFTP. Greenmask uses PostgreSQL's pg_dump and pg_restore for schema dumping and restoration, and its dumps can be restored with pg_restore. It is designed for CI/CD workflows that automate anonymization and restoration. Its stateless, in-flight approach can transform data before persistence without requiring unmasked datasets to be persistently stored in the normal workflow. Installation scripts support Linux and macOS; Windows is not supported yet.