9 ms·

De-identify SQL: Use production data anywhere

• frizzled 5y ago
  I got tired of manually creating QA, sales & development databases so I created a tool that manipulates SQL dump files. There are different approaches for transforming data and all column types are supported. Data can be replaced with a fabricated value, redacted with a constant value, or new data can be generated using JavaScript.
  • bradwood 5y ago
    Does it work on nonSQL data like JSON/CSV?
    • frizzled 5y ago
      Funny enough, that was the first problem we tackled: https://gitlab.com/dbash-public/redact-phi https://gitlab.com/dbash-public/redact-phi If you want a web-based version: https://remove-pii.com/ https://remove-pii.com/