Jailer

Database Subsetting and Relational Data Browsing Tool.

What is Jailer?

Database Subsetting and Relational Data Browsing Tool.

Overview of Jailer

What it is

Jailer is a free and open source database tool for subsetting and relational data browsing. It extracts small, consistent, and referentially intact slices of production databases as SQL, JSON, YAML, XML, or DbUnit records. It also provides a Data Browser for navigating through databases by following foreign keys or user-defined relationships. It works with any database that has a JDBC driver, with dedicated support for PostgreSQL, Oracle, MySQL, MariaDB, SQL Server, Db2, SQLite, and others.

Key features

  • Subsetter: Exports referentially intact row-sets from production databases and imports them into development/test environments.
  • Data Browser: Bidirectional navigation through databases following foreign-key-based or user-defined relationships.
  • SQL Console: Includes code completion, syntax highlighting, charts, pivot tables, and AI assistance.
  • AI Subsetting Assistant: Describe in natural language what data to subset; AI generates subject table, WHERE condition, and association restrictions.
  • AI Query Assistant and Advisor: Generate SQL from natural language questions using Anthropic or OpenAI-compatible APIs; analyze, explain, and refactor existing SQL queries.
  • Generates topologically sorted SQL-DML, hierarchically structured JSON, YAML, XML, and DbUnit datasets.
  • Includes a demo database for immediate evaluation without configuration.

Use cases

  • Creating small, consistent samples of test data from production databases.
  • Local problem analysis with relevant production data.
  • Removing and archiving obsolete data while maintaining referential integrity.
  • Browsing and exploring database relationships for analysis or debugging.

Getting started

git clone https://github.com/Wisser/Jailer.git cd Jailer ant Alternatively, download the installer for Windows (.msi) or Linux (.deb) from the latest release, or the zip for any platform with Java. Start Jailer and open the included demo database.

License and pricing

Jailer is licensed under Apache-2.0 and is open source. It is free to use.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/wisserjailer.svg)](https://yunodb.com/tools/wisserjailer?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/wisserjailer?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/wisserjailer.svg" alt="Featured on YunoDB" height="20"></a>