{"repo":"ppomes/myanon","free":true,"listed":false,"github":"https://github.com/ppomes/myanon","clone":"git clone https://github.com/ppomes/myanon.git","description":"A mysqldump anonymizer","language":"C","stars":124,"topics":["mysqldump","anonymizer","database-anonymizer","rgpd","anonymization","mysql","obfuscator","anonymize","sql","bison"],"license":null,"category":"databases-storage","readme_excerpt":"Myanon Fast MySQL dump anonymizer. - Deterministic hashing : built-in HMAC-SHA256 rules always produce the same output for the same input -- foreign key relationships are preserved automatically - Fast : processes dumps as a stream with zero intermediate storage - JSON-aware : built-in parser for anonymizing fields inside JSON columns - Extensible : optional Python support for custom anonymization logic (e.g. Faker) Quick demo Config ( myanon.conf ): Run : Before (original dump): After (anonymized dump): Referential integrity is preserved: if bob.johnson@corp.com appears in another table with the same emailhash rule, it produces the same anonymized value. Features Rule Description ------ ------------- texthash N Hash text value to N hex chars (up to 32) inthash N Hash integer value to N digits (up to 32) emailhash 'domain' N Hash email, N chars total, with given domain fixed 'value' Replace with a constant (supports quoted / unquoted modifiers) fixed null Replace with NULL key Mark a column as the key for appendkey / prependkey references appendkey 'prefix' / prependkey 'suffix' Deterministic value tied to the row's key column appendindex 'prefix' / prependindex 'suffix' Value tied to the row's position (1-based) substring N Truncate the field value to the first N characters json { path 'x.y' = ... } Anonymize specific paths inside JSON columns (supports nested objects and arrays with [] ) truncate Drop all data from a table (removes INSERT/UPDATE statements) pydef 'func' or ","default_branch":null,"files":null,"tree":[],"storefront":"/r/ppomes","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ppomes/myanon/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."}