# Wisser/Jailer

Database Subsetting and Relational Data Browsing Tool.

Repository: https://github.com/Wisser/Jailer
Canonical: https://ross.abutalabs.com/products/jailer
Homepage: https://wisser.github.io/Jailer
Language: Java
License: Apache-2.0
License Family: permissive
Topics: database, subsetting, frontend, export, extract, sql, jdbc, testing, java, subsetter, db2, gui, jailer, mssql, mysql, oracle, postgresql, redshift, sqlserver
Last push: 2026-08-26T17:14:29+00:00

## Health v2 (maintenance only)
Score: 99/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 99, release rhythm 98, longevity 100
- inputs: {"age_days": 5553, "days_push": 7, "days_rel": 14, "gap_med": 16, "n_releases_24m": 32}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3194, forks 143 (observed 2026-08-28T04:07:48.274952+00:00)

## What it is
Jailer is a Java-based tool for database subsetting and relational data browsing. It extracts small, referentially intact slices of production databases for testing and analysis, and provides a GUI data browser plus SQL console with AI-assisted query features.

## Use cases
- create small consistent test data subsets from a production database
- export referentially intact database slices as SQL or DbUnit datasets
- browse database tables by following foreign key relationships
- archive obsolete data without violating referential integrity
- generate SQL from natural language questions
- analyze and refactor existing SQL queries with AI assistance
- analyze a production bug locally with relevant data

## When to choose
- you need small, referentially intact database samples for development or testing
- you work with JDBC-supported databases like PostgreSQL, Oracle, MySQL, or SQL Server
- you want to visually navigate relationships between database tables
- you need to export data as topologically sorted SQL, JSON, YAML, XML, or DbUnit

## When to avoid
- you need a lightweight scriptable-only ETL pipeline without a GUI
- your database has no JDBC driver
- you need real-time data replication or synchronization rather than one-off subsetting

## Facets
- artifact type: application
- maturity: active
- function: database, etl, data-generation, testing, gui, cli
- domain: databases, developer-tools, testing
- platform: jvm, cross-platform, cli
- tags: database-subsetting, jdbc, data-browsing, test-data, sql-export, dbunit, referential-integrity, data-archiving, ai-assistant, data-engineering, desktop

## Member repositories
- Wisser/Jailer (main) score 99

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:48.274952+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T07:24:54.218480+00:00, confidence not recorded.
  - readme: https://github.com/Wisser/Jailer (fetched 2026-08-28T04:07:48.274952+00:00, sha 8cd98a4e1a32)
  - homepage: https://wisser.github.io/Jailer (fetched 2026-08-29T09:38:36.223069+00:00, sha 6e6dcff1756d)
- Data as of 2026-08-30T08:39:29.467469+00:00.