Jailer vs SDSA

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.

SDSA is a free, AGPL-3.0 self-hostable application for sanitizing tabular data before it leaves a trusted environment. It accepts CSV, delimited TXT, single-table SQL INSERT dumps, JSON records, and XML records through a browser interface or REST API. SDSA infers schemas and flags likely sensitive fields such as emails, phone numbers, card numbers, government IDs, dates of birth, names, and addresses. Transformations include masking, HMAC hashing, tokenization, redaction, dropping, numeric binning, date or string truncation, and bounded Laplace noise. Users can enforce k-anonymity for selected quasi-identifiers and measure or enforce l-diversity for sensitive cleartext attributes. The app exports sanitized CSV plus JSON and Markdown privacy reports with utility summaries. A headless command-line pipeline supports CI/CD and data pipelines. Sessions use in-memory storage for a default 30 minutes. Docker and Python installation are documented.