Relational Database Document Exporter & Mock Data Builder (CLI)
The Problem
Developers frequently require realistic test databases that preserve complex foreign-key relationships. However, utilizing actual production databases violates data privacy compliance mandates (e.g., GDPR, HIPAA, PCI-DSS).
The Complexity
High. This utility crawls real relational database schemas, masks identifiable fields using localized generation seed lists, and outputs a perfectly structural, relational mock SQL dump file for local engineering pipelines.
Core Features
* Schema Crawling: Automated foreign key and dependency graph discovery.
* Deterministic Masking: Masking sensitive data while ensuring the same input yields the same mock value across tables to preserve relational integrity.
* SQL Dump Generation: Seamless, syntactically correct SQL output containing structured mock inserts.
Installation & Usage
Prerequisites
* Python 3.9 or higher
Quick Start
1. Run the appropriate setup script for your platform (`setup.sh` or `setup.bat`).
2. Activate your virtual environment:
* Linux/MacOS: `source venv/bin/activate`
* Windows: `.\venv\Scripts\activate`
3. Initialize a default configuration file:
`python -m src.main –init-config`
4. Execute the mock generation pipeline:
`python -m src.main –config config/default_config.json –output mock_dump.sql`
Configuration Matrix
Modify `config/default_config.json` to define target tables, seeding densities, and specific column masking rules (e.g., changing `email` columns to use the `email` seed list).
$159.00Add to cart