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

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

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

Adminer

Adminer is a PHP written full-featured database management tool. It provides an enhanced user interface, higher performance, more security, and more feature sets. You can create, alter, drop, and search tables, foreign keys, columns, triggers, etc. You can list data in tables with search, aggregate, sort and limit results.

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

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

ConceptDraw DIAGRAM

ConceptDraw DIAGRAM is a very easy-to-use and intuitive database design tool for database modeling, drawing database structure, and diagramming databases. The enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, while flexible datatype mapping allows you to add and remove Target DBMS data types, including data type modifiers, and create auto-increment data types.

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

Enterprise Architect

Enterprise Architect is a visual modeling and design tool based on the OMG UML. As a multi-user graphical tool, it is designed to help enterprises built logical and physical data models. It helps individuals, groups, and large organizations to model and manage complex information effectively.

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

Model Xtractor

Model Xtractor is a software utility designed to inspect modeling for traditional or enhanced ER models, with support for most relational database platforms. It lets you hide, collapse, or minify table/view shapes. Bypass intersection tables and show conceptual many-to-many connectors between shapes.

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