Data Mask Studio vs Jailer

Data Mask Studio is a free Windows desktop application for masking sensitive data in CSV files and local HTML content. Users can choose columns to preserve, mask, or exclude; normalize, rename, or compose columns; and reuse profiles for batch work. CSV files can be processed individually or in batches, with selective restoration available later. Its deterministic tokens can keep repeated values consistent across records and files. The app can also restore known codes in local HTML files and dashboards while preserving their markup. Original values and mappings remain in an encrypted local vault, which is needed for restoration. The maker says tokens use HMAC-SHA256, vault data uses AES-256-GCM, and Windows DPAPI protects local keys. Processing stays local, without telemetry or automatic synchronization. Additional tools include password-protected portable backups, vault integrity audits, diagnostics, temporary-file cleanup, and controlled compaction. Large files use bounded-memory streaming. Releases offer a per-user Windows installer and portable ZIP. The app is licensed under GPL-3.0-only. It does not guarantee irreversible anonymization, and its executables are not digitally signed yet, so Windows may show a SmartScreen warning.

Jailer is a free database tool for creating small data slices that retain referential integrity and for exploring data through table relationships. The project describes test datasets and investigating local problems using relevant production data as intended uses. It can export topologically sorted SQL, JSON, YAML, XML, and DbUnit datasets. The Data Browser follows foreign-key or user-defined relationships between tables in either direction. Its SQL Console includes code completion, syntax highlighting, database metadata visualization, and interactive charts with 11 chart types. AI features support natural-language database subsetting, SQL generation, and assistance analyzing, explaining, and refactoring queries. The AI Query Assistant supports Anthropic or OpenAI-compatible APIs, with examples including OpenAI, Azure, Groq, Ollama, and OpenRouter. Jailer uses JDBC and lists support features for databases including PostgreSQL, Oracle, MySQL, SQL Server, SQLite, Redshift, Snowflake, and ClickHouse. Liquibase integration can generate DDL scripts for database objects. The API provides programmatic data import and export through the Subsetter and Importer classes. It is available for Linux, macOS, and Windows under Apache License 2.0.