How to mask information in mysql

Question

Let's assume that a database dump is made "production for the bank" development "where developers will work and I do not want developers to see sensitive information like social security number, credit card, phone, etc ... like could I mask this data in mysql?

Example

Original Phone: 1111-1111

Masked with X Phone: 11XX-XXXX

Masked randomly Phone: 5254-7293

note: the database was written in Portuguese (my language)

SELECT

diagram

Answer 1

There is a free version of DataVeil data masking software that you can use. It's similar to the software you ask about in your question's comments. There are also demo videos on the site. Disclaimer: I work for DataVeil.

Answer 2

In addition to data masking, you should look into using synthetic data as an alternative for testing and development using databases that contain sensitive information. It's a relatively new approach that's under active research, so there aren't many production ready tools available. You can find a good general lit review of the latest research here: https://doi.org/10.31228/osf.io/bfqh3

Full disclosure, I work for a company that's commercializing this technology (http://tonic.ai). Please reach out if you have any questions, happy to give you a overview of how to get started with synthetic data.