# Greenmask

> An open-source CLI utility that masks PostgreSQL database dumps and creates synthetic test data for CI/CD workflows.

- **Category:** Database Management
- **Licence:** Apache-2.0
- **Latest version:** v0.2.26
- **Open source:** oss
- **Languages:** Go
- **Platforms:** Docker, Docker Compose, Linux, Homebrew
- **Tags:** PostgreSQL, Backup, CLI, Security, MySQL, Databases, Security Tools, Go, Golang, Restore, Testing tools, Ci Cd, Data Masking, Anonymization, Pg, Dba, Mysqldump, Synthetic Data, Faker, Obfuscation, Test Data Management, Subsetting, Differential Privacy, Dump, Sql Dump

## Description

Greenmask is an open-source command-line program that dumps, anonymizes, and restores databases while generating synthetic test data. It supports PostgreSQL (production ready) and MySQL (beta), producing output compatible with standard PostgreSQL and MySQL dump utilities. Features include database subsetting for smaller consistent development copies, deterministic masking via hash functions, dynamic parameters adapting to other column values, conditional transformation logic, and inheritance for partitioned tables. Storage options cover local directories, S3-compatible services (AWS S3, MinIO, GCS, Cloudflare R2), Azure Blob Storage, and SSH/SFTP. It provides parallel execution, pgzip compression, and custom transformers in any language. Available as a single binary, Docker image, Homebrew package, or install script, it fits into CI/CD pipelines for automated database masking and recovery workflows.

## Links

- [Homepage](https://github.com/greenmaskio/greenmask)
- [Website](https://greenmask.io/docs/greenmask)
- [Docker](greenmask/greenmask)
- [GitHub Repository](https://github.com/GreenmaskIO/greenmask)
- [Discord Community](https://discord.com/invite/rKBKvDECfd)
- [Telegram Chat](https://t.me/greenmask_community)
- [Twitter/X](https://x.com/GreenmaskIO)

---
Source: https://selfhost.directory/project/greenmask