pgEdge Anonymizer is a command-line tool for anonymizing personally identifiable information (PII) in PostgreSQL databases. The tool replaces sensitive data with realistic fake values that you can use for development and testing, while maintaining data consistency and referential integrity.

Features

• 100+ built-in patterns for common PII types across 19 countries
• Consistent replacement - same input produces same output within a run
• Foreign key awareness - automatically handles CASCADE relationships
• Large database support - efficient batch processing with server-side cursors
• Format preservation - maintains original data formatting where possible
• Single transaction - all changes committed atomically or rolled back
• Extensible - define custom patterns using date, number, or mask formats

Quick Start

Anonymizer lets you create an experimental data set that preserves the shape and integrity of a Postgres database in just three steps:

1. Create a configuration file that specifies the replacement patterns for your columns.
2. Build and run the pgedge-anonymizer to convert your columns.
3. Review the results.

Before running pgedge-anonymizer, you need to create a configuration file named pgedge-anonymizer.yaml; the file should contain:

• a database section, with connection details for your database.
• a columns section, listing the fully-qualified columns that you wish to anonymize (in schema_name.table_name.column_name format).
• patterns properties for each column that specifies the form that replacement content will take.

For example:

After creating a configuration file, run the anonymizer:

Review the list of changes as pgedge-anonymizer runs, displaying statistics:

Developer Notes

Prerequisites

• Go 1.24 or later
• PostgreSQL (for integration tests)
• Python 3.12+ (for documentation)

Use the following command to build pgedge-anonymizer:

Use the following command to run the Anonymizer test suite:

Use the following command to run the Go Linter:

Use the following command to format the code:

Support

• GitHub Issues
• Full documentation is available at the pgEdge website.

License

This project is licensed under the PostgreSQL License.