- Home
- Data Masking Software
- Jailer
Jailer
What it is
Jailer is a free database tool for making smaller data slices that retain referential integrity and for navigating tables through their relationships. The project describes test-data samples and investigations 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 in either direction. Its SQL Console includes code completion, syntax highlighting, database metadata views, and interactive charts with 11 chart types. AI features support natural-language subsetting, SQL generation, and assistance analyzing, explaining, or refactoring queries. The AI Query Assistant works with Anthropic or OpenAI-compatible APIs, with examples including OpenAI, Azure, Groq, Ollama, and OpenRouter. Jailer uses JDBC and lists support features for PostgreSQL, Oracle, MySQL, SQL Server, SQLite, Redshift, Snowflake, and ClickHouse. Liquibase integration can generate DDL scripts, and the Subsetter and Importer classes provide programmatic data export and import. The project is licensed under Apache License 2.0.
For and against
For
- Free under Apache License 2.0
- Creates referentially intact data slices
- Exports SQL, JSON, YAML, XML, and DbUnit
- SQL Console includes 11 chart types
- Offers AI-assisted SQL and subsetting
Against
- Listed deployment option is on-premises
- AI Query Assistant requires compatible APIs
- No security certification or compliance claim is stated
The verdict
Jailer combines data subsetting, relationship browsing, exports, and SQL tools, with AI assistance available through compatible APIs. Its listed deployment option is on-premises, and the project does not state security certifications or compliance claims.
Who it suits
Jailer suits database users who need smaller, relationally intact datasets for testing or investigation. It may also fit users who want to explore table relationships or generate and work with SQL.
Plans and prices
Jailer
Apache License 2.0 · Database tool
Read 30 Sep 2026 · github.com
On the record
- AI features
- AI features include natural language database subsetting, SQL generation, and assistance analyzing, explaining, and refactoring SQL queries.wisser.github.io · read 30 Sep 2026
- AI integrations
- The AI Query Assistant supports Anthropic or OpenAI compatible APIs, with examples including OpenAI, Azure, Groq, Ollama, and OpenRouter.wisser.github.io · read 30 Sep 2026
- Database support
- Jailer uses JDBC and lists support features for databases including PostgreSQL, Oracle, MySQL, SQL Server, SQLite, Redshift, Snowflake, and ClickHouse.wisser.github.io · read 30 Sep 2026
- Data browser
- The Data Browser navigates bidirectionally through foreign key based or user defined relationships between tables.github.com · read 30 Sep 2026
- Exports
- Jailer can generate topologically sorted SQL, JSON, YAML, XML, and DbUnit datasets.wisser.github.io · read 30 Sep 2026
- Other integration
- The project says Liquibase integration can generate DDL scripts for creating database objects.wisser.github.io · read 30 Sep 2026
- Programmatic access
- The API provides programmatic access to data export and import through the Subsetter and Importer classes.wisser.github.io · read 30 Sep 2026
- Purpose
- Jailer creates small, referentially intact database slices and lets users browse data through table relationships.wisser.github.io · read 30 Sep 2026
- Security and license
- The repository contains an Apache License, Version 2.0; the pages reviewed do not state security certifications or compliance claims.github.com · read 30 Sep 2026
- SQL console
- The SQL Console includes code completion, syntax highlighting, database metadata visualization, and interactive charts with 11 chart types.wisser.github.io · read 30 Sep 2026
- Support
- The project directs users to GitHub Discussions for questions and GitHub Issues for bug reports and feature requests, and provides a legacy SourceForge forum.wisser.github.io · read 30 Sep 2026
- Use case
- The project describes creating small test data samples and analyzing local problems with relevant production data as intended uses.wisser.github.io · read 30 Sep 2026
