Jailer is a database tool for making smaller data samples that preserve referential integrity and for navigating data through relationships between tables. 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. Its Data Browser follows foreign-key-based or user-defined relationships in either direction, while the SQL Console provides code completion, syntax highlighting, database metadata visualization and interactive charts with 11 chart types. AI features support natural-language database subsetting and SQL generation, as well as analysis, explanation and refactoring of SQL 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. It also has Liquibase integration for generating DDL scripts and programmatic import and export through Subsetter and Importer classes. Jailer is free under the Apache License 2.0.
Who it is for
Jailer suits people who need smaller relationally intact database samples, want to explore links between tables, or need programmatic import and export. Its project describes test data creation and local problem analysis as intended uses.
What is good
- Creates smaller samples that retain referential integrity.
- Exports to SQL, JSON, YAML, XML and DbUnit.
- Data Browser follows table relationships both ways.
- SQL Console includes charts with 11 chart types.
- Free under Apache License 2.0.
What to know first
- AI Query Assistant requires an Anthropic or OpenAI-compatible API.
- No security certification or compliance claims are stated.
Verdict
Jailer combines data subsetting, table browsing, SQL tools and several export formats in a free database utility. Check its listed database support and the AI API requirement for your workflow.
Jailer plans and pricing
All plansCompared on data masking software
- Free plan
- Yes
- Masking methods
- static
- Referential integrity
- Yes
- Deployment options
- on-premises
- Data subsetting
- Yes
- API access
- Yes
