GUI tools

Dataedo

Dataedo lets you visualize your data models with ER diagrams. You can discover and document relationships between data entities and visualize them with automatically built diagrams. It reads foreign key constraints from DBMS and adds table relationships to the diagram automatically.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: No
Reverse enginering: Yes
Database Web Business Glossary
Database Web Table Diagram

Retool

Retool gives you a multi-purpose, cross-platform SQL GUI so you can quickly build apps on top of your data. Connecting Retool to your SQL DB lets you run queries, inspect your schema and database objects, and auto-complete in our IDE. Manage, manipulate, and visualize your data with custom components instead of getting stuck in a CLI.

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

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

dbForge Studio

dbForge Studio offers powerful GUI tools for relational databases. It lets you visually design new databases and analyze the structure of existing ones, track logical relations between tables, export database diagrams to images, edit table data, rebuild tables, configure database options, and more.

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

DbDesigner.net

DB Designer is an online database design and modeling tool that offers a simple graphical user interface with feature-rich and powerful functionalities. Some of its key features include fast navigation, automatic sorting and layout, grid view, keyboard shortcuts, cloning, live validation, option to show/hide default values, foreign key icons, columns, indexes, etc.

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

ERDPlus

ERDPlus is a web-based database modeling tool that lets you quickly and easily create Entity Relationship Diagrams (ERDs), Relational Schemas (Relational Diagrams), and Star Schemas (Dimensional Models). It enables drawing standard ERD components. The notation supports drawing regular and weak entities, various types of attributes, and all possible cardinality constraints of relationships.

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

QuickDBD

Quick Database Diagrams (QuickDBD) is a simple online tool to quickly draw database diagrams by typing. It develops premium diagrams and let you share your diagrams online.

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

Lucidchart

Lucidchart is an all-in-one online diagram, collaboration, and visualization data platform. Its intuitive interface makes it simple to start diagramming, no matter the device, browser, or operating system. It improves the way teams work together with real-time co-authoring, in-editor chat, shape-specific comments, and collaborative cursors. It lets you overlay important metrics on existing diagrams through data linking or use auto-visualization to generate org charts, ERDs, and more.

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

DeZign for Databases

DeZign for Databases is an intuitive data modeling tool Visualize database structures to understand your database, create new databases or reverse-engineer existing databases to modify, document, analyze, and optimize. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most popular databases.

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

Navicat Data Modeler

Navicat Data Modeler lets you create, modify, and design your models using professional object designers, available for Tables and Views. It allows you to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files, and much more.

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

DBeaver

DBeaver is an open source universal database management tool that lets you view a database structure in the standard ERD (Entity Relation Diagram) form. You can view the diagrams of existing tables and whole database schemas, while it also allows the creation of custom diagrams.

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