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

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

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

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

Toad Data Modeler

Toad Data Modeler is an easy-to-use, multi-platform data modeler. It lets you visualize database structures and better understand existing databases and relationships. Create high-quality logical and physical data models. Reverse engineer existing database structures to view them in a diagram. Generate detailed HTML, RTF or PDF reports.

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

DatabaseSpy

Altova DatabaseSpy is the unique multi-database query and design tool. The DatabaseSpy graphical Design Editor lets you view and edit the structures of all your databases through one graphical user interface. You can examine tables and relationships in an existing database, edit tables to better suit your needs, or even can add entire tables and specify all their column attributes and relationships to other tables from scratch.

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

erwin Data Modeler

erwin Data Modeler (erwin DM) is a data modeling tool used to find, visualize, design, deploy, and standardize high-quality enterprise data assets. It also automates and standardizes model design tasks, including complex queries, to improve business alignment, ensure data integrity and simplify integration.

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