A command-line tool to anonymize and transform sensitive data in databases, files, and datasets without writing a single line of code. Supports various databases types and file formats.
# npm
npx datazar-cli <command> [options]
# pnpm
pnpm dlx datazar-cli <command> [options]
# yarn
yarn dlx datazar-cli <command> [options]
Mask firstName
column in users
table in test
db:
npx datazar-cli anon-col postgres \
--uri postgresql:/localhost \
--database test \
--table users \
--column firstName \
mask
// { "firstName": "John" } => { "firstName": "****" }
Scramble lastName
column in users
table in test
db:
npx datazar-cli anon-col mongo
--uri mongodb://localhost \
--database test \
--table users \
--column lastName \
scramble
// { "lastName": "Smith" } => { "lastName": "hSmti" }
Mask firstName
column in users
table in dev.db
:
npx datazar-cli anon-col sqlite \
--uri /home/dev.db \
--table users \
--column firstName \
mask
Fake email
column in file.csv
with a fake one:
npx datazar-cli anon-col csv \
--file /home/file.csv \
--column email \
fake email
- π Mask - Masks some or all of the letters of the previous value.
- π Scramble - Scrambles the order of characters inside a string randomly.
- π Fake - Generate fake data instead of the previous value
Coming Soon:
- 𧽠Remove - removes the entire data
- ποΈ Constant β Substitutes sensitive words or phrases with placeholders or predefined values.
- π Hash β Replaces the value with a cryptographic hash, making it irrecoverable.
- π Blur β Adds random variation to numerical values while keeping them within a reasonable range.
- MongoDB
- PostgresSQL
- MariaDB
- MySQL
- MSSQL
- SQLite
- Neo4J (Coming Soon)
- DynamoDB (Coming Soon)
- Redis (Coming Soon)
- CouchDB (Coming Soon)
- CSV
- JSON (Coming Soon)
- XML (Coming Soon)
- XSLX (Coming Soon)
- Parquet (Coming Soon)
- YAML (Coming Soon)
Anonymize a single column in a table
Usage: anon-col <engine> [engine_options] <anonymizer> [anonymizer_options]
DataZar Copyright (C) 2024 Nitzan Ohana
This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details.
You should have received a copy of the GNU Affero General Public License along with this program. If not, see http://www.gnu.org/licenses/.