GUI tools for Apache Derby

Graphical user interface (GUI) tools consist of an interface that includes visual components such as buttons or icons, through which the user interacts with electronic devices. The biggest advantage of graphical user interface is an improvement in usability for the average person. It gives the ability to perform various tasks on an electronic device, without any programming knowledge.

Aqua Data Studio Entity Relationship Modeler

The Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps you design physical database models for all major RDBMS vendors and versions. It uses the forward engineer feature to model entities and the reverse engineer feature to visualize a database model from existing databases. Besides that, the schema compare tool functionality within the ER Modeler allows comparing ER models.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: Yes
Reverse enginering: Yes

Visual Paradigm

Visual Paradigm offers ERD software, a database design tool that provides graphical representation of database tables, their columns and inter-relationships. With Visual Paradigm's ERD tool, you can edit database view in a visual editor.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: Yes
Reverse enginering: Yes

DataGrip

DataGrip is a database IDE that is tailored to suit the specific needs of professional SQL developers. It offers database diagram support that lets you graphically show the structure of the database and relations between database objects. You can generate a diagram for a data source, a schema, or a table.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: No
Reverse enginering: Yes

RazorSQL

RazorSQL is a software application that provides both easy to use visual tools and advanced features to allow users to do database browsing, editing, management, administration, and programming.

Desktop/Cloud: Desktop
Free edition: No
Schema design: No
Commercial: Commercial
Forward engineering: No
Reverse enginering: No

DbSchema

DbSchema is a universal database designer and GUI tool that provides a diagram-oriented database designer for relational and No-SQL databases. Using DbSchema, you will interact with the database using the mouse. Even if you are not an SQL expert, you will be able to create new tables, columns, or foreign keys, explore the data from multiple tables, create reports or generate test data.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: No
Reverse enginering: Yes

DbVisualizer

DbVisualizer is a smart and powerful database tool aimed to simplify database development and management for database administrators and developers. It lets you create and manage the database visually. Generate SQL code by drag & drop and copy & paste it into other applications.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: Yes
Reverse enginering: Yes

SQuirreL SQL

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands, etc.

Desktop/Cloud: Desktop
Free edition: Yes
Schema design: Yes
Commercial: Free
Forward engineering: No
Reverse enginering: Yes


The key feature of GUI tools is to present system resources, in graphical objects, that are easy to find, understand and use. Through these elements users have an easy access to interact with and manipulate available functions. They allow us to speed up the most frequent tasks in the easiest and most accessible way.

We prepared simple data modeling tools as well as more advanced GUI tools for visually designing and managing databases.