Greenmask vs SQL Change Guard

Greenmask is a free, open-source utility for logical database backups, anonymization, synthetic data generation, and restoration. It currently supports PostgreSQL, with MySQL, MongoDB, and other database support in development. Transformations can be deterministic or random, use dynamic parameters, mask data, or apply custom rules based on domains. Configuration validation can show warnings and data or schema differences, and transformation settings can be inherited across partitions of partitioned tables. Greenmask stores backups in local directories or S3-like remote storage. It supports parallel dumping and restoration, as well as parallel compression with pgzip. Its logical-dump approach does not require changes to the existing database schema, and dumps can be restored with pg_restore. CI/CD integration can automate anonymization and restoration. Greenmask runs on Linux and macOS and can be self-hosted on premises. Installation options include an install script, Docker, Homebrew, or building from source; the install script works on Linux and macOS, while Windows is not supported yet. A Docker Playground with sample databases provides a sandbox for trying the utility. The maker offers paid custom development for urgent or enterprise-specific feature requests.

SQL Change Guard has no write-up on Specifiction yet; its figures are above.