Greenmask is a powerful open-source utility for logical database dumping, anonymization, synthetic data generation, and restoration. Designed for PostgreSQL and MySQL (in progress), it is stateless and creates logical backups compatible with standard tools like pg_restore or mysqldump.



Supported Databases
- PostgreSQL: Fully supported (Production Ready).
- MySQL: Work In Progress (Beta).
Key Features
- Database Subsetting: Create smaller, referentially intact development databases with support for cyclic and polymorphic references.
- Storage Agnostic: Supports local directories and S3-compatible storage (AWS S3, MinIO, GCS, Azure, etc.) for flexible backup management.
- Deterministic Transformation: Reproducible data masking using hash functions, ensuring consistent output for the same input.
- Dynamic Parameters: Transformers can adapt based on other column values to maintain logical consistency (e.g.,
created_at < updated_at).
- Transformation Condition: Apply transformations only when specific criteria are met, allowing for conditional logic at the table or transformer scope.
- Stateless & Compatible: Operates as a logical dump proxy. Dumps are compatible with
pg_restore.