{"id":16615,"library":"dbsafedump","title":"DBSafeDump CLI Tool","description":"DBSafeDump is a command-line interface (CLI) tool designed for securely dumping and anonymizing database data to ensure compliance with privacy regulations like GDPR. Currently at version 1.0.4, the package enables users to export databases with automatic sensitive data masking, migrate data between environments while anonymizing, and even scrub existing databases in-place. Its key differentiators include deterministic masking for consistent test data, support for multiple database types (MySQL, PostgreSQL, MSSQL, SQLite), and intelligent discovery of sensitive columns. It operates on a freemium model, with a free tier limited to 1,000 rows per table and paid tiers offering advanced features like unlimited rows, in-place scrubbing, and CI/CD integration. The tool is developed with a focus on automation and integration into CI/CD pipelines, requiring Node.js 18+ for execution. While the free tier works offline, paid licenses require periodic online verification through a device fingerprint.","status":"active","version":"1.0.4","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","database","anonymization","dump","masking","gdpr","privacy"],"install":[{"cmd":"npm install dbsafedump","lang":"bash","label":"npm"},{"cmd":"yarn add dbsafedump","lang":"bash","label":"yarn"},{"cmd":"pnpm add dbsafedump","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"DBSafeDump is a CLI tool; its primary functionality is accessed via global installation or npx commands, not programmatic imports.","wrong":"import { dump } from 'dbsafedump'","symbol":"dbsafedump dump","correct":"dbsafedump dump -o backup.sql"},{"note":"Configuration is managed through an interactive CLI wizard initiated by the 'init' command, not through library calls.","wrong":"require('dbsafedump').init()","symbol":"dbsafedump init","correct":"dbsafedump init"},{"note":"The 'scrub' command, for in-place anonymization, is also a CLI-exclusive function and is destructive. Use with caution.","wrong":"DBSafeDump.scrubDatabase()","symbol":"dbsafedump scrub","correct":"dbsafedump scrub --ci"}],"quickstart":{"code":"npm install -g dbsafedump\n\ndbsafedump init\n# Follow interactive prompts to configure database connections\n\ndbsafedump test-connection\n# Verify database connection\n\ndbsafedump dump -o anonymized_data.sql\n# Dumps the configured database with anonymization to a SQL file","lang":"bash","description":"This quick start demonstrates global installation, initial configuration, connection testing, and performing a basic database dump with anonymization."},"warnings":[{"fix":"Always ensure you have a full backup of your database before running the `scrub` command on any environment, especially production.","message":"The `scrub` command performs in-place anonymization directly on your database. This is a destructive and irreversible operation that permanently alters data.","severity":"breaking","affected_versions":">=1.0.0"},{"fix":"Upgrade to a STARTER or PRO license to remove the row limit. Check `dbsafedump.com/pricing` for details.","message":"The FREE tier of DBSafeDump is limited to 1,000 rows per table. Operations exceeding this limit will fail until a paid license is activated.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Ensure your Node.js environment is updated to version 18 or higher. Use a version manager like `nvm` if managing multiple Node.js versions.","message":"DBSafeDump requires Node.js version 18 or newer to run. Using older versions will result in execution errors.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Be aware of this privacy implication and ensure network connectivity for paid license verification. The FREE tier works offline without license checks.","message":"Paid DBSafeDump licenses (STARTER/PRO) require periodic online verification. This process collects a hashed device fingerprint locally for license activation and verification, sending only the encrypted key to the server.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"last_verified":"2026-04-22T00:00:00.000Z","next_check":"2026-07-21T00:00:00.000Z","problems":[{"fix":"Purchase and activate a STARTER or PRO license, or filter your data to stay within the 1,000-row limit for free usage.","cause":"Attempting to dump or import more than 1,000 rows per table using the FREE tier.","error":"Error: Row limit exceeded. Please upgrade to a paid plan."},{"fix":"Execute `dbsafedump init` to create the default `config.yml` and configure your database connections interactively.","cause":"DBSafeDump commands were run without an initialized configuration file.","error":"Error: Configuration file 'config.yml' not found. Run 'dbsafedump init'."},{"fix":"Update your Node.js installation to version 18 or newer. Consider using `nvm` (Node Version Manager) to manage different Node.js versions.","cause":"The installed Node.js version on your system is older than the required minimum of 18.","error":"Error: Node.js version x.y.z is not supported. Please use Node.js >=18."},{"fix":"Verify your license key for typos and ensure it is valid and active. If issues persist, contact DBSafeDump support.","cause":"An incorrect or expired license key was entered during activation.","error":"Error: Invalid license key provided. Please check your key and try again."}],"ecosystem":"npm"}