{"repo":"kibitan/masking","free":true,"listed":false,"github":"https://github.com/kibitan/masking","clone":"git clone https://github.com/kibitan/masking.git","description":"Command line tool for generating anonymized database for MySQL/MariaDB","language":"Ruby","stars":124,"topics":["ruby","mysql","database","command-line-tool","mariadb","gdpr","rdbms"],"license":"MIT","category":"databases-storage","readme_excerpt":"MasKING🤴 The command line tool for anonymizing database records by parsing a SQL dump file and build a new SQL dump file with masking sensitive/credential data. Design Concept KISS keep it simple, stupid No connection to the database, No handling files, Only dealing with stdin/stdout. Do One Thing and Do It Well inspired by Unix Philosophy. No External Dependency Depend on only pure language standard libraries, no external libraries Quality of Code Heavily inspired by TDD. please see detail in presentation below. Presentation / Demo demo / slide: Generate anonymised database with MasKING Installation Requirement Ruby 2.6/2.7/3.0/3.1/3.2/3.3 Supporting RDBMS MySQL: 5.7, 8.0, 8.1 MariaDB: 10.2 1 , 10.3 1 , 10.4, 10.5, 10.6, 10.7 1 , 10.8 1 , 10.9 1 , 10.10, 10.11, 11.0, 11.1 Usage 1. Setup configuration for anonymizing target tables/columns to masking.yml NOTE: the columns which doesn't mention here will be NOT anonymized, it stays as it is. A value will be implicitly converted to a compatible type. If you prefer to explicitly convert, you could use a tag as defined in YAML Version 1.1 String should be matched with MySQL String Type. Integer/Float should be matched with MySQL Numeric Type. Date/Time should be matched with MySQL Date and Time Type. NOTE: MasKING doesn't check actual schema's type from the dump. If you put incompatible value it will cause an error during restoring to the database. 1. Dump database with anonymizing MasKING works with mysqldump --complete-insert 1","default_branch":null,"files":null,"tree":[],"storefront":"/r/kibitan","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/kibitan/masking/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."}