Jailer - Database Subsetting and Browsing Tool

We have collection of more than 1 Million open source products ranging from Enterprise product to small libraries in all platforms. We aggregate information from all open source repositories. Search and find the best for your needs. Check out projects section.

Jailer - Database Subsetting and Browsing Tool

Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML.

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 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 and database metadata visualization.

http://jailer.sourceforge.net
https://sourceforge.net/projects/jailer/
https://github.com/Wisser/Jailer

Tags	database-tools database-administration administration database-front-end database-management database-gui
Implementation	Java
License	Apache
Platform	OS-Independent

Related Projects

pgAdmin - Administration and development platform for PostgreSQL

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

postgresql-admin database-admin database-tools postgresql-tools postgresql-management postgresql-gui database-management

MySQL-Front - A GUI front end for the MySQL and MariaDB database servers

Pascal

MySQL-Front is a Windows front end program for the MySQL database server. The database structure and data can be handled via dialogs or SQL commands. Import and Export in standard file formats is supported. The database server can be connected directly or via HTTP tunneling.

database-front-end adminstration tool mysql-front-end mysql-gui mariadb-gui mariadb-front-end

Chive - MySQL Data Management tool

Chive is a free, open source, web-based database management tool, designed to bring joy to web developers - with easy administration and super fast UI. It supports Repeated administration of your SQL queries by saving and re-execute them, Analyze and Optimize your queries with Profiling and lot more.

database-front-end adminstration tool mysql-admin mysql-management mysql-tool

MySQL Workbench - Visual database design tool for MySQL

MySQL Workbench is a visual database design tool. The tool is specifically for designing MySQL database. MySQL Workbench provides DBAs and developers an integrated tools for Database Design & Modeling, Query browser, Database Administration.

mysql-admin mysql-management administration tool mysql-tool

Sequel Pro - MySQL Database management for Mac

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. It gives you direct access to your MySQL databases on local and remote server. It supports Full table management including indexes and MySQL Views.

database-front-end adminstration tool mysql-front-end mysql-gui database-management

PHPMyAdmin

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

database-front-end adminstration tool mysql-admin mysql-management mysql-tool

Infobright - The Database for Analytics

Infobright combines a columnar database with our Knowledge Grid architecture to deliver a self-managing, self-tuning database optimized for analytics. Infobright eliminates the need to create indexes, partition data, or do any manual tuning to achieve fast response for queries and reports.

database non-relational column-database no-sql mysql-fork

YourSqlDba

T-Sql Database script that automate database maintenance using SQL Agent an DB Mail. Performs optimizations (index, statistics), integritry check, databases backups (complete and tx logs).

administration administration-tool backups daily-database-tasks database database-integrity dynamic-log-shipping

iSQL-Viewer - JDBC compliant database front end

Java

iSQL-Viewer is JDBC compliant database front end. It implements across multiple platforms features of the JDBC API. It does everything through a single interface. iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix.

database-front-end adminstration tool sql-client

DBeaver - Universal SQL Manager and SQL Client

Java

DBeaver is a multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. Its feature include metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.

database-tool database-management database-administration sql-client

SIDU admin GUI : MySQL PostgreSQL SQLite

SIDU is a FREE database web GUI written in PHP. Handy and powerful for MySQL + PostgreSQL + SQLite + CUBRID. SIDU is simple and easy DB tool to use! SIDU has all features you need for database admin and web development. It's a great DB admin tool! No installation need. Best database front-end web based tools, cross platform looking no further

DB Lens - Database explorer for Mac, Windows & Linux

TypeScript

DB Lens is an open-source database client that helps you to explore database, understand data relations more quickly with automatic ER diagrams, visualise and analyse internal DB metrics such as index utilisation sequential scans, slow running queries, storage and many more.

electron postgres database-management database-explorer database db boilerplate react typescript ts database-manager database-gui database-tools

HyperSQL - Java Database

Java

HyperSQL supports the widest range of SQL Standard features seen in any open source database engine. It offers a small, fast database engine which offers in-memory and disk-based tables and supports embedded and server modes. It is a relational database engine written in Java, with a JDBC driver, conforming to ANSI SQL:2008. It alsi supports transaction isolation, multiversion concurrency and ACID, Java stored procedures, Scalability and lot more.

database relational persistence relational-database in-memory-database embedded-database

CloudBeaver - Cloud Database Manager

Java

CloudBeaver is a free and open source web-based database management tool. It currently supports multiple databases: MariaDB, PestgreSQL, SQLite, Firebird, MySQL. It allows to manipulate with data like in a regular spreadsheet. It has complete features of all database management tools like Execute SQL queries, Navigate and observe database structure: schemas, tables, views indexes, View properties of database objects etc.

database-tools database-management database-admin tools mysql

RedisDesktopManager - Cross-platform GUI management tool for Redis

Redis Desktop Manager (aka RDM) — is a fast Redis database management application. It works with Amazon ElastiCache, Microsoft Azure Redis Cache and Redis Labs. It provides basic operations like View keys as a tree, CRUD keys, Execute commands via shell, List connected clients, Pub/Sub channels and Slow log commands, Import data from RDB files, Copy data between databases and lot more.

redis redis-desktop-manager database-gui redis-tools redis-gui redis-client database-management

Appsmith - Framework to build admin panels, CRUD apps and workflows for any backend

TypeScript

Appsmith is an open source framework to build admin panels, CRUD apps and workflows. It is the front end tool for any backend. Turn any datasource into an internal app in minutes. Appsmith lets you drag-and-drop components to build dashboards, write logic with JavaScript objects and connect to any API, database or GraphQL source. Load data into widgets using vanilla Javascript and transform it within moustache.

react internal-tools crud typescript spring widgets admin-dashboard workflows low-code app-builder admin-panels custom-internal database-management database-frontend

Mongo Express - Web-based MongoDB admin interface, written with Node.js and express

Javascript

mongo-express is a web-based MongoDB admin interface written with Node.js, Express and Bootstrap3. It has support to work with multiple database, GridFS support, Replication etc.

mongodb gui express-middleware admin administration collection database manage manage-mongo mongo phpmyadmin mongodb-admin mongodb-management

FlameRobin - Database Administration Tool for Firebird

FlameRobin is lightweight cross platform database administration tool for Firebird RDBMS.

sql-client database-tool firebird-client

VFront - User front-end for MySQL and PostgreSQL

VFront is a open source front-end for MySQL or PostgreSQL databases. VFront is for non-expert users capable to work safely on data using an intuitive graphic interface. It exports data modules, statistics and report management based on xml, xsl and xsl-fo protocols.

database-front-end adminstration tool mysql-front-end

MapD - The MapD Core database

MapD Core is an in-memory, column store, SQL relational database that was designed from the ground up to run on GPUs. MapD Core is the foundational element of a larger data exploration platform that emphasizes speed at scale. By taking advantage of the parallel processing power of the hardware, MapD Core can query billions of rows in milliseconds. Furthermore, by using the graphics pipelines of GPUs, MapD Core can render graphics directly from the server.

gpu database olap visualization sql machine-learning analytics column-store columnar-database