Jailer
github.com
- Free plan
- Windows
- macOS
- Linux
- API
What Jailer is
Jailer is a free database tool for creating small data slices that preserve referential integrity and for browsing tables through their relationships. The project describes test samples and investigating local problems with relevant production data as intended uses. Exports include 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 database subsetting, SQL generation, and help analyzing, explaining, or 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 PostgreSQL, Oracle, MySQL, SQL Server, SQLite, Redshift, Snowflake, and ClickHouse. It also provides programmatic import and export through Subsetter and Importer classes, plus Liquibase integration for generating DDL scripts. Jailer is available for Linux, macOS, and Windows under the Apache License 2.0.
Who it suits
Jailer suits database users who need smaller, relationship-preserving samples for testing or investigation. Its browser, SQL tools, and import/export API may also fit developers and database professionals working across supported JDBC databases.
Good to know, and what to watch
- Creates referentially intact database slices.
- Exports SQL, JSON, YAML, XML, and DbUnit datasets.
- Browser follows table relationships in both directions.
- SQL Console includes 11 chart types.
- Available for Linux, macOS, and Windows.
- AI Query Assistant requires an Anthropic or OpenAI-compatible API.
- Database support is through JDBC.
- Support questions and bug reports go through project forums and trackers.
Plans
Every plan and priceJailer
Free plan
Getting started
- Open the Jailer GitHub project
- Install it on Linux, macOS, or Windows
- Connect a supported database through JDBC
- Use the Data Browser or SQL Console to inspect relationships
- Create a subset with the Subsetter or natural-language AI features
- Export data through the interface or API
Limits to check
Jailer is free under Apache License 2.0. The AI Query Assistant supports Anthropic or OpenAI-compatible APIs.
The Club's review
Jailer is a free, open-source database utility for developers and database teams that need smaller, related datasets or a way to follow records across tables. It is most compelling as a flexible tool for database work; teams seeking a dedicated data-masking product should compare its focus with specialist alternatives.
Overview
Jailer’s central strength is extracting compact data slices without breaking referential integrity. That makes it useful for building test samples with connected records, or for bringing relevant production data into a local investigation without carrying along an entire database. It is a database tool with static masking methods, rather than an all-purpose masking platform.
Jailer runs on-premises on Linux, macOS, and Windows, and offers API access. Its JDBC-based support includes PostgreSQL, Oracle, MySQL, SQL Server, SQLite, Redshift, Snowflake, and ClickHouse. The Apache License 2.0 is a strong fit for teams that want an open-source tool they can run in their own environment. Support is community-oriented through GitHub Discussions and Issues, with a legacy SourceForge forum also available.
Key features
Subset data and follow relationships
Jailer creates smaller datasets while preserving referential integrity, which helps keep test data useful instead of leaving related rows behind. Its Data Browser navigates both ways through foreign-key or user-defined relationships, making it practical for tracing connected records during analysis.
SQL work and exports
The SQL Console combines code completion and syntax highlighting with database metadata visualization and interactive charts in 11 chart types. For users who need to move data out of the tool, Jailer generates topologically sorted SQL, JSON, YAML, XML, and DbUnit datasets. Liquibase integration can generate DDL scripts for creating database objects, and the Subsetter and Importer classes provide programmatic access to export and import.
AI assistance
AI features cover natural-language database subsetting, SQL generation, and help 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. This makes AI assistance adaptable to several API providers, but it also means users need a compatible API setup to use those features.
Pricing
Jailer costs free under the Apache License 2.0. The free plan includes a database tool with static masking, data subsetting, referential integrity, on-premises deployment, and API access. There is no paid tier described; the trade-off is community-oriented support rather than a stated commercial support offering.
Platforms
Jailer supports Linux, macOS, and Windows, plus API access, and is designed for on-premises deployment. Its JDBC approach covers databases including PostgreSQL, Oracle, MySQL, SQL Server, SQLite, Redshift, Snowflake, and ClickHouse, giving teams across those systems a broad base for evaluating it.
Who it's for
Jailer is a strong fit for developers and database teams that need referentially intact test samples, focused local analysis of production data, or a multi-format export workflow. Its SQL console and relationship browser also suit users who move between querying and exploring connected records. Organizations that need a dedicated masking workflow or formal security certifications and compliance claims should look elsewhere or assess those requirements separately.
Pros and cons
- Pros: Referentially intact subsetting keeps related records together for more useful test datasets.
- Pros: Bidirectional relationship browsing, SQL tools, charts, and multiple export formats support both investigation and data movement.
- Pros: Apache-licensed, free, on-premises use and API access give technical teams flexibility to integrate it into their workflow.
- Cons: The product’s center of gravity is database subsetting and analysis, so it may not fit teams seeking a specialized masking product.
- Cons: AI features depend on compatible Anthropic or OpenAI-style APIs, adding a setup requirement for users who want those capabilities.
- Cons: Support is community-based, which may not meet organizations that require a commercial support channel.
Alternatives
For a broader database platform with replication and high-availability components, consider MySQL, which offers a free Community Edition. If a defined free masking allowance matters more, DataVeil has a Community License for databases up to 10GB, with free dataset and user SQL masks and premium masks up to 200,000 values per.
PostgreSQL Anonymizer is a free option for readers seeking a PostgreSQL-focused tool, with commercial support available separately. Data Mask Studio is a free, open-source Windows desktop app; Greenmask is a free open-source utility with PostgreSQL support and MySQL support in progress.
DATPROF is worth considering for projects ranging from 500GB to 100TB with a modular fixed license and custom pricing independent of database size. MOSTLY AI offers a free plan with no further limits stated. Oracle Cloud Infrastructure Secret Management is a free option for secret management.
Browse Data Masking Software for more tools in the category.
Verdict
Choose Jailer if your priority is producing compact, referentially intact datasets and pairing them with useful relationship browsing, SQL tools, and flexible exports at no cost. Its breadth and on-premises, open-source model are persuasive for database teams, but readers who need a dedicated masking workflow or commercial support should consider a specialist alternative.
The verdict
Jailer combines database subsetting, relationship browsing, SQL tools, and multiple export formats in a free Apache-licensed project. Review its listed database support and AI API requirements to see whether they match your setup.
Questions people ask
How much does Jailer cost?
Jailer is free and distributed under the Apache License 2.0.
Which operating systems are supported?
The project lists Linux, macOS, and Windows, along with API access.
Which databases can it connect to?
Jailer uses JDBC and lists PostgreSQL, Oracle, MySQL, SQL Server, SQLite, Redshift, Snowflake, and ClickHouse support features.
What can Jailer export?
It can generate topologically sorted SQL, JSON, YAML, XML, and DbUnit datasets.
Which AI services work with the Query Assistant?
It supports Anthropic or OpenAI-compatible APIs, with examples including OpenAI, Azure, Groq, Ollama, and OpenRouter.
What the maker publishes
- AI features
- AI features include natural language database subsetting, SQL generation, and assistance analyzing, explaining, and refactoring SQL queries. source
- AI integrations
- The AI Query Assistant supports Anthropic or OpenAI compatible APIs, with examples including OpenAI, Azure, Groq, Ollama, and OpenRouter. source
- Database support
- Jailer uses JDBC and lists support features for databases including PostgreSQL, Oracle, MySQL, SQL Server, SQLite, Redshift, Snowflake, and ClickHouse. source
- Data browser
- The Data Browser navigates bidirectionally through foreign key based or user defined relationships between tables. source
- Exports
- Jailer can generate topologically sorted SQL, JSON, YAML, XML, and DbUnit datasets. source
- Other integration
- The project says Liquibase integration can generate DDL scripts for creating database objects. source
- Platforms
- The project documents Windows installers and Linux installers, and says the platform independent archive can be run on Unix, Linux, or macOS. source
- Programmatic access
- The API provides programmatic access to data export and import through the Subsetter and Importer classes. source
- Purpose
- Jailer creates small, referentially intact database slices and lets users browse data through table relationships. source
- Security and license
- The repository contains an Apache License, Version 2.0; the pages reviewed do not state security certifications or compliance claims. source
- SQL console
- The SQL Console includes code completion, syntax highlighting, database metadata visualization, and interactive charts with 11 chart types. source
- 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. source
- Use case
- The project describes creating small test data samples and analyzing local problems with relevant production data as intended uses. source
Checked against the maker's pages on 30 Sept 2026.