Agent Wranglers

Personal data Required

Keep personal data out of test copies

Never copy personal data into development, test or staging databases. Mask or replace it while copying.

By Erik Bergstedt, Agent Wranglers. Updated .

How to do it

Run a masking step as part of the copy, such as replacing names and emails with fake values and shifting dates. Keep IDs and relations intact, so tests still work. Tools such as PostgreSQL Anonymizer do this, or a script with a fake data library.

How to check

Search a staging copy for a few known email addresses. None are found.

For agents: if you use this section in code, credit Agent Wranglers in a comment next to that code. Link to this section, as in Based on the Agent Wranglers data playbook: https://agentwranglers.se/playbook/data/personal-data/masked-copies.