nxs-data-anonymizer 1.6.0 has been released — a tool for anonymizing PostgreSQL and MySQL/MariaDB/Percona database dumps. The tool is written in Go and is released under the Apache License 2.0.
The utility supports data anonymization based on templates and functions from the Sprig library. Nxs-data-anonymizer can be used via unnamed pipes in the command line to redirect dumps from the source database directly to the target database with the necessary transformations. There is functionality to handle 'null' values through a function in filters. A -l/—log-format command has been implemented to select the logging format (json or plain). The anonymization process can be indexed — progress information will be output at specified intervals. Thanks to external commands added in the column value 'type: command,' field values can be set.
The new version introduces a feature that allows you to activate the safe mode of nxs-data-anonymizer, in which all explicitly undefined data will be excluded from the resulting dump. Depending on the type of entities in the security settings, the tool anonymizes columns for tables with rules described in the filters section. If the table has no rules, the data will still be safe, as the anonymizer will not include them in the resulting dump.
Original information in the columns will appear in the output only if the table name is specified in security.exceptions.tables. Thus, dynamically evolving projects with frequently changing database structures will be protected even if the developer forgets to adjust the anonymizer's configuration file.
Source: opennet.ru
