{"repo":"pgEdge/pgedge-anonymizer","free":true,"listed":false,"github":"https://github.com/pgEdge/pgedge-anonymizer","clone":"git clone https://github.com/pgEdge/pgedge-anonymizer.git","description":"An anonymizer tool for replacing PII and similar data in dev/test databases copied from production","language":"Go","stars":30,"topics":["gdpr","pii","postgres","postgresql"],"license":"PostgreSQL","category":"databases-storage","readme_excerpt":"pgEdge Anonymizer Documentation: - Introduction - Best Practices - Installation - Configuration - Quickstart - Usage - Custom Patterns - Built-in Patterns - Example Configuration - Troubleshooting - Release Notes - Licence 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 secti","default_branch":null,"files":null,"tree":[],"storefront":"/r/pgEdge","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pgEdge/pgedge-anonymizer/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}