GUI tools

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

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

ModelSphere

Open ModelSphere is a powerful tool for business process, data, and UML modeling. It is a complete data modeling tool, that covers conceptual and logical data modeling as well as physical design, i.e., database modeling (database modeling). It supports several notations, e.g., Entity-Relationship, DATARUN, and Information Engineering. Conceptual models can be converted to relational models and vice versa.

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

SchemaSpy

SchemaSpy is a Java-based graphical database schema metadata browser tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams.

Desktop/Cloud: Cloud
Free edition: Yes
Schema design: Yes
Commercial: Free
Forward engineering: No
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

Vertabelo

Vertabelo is a database modeler that gives you the power of visual design of databases online. It provides the perfect UI to create databases quickly and easily manage tables, views, references, etc.

Desktop/Cloud: Cloud
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

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