Greenmask
github.com
What it is
Greenmask is a free, open-source utility for logical database dumps, anonymization, synthetic data generation, and restoration. PostgreSQL 11 and later is fully supported; MySQL support is in progress and beta. Its subsetting tools can produce smaller development databases while preserving referential integrity, including cyclic and polymorphic references. Transformations may be deterministic or random, use dynamic parameters and conditional rules, and inherit across partitions and foreign-key references. Users can make custom transformers that exchange data through standard input and output, or use predefined templates. Greenmask supports local directories, S3-compatible storage, Azure Blob Storage, and SSH/SFTP. It uses PostgreSQL's pg_dump and pg_restore utilities for schema dumping and restoration, and its dumps can be restored with pg_restore. The utility is designed for CI/CD automation of anonymization and restoration. Its stateless, in-flight approach can anonymize data before it is persisted without requiring persistent storage of unmasked datasets in its normal workflow. Installation scripts support Linux and macOS; Windows is not supported yet.
Spec sheet
- Purpose
- Greenmask is an open-source utility for logical database dumping, anonymization, synthetic data generation, and restoration.Read 29 Sep 2026 · github.com
- CI/CD
- Greenmask is designed to integrate into CI/CD systems for automated database anonymization and restoration.Read 29 Sep 2026 · docs.greenmask.io
- Company history
- Greenmask says it was founded in 2023 with the launch of its Greenmask utility.Read 29 Sep 2026 · greenmask.io
- Custom transformations
- Users can create custom transformers that interact through standard input and output, and the tool also provides predefined templates.Read 29 Sep 2026 · docs.greenmask.io
- Database support
- PostgreSQL is fully supported, while MySQL is described as in progress and beta.Read 29 Sep 2026 · github.com
- Database tools
- Greenmask uses PostgreSQL's pg_dump and pg_restore utilities to handle schema dumping and restoration, and its dumps can be restored with pg_restore.Read 29 Sep 2026 · docs.greenmask.io
- Installation limit
- The installation guide says the install script works on Linux and macOS and that Windows is not supported yet.Read 29 Sep 2026 · docs.greenmask.io
- PostgreSQL compatibility
- Greenmask is compatible with PostgreSQL versions 11 and higher.Read 29 Sep 2026 · docs.greenmask.io
- Security architecture
- Greenmask describes a stateless in-flight transformation design that can anonymize data before it is persisted and does not require persistent storage of unmasked datasets in its normal workflow.Read 29 Sep 2026 · github.com
- Security reporting
- The security policy asks researchers to report vulnerabilities privately by email or GitHub private vulnerability reporting and says receipt will be acknowledged within 72 hours.Read 29 Sep 2026 · github.com
- Storage integrations
- Supported storage backends include local directories, S3-compatible storage, Azure Blob Storage, and SSH/SFTP.Read 29 Sep 2026 · docs.greenmask.io
- Subsetting
- Database subsetting can create smaller development databases while preserving referential integrity, including cyclic and polymorphic references.Read 29 Sep 2026 · github.com
- Supported releases
- The security policy supports the latest stable release and lists older releases as unsupported.Read 29 Sep 2026 · github.com
- Transformations
- Greenmask provides deterministic and random transformers, dynamic parameters, conditional transformations, and inheritance for partitions and foreign key references.Read 29 Sep 2026 · docs.greenmask.io
Plans and prices
Strong points and limits
Strong points
- PostgreSQL 11 and later fully supported.
- Subsetting preserves referential integrity, including cyclic references.
- Supports deterministic and random transformations.
- Supports local, S3-compatible, Azure Blob, and SSH/SFTP storage.
- Designed for CI/CD anonymization and restoration.
Limits
- MySQL support is in progress and beta.
- Windows is not supported by the installation script.
- Older releases are listed as unsupported.
Who it suits
Greenmask suits teams that need PostgreSQL database anonymization, subsetting, or restoration in development and CI/CD workflows. MySQL users should account for its beta, in-progress support.
Verdict
Greenmask provides PostgreSQL-focused dumping, transformation, and restoration with data subsetting and multiple storage backends. Its platform and database limits matter: installation scripts cover Linux and macOS, while MySQL remains beta.
Where Specifiction places it
- Data Masking Software#8 of 267.9