Jailer
Jailer is an open source database subsetting and schema masking tool for relational databases. It extracts consistent, referentially intact row-sets from relational databases and generates data subsets for database tests or demos. It also masks existing data sets for sharing.
data-masking
data-anonymization
data-subsetting
database-testing
Jailer: Open Source DB Subsetting & Schema Masking Tool
Extract consistent row-sets and generate data subsets for tests or demos, while masking existing datasets for sharing.
What is Jailer?
Jailer is an open source Java application that allows users to securely subset, export, and mask production databases for development, testing, sharing, and data masking purposes. Some key features of Jailer include:
- Exports consistent row sets with referential integrity from a relational database
- Provides data masking functionality for sensitive data
- Generates data subsets with foreign key constraints intact
- Works with all major relational databases like Oracle, DB2, SQL Server, MySQL, etc.
- Lightweight, fast, and database independent
- Exports data in formats such as CSV, SQL, XML
- Free and open source under the MIT license
Jailer makes it easy for developers and testers to safely work with anonymized subsets of a production database. This helps improve quality by enabling testing against real-world data without exposing sensitive information. The data subsets generated by Jailer contain consistent, referentially intact rows that accurately represent the complete database schema.
Jailer Features
Features
- Database subsetting
- Schema masking
- Extracts referentially intact row-sets
- Generates data subsets for testing/demos
- Masks existing data for sharing
Pricing
- Open Source
Pros
Open source
Works with many databases
Simple and easy to use
Good for GDPR compliance
Exports subsets into various formats
Cons
Limited to relational databases
Basic UI
Lacks some advanced features of commercial tools
Requires learning SQL
Not ideal for very large databases
Official Links
The Best Jailer Alternatives
Top Development and Database Tools and other similar apps like Jailer
Here are some alternatives to Jailer:
Suggest an alternative ❐
MySQL Workbench
MySQL Workbench is a visual database design tool developed by Oracle that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system.Key features include:Visual database design and modeling with integrated SQL development for MySQL databasesSupport for reverse and forward engineering...
HeidiSQL
HeidiSQL is a popular free and open source database management tool for Windows that allows you to manage MySQL, MariaDB, Microsoft SQL Server and PostgreSQL databases. It provides a simple and intuitive graphical user interface for database administration tasks.Some key features of HeidiSQL include:Intuitive browser-style interface for browsing database objects...
PhpMyAdmin
phpMyAdmin is a free and open source administration tool written in PHP that allows users to manage MySQL and MariaDB databases through a web interface. Some key features include:Intuitive web interface to perform database operations like creating and editing databases, tables, fields, relations, indexes, users, permissions etc.Import and export functionality...
Navicat
Navicat is a powerful graphical database administration tool used for database development and administration. It allows you to connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL and SQLite databases, build queries, design database structures, transfer data between databases, and manage other database operations.Key features of Navicat include:Visual database designer for...
Oracle SQL Developer
Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle databases. It offers a rich set of features including:A SQL Worksheet with advanced features like syntax highlighting, auto-complete, hints, and smart code completion to improve productivity of database developers and database administrators.A DB...
DbVisualizer
DbVisualizer is a versatile all-in-one database tool for developers, analysts, and DBAs. It allows you to easily manage and administer databases via a clean graphical user interface rather than complex command-line statements.Key features include:Support for all major databases: Oracle, SQL Server, MySQL, PostgreSQL and moreIntuitive interface to browse, edit, and...
SQuirreL SQL
SQuirreL SQL is an open source graphical SQL client that allows users to view and query databases. It provides a simple interface for working with databases, allowing users to connect to a variety of database systems like MySQL, Oracle, PostgreSQL, SQL Server, and others. Some key features of SQuirreL SQL...
SeeQL
SeeQL is an open-source graphical user interface (GUI) that enables users to visually explore and query databases without writing code. It supports major relational databases including MySQL, PostgreSQL, SQLite, SQL Server, and more.Some key features of SeeQL include:Visual query builder - Construct SQL queries by dragging and dropping tables/columns without...
