{"repo":"Wisser/Jailer","free":true,"listed":false,"github":"https://github.com/Wisser/Jailer","clone":"git clone https://github.com/Wisser/Jailer.git","description":"Database Subsetting and Relational Data Browsing Tool.","language":"Java","stars":3195,"topics":["database","subsetting","frontend","export","extract","sql","jdbc","testing","java","subsetter"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Jailer Database Tool Jailer is a tool for database subsetting and relational data browsing. - The Subsetter creates small slices from your database (consistent and referentially intact) as SQL (topologically sorted), DbUnit records or XML. Ideal for creating small samples of test data or for local problem analysis with relevant production data. - The Data Browser lets you navigate through your database following the relationships (foreign key-based or user-defined) between tables. https://user-images.githubusercontent.com/861721/142761281-299bddc4-eea7-4f26-8c24-54fccb31b152.mp4 More Videos Features - Exports consistent and referentially intact row-sets from your productive database and imports the data into your development and test environment. - Improves database performance by removing and archiving obsolete data without violating integrity. - Generates topologically sorted SQL-DML, hierarchically structured JSON, YAML, XML and DbUnit datasets. - Data Browsing. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. - SQL Console with code completion, syntax highlighting, charts and database metadata visualization. - AI Subsetting Assistant. Describe in natural language what data to subset. The AI generates the subject table, WHERE condition, and association restrictions. - AI Query Assistant and Advisor. Generate SQL from natural language questions using Anthropic or OpenAI-compatible APIs with smart table selection for","default_branch":null,"files":null,"tree":[],"storefront":"/r/Wisser","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Wisser/Jailer/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}