Suggestions appear as you type. Use the up and down arrows to choose one and Enter to open it.

This page's audience real numbers from our own analytics — open to see them
–Visitors
–Page views
–Clicks to vendors
–Time on page
–Reading now
Clicks to vendors, by tool
  • –
Top countries
  • –
Devices
  • –

– · counted by iTechGuides's own first-party analytics, bots removed, every figure rounded down · how we count

Jailer

Free#14 of 25 in Data Masking Software

Jailer: A free, cross-platform option for intact relational subsets and SQL-based anonymization. Ranked #14 of 25 in Data Masking Software by our editors (7.9/10); pricing: Free plan; best for free teams subsetting and anonymizing relational data.

7.9/10Editor score
Visit Jailer
Jailer7.9 Visit Jailer

At a glance

  • Editor score
    7.9 / 10
  • Pricing
    Free plan
  • Best for
    Free teams subsetting and anonymizing relational data
  • Free plan
    Yes
  • Paid from
    None
  • Masking methods
    Static
  • Facts checked
    22 Sep 2026
Jailer screenshot

  • 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

Our verdict on Jailer

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 pricing

Plans Free planFree Free to use — no paid tier required for the core job.
See plans on github.com

Jailer fact sheet

Free planYes
Paid fromNone
Masking methodsStatic
Synthetic dataNot verified
Referential integrityYes
Deployment optionsOn-premises
Data subsettingYes
API accessYes
Database connectorsNot verified
DeploymentDesktop
PlatformsWindows, macOS, Linux
SupportEmail, Community, Docs
Built forSolo, Small business, Mid-market, Enterprise (editorial estimate)
Integrations20 integrations: PostgreSQL, Oracle, MySQL, MariaDB, Microsoft SQL Server, IBM Db2 …
PricingFree plan
Websitegithub.com
Facts checked22 Sep 2026

Jailer integrations

Jailer lists 20 integrations on its own site.

  • PostgreSQL
  • Oracle
  • MySQL
  • MariaDB
  • Microsoft SQL Server
  • IBM Db2
  • SQLite
  • Sybase
  • Amazon Redshift
  • Firebird
  • Informix Dynamic Server
  • H2
  • HSQL
  • Derby
  • Interbase
  • Exasol
  • SAP HANA
  • Vertica
  • Snowflake
  • ClickHouse

Alternatives to Jailer

See all Jailer alternatives →

Used Jailer? Be the first to review it

The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Jailer for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.

Write a reviewTwo minutes · verified accounts only · read by an editor before it appears

Reviews come only from verified accounts. Sign in or create an account first — your e-mail is never shown.

Your rating

0 characters · at least 80, up to 3,000

Posted from your verified account. Reviews appear after an editor reads them, usually within two working days.

Featured on iTechGuides

Featured on iTechGuides — Jailer 7.9/10

Jailer is listed in our Data Masking Software directory. Add the badge to your site — it links back to this page.

<a href="https://www.itechguides.com/products/jailer/"><img src="https://www.itechguides.com/best/badge/jailer.svg" alt="Featured on iTechGuides" width="230" height="46"></a>

Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026

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