d18n
is a numeronym short for "data-desensitization", sounds like "d-eighteen-n".
As its name says, d18n can mask data to make it desensitized. In addition, d18n can do many other things.
- d18n is a portable RDBMS cmd client. e.g., MySQL, PostgreSQL, Oracle, SQL Server ...
- save query result into a file, e.g.,
xlsx
,csv
,txt
,sql
,html
,json
... - detect sensitive info (like PII) from a file or a SQL query.
- import data from files into different types of databases.
- lint data file, to check if its format is compatible before import it into some database.
It can be used as a portable cmd client or imported as a package by other tools.
For more details and latest updates, see doc and release notes.
d18n develop with Golang 1.16+, please install first.
git clone https://github.com/LianjiaTech/d18n
cd d18n
# Mac or Linux
make build
# Windows
go build -o d18n.exe cmd\d18n\d18n.go
Golang support many
~ $ make release
...
~ $ ls release
d18n.darwin-amd64 d18n.darwin-arm64 d18n.linux-amd64 d18n.windows-amd64
Simple Example
~ $ d18n --defaults-extra-file test/my.cnf --query "show databases"
+--------------------+
| DATABASE |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| test |
| world_x |
+--------------------+
d18n is under the Apache 2.0 license. See the LICENSE file for details.