Jailer review
A free, cross-platform option for intact relational subsets and SQL-based anonymization.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Jailer is an open-source tool for creating small, referentially intact subsets of relational databases. It is suited to development, testing, and local data analysis teams that need reduced datasets without breaking table relationships. The product combines database browsing, subset-by-example extraction models, exports, anonymization filters, and programmatic access in a local desktop and command-line application for Windows, macOS, and Linux. A free plan makes it relevant for teams looking to work with relational data without a paid software tier as their starting point.
Database compatibility is a central strength. Jailer supports PostgreSQL, Oracle, MySQL, MariaDB, Microsoft SQL Server, IBM Db2, SQLite, Sybase, Amazon Redshift, Firebird, Informix Dynamic Server, H2, HSQL, Derby, and Interbase. It can browse relational data through foreign-key or user-defined relationships, then export subsets as SQL, JSON, YAML, XML, or DbUnit datasets. The SQL console adds code completion and metadata visualization, while the programmatic export and import API gives teams a route to incorporate subset workflows into scripts or applications.
Jailer's masking approach is narrower than its subsetting capability. SQL-based export and import filters support replacement, partial masking, and randomized substitutions, but the published category specifications describe masking as static, and the workflow is centered on exported data. That makes Jailer a strong fit for teams that need controlled, referentially intact datasets for development, testing, or analysis. Organizations seeking a dedicated enterprise data-masking platform, broader masking workflows, or a service-oriented deployment model should consider an alternative instead.
Jailer pros and cons
- Where it wins
- Preserves referential integrity when creating database subsets
- Exports SQL, JSON, YAML, XML, and DbUnit datasets
- Supports SQL-based anonymization and programmatic export/import APIs
- Where it doesn't
- Masking is centered on export and import workflows
- Primarily targets database subsetting rather than dedicated enterprise masking
- Runs as a local desktop and command-line application
Jailer fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. We may earn a commission when you click some links. How we rank.
Last updated · How we research and update