Wisser/Jailer

Health v2 · maintenance only

Adoption not part of the score

3194 stars · 143 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

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

application · maturity active

database etl data-generation testing gui cli databases developer-tools testing jvm cross-platform cli database-subsetting jdbc data-browsing test-data sql-export dbunit referential-integrity data-archiving ai-assistant data-engineering desktop

Member repositories

For agents

markdown · JSON · MCP: product_card(name="Wisser/Jailer")