Jailer

Visit site Alternatives

Score6.9

Rank#3 of 22

PriceFree

Free planYes

Runs onAPI, Linux, macOS, Windows

Summary

Jailer is a free database tool for producing small data samples that retain referential integrity and for exploring tables through their relationships. The project describes test datasets and investigating local issues with relevant production data as intended uses. Its exports include topologically sorted SQL, JSON, YAML, XML, and DbUnit datasets. The Data Browser follows foreign-key or user-defined links between tables in either direction. In the SQL Console, users get code completion, syntax highlighting, database metadata views, and interactive charts with 11 chart types. AI features can help subset databases using natural language, generate SQL, and analyze, explain, or refactor queries. The AI Query Assistant works with Anthropic or OpenAI-compatible APIs, including examples such as Azure, Groq, Ollama, and OpenRouter. Jailer uses JDBC and lists support features for PostgreSQL, Oracle, MySQL, SQL Server, SQLite, Redshift, Snowflake, and ClickHouse. It also offers a programmatic API for import and export, and Liquibase integration for generating DDL scripts. Jailer is available for Linux, macOS, and Windows under the Apache License 2.0.

Who it is for

Jailer suits developers and database teams who need representative samples for testing or investigation while retaining table relationships. It also fits users who want to browse or query supported databases and export data in several formats.

What is good

Creates referentially intact data subsets.
Exports SQL, JSON, YAML, XML, and DbUnit.
Browses table relationships in both directions.
SQL Console includes 11 interactive chart types.
Programmatic import and export API.

What to know first

Database connectivity uses JDBC.
No security certifications or compliance claims are stated.

Verdict

Jailer combines database subsetting, relationship-based browsing, SQL tools, and multiple export formats in a free tool. Its AI Query Assistant supports Anthropic or OpenAI-compatible APIs, while deployment is on-premises.

Jailer plans and pricing

All plans

Jailer Free Apache License 2.0 · Database tool github.com · 30 Sept 2026

Compared on data masking software

Free plan: Yesgithub.com
Masking methods: staticgithub.com
Referential integrity: Yesgithub.com
Deployment options: on-premisesgithub.com
Data subsetting: Yesgithub.com
API access: Yesgithub.com

Facts

Purpose: Jailer creates small, referentially intact database slices and lets users browse data through table relationships.wisser.github.io · 30 Sept 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 · 30 Sept 2026
Exports: Jailer can generate topologically sorted SQL, JSON, YAML, XML, and DbUnit datasets.wisser.github.io · 30 Sept 2026
Data browser: The Data Browser navigates bidirectionally through foreign key based or user defined relationships between tables.github.com · 30 Sept 2026
SQL console: The SQL Console includes code completion, syntax highlighting, database metadata visualization, and interactive charts with 11 chart types.wisser.github.io · 30 Sept 2026
AI features: AI features include natural language database subsetting, SQL generation, and assistance analyzing, explaining, and refactoring SQL queries.wisser.github.io · 30 Sept 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 · 30 Sept 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 · 30 Sept 2026
Other integration: The project says Liquibase integration can generate DDL scripts for creating database objects.wisser.github.io · 30 Sept 2026
Programmatic access: The API provides programmatic access to data export and import through the Subsetter and Importer classes.wisser.github.io · 30 Sept 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 · 30 Sept 2026
Platforms: The project documents Windows installers and Linux installers, and says the platform independent archive can be run on Unix, Linux, or macOS.wisser.github.io · 30 Sept 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 · 30 Sept 2026