Data modeling tools

List of data modeling and database design tools.

X-TEA Modeler

X-TEA Modeler helps you write models and plans of enterprise systems. Its editor helps you to write specifications of tables, functions, and also to create/alter tables in your database.

Desktop/Cloud: Desktop
Commercial: Free
Free edition: Yes
ER Diagram: Yes
Runs on: (for desktop): Windows
Forward engineering: No
Reverse enginering: No
Synchronization: -

Archi

Archi is an open-source modeling toolkit to create ArchiMate models and sketches. It is targeted toward all levels of enterprise architects and modelers. The ArchiMate® modeling language is an open and independent Enterprise Architecture standard that supports the description, analysis and visualization of architecture within and across business domains.

Desktop/Cloud: Desktop
Commercial: Free
Free edition: Yes
ER Diagram: Yes
Runs on: (for desktop): Linux,Mac OS,Windows
Forward engineering: No
Reverse enginering: No
Synchronization: -

WinA&D

WinA&D is a comprehensive tool for system analysis, requirements management, structured analysis and design, object-oriented modeling with UML and data modeling of information systems. With WinA&D, dynamic systems can be modeled, parameterized, simulated and charted. The tool provides requirements specification and traceability, design verification reports and text import/export features.

Desktop/Cloud: Desktop
Commercial: Commercial
Free edition: Yes
ER Diagram: Yes
Runs on: (for desktop): Mac OS,Windows
Forward engineering: Yes
Reverse enginering: Yes
Synchronization: -

Hackolade

Hackolade is a tool for Agile visual data modeling and provides graphic visualization of complex data structures using Entity-Relationship diagrams to represent denormalized data in a user-friendly way. Hackolade is specifically designed to handle the powerful nature of nested objects, denormalization, and polymorphic semi-structured schemas.

Desktop/Cloud: Desktop
Commercial: Commercial
Free edition: No
ER Diagram: Yes
Runs on: (for desktop): Linux,Mac OS,Windows
Forward engineering: Yes
Reverse enginering: Yes
Synchronization: -

dbForge Studio for MySQL

dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database development, management, and administration. The IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface.

Desktop/Cloud: Desktop
Commercial: Commercial
Free edition: No
ER Diagram: Yes
Runs on: (for desktop): Windows
Forward engineering: Yes
Reverse enginering: Yes
Synchronization: Yes

ERBuilder Data Modeler

ERBuilder Data Modeler allows developers to graphically design databases by using entity relationship diagrams, and automatically generates the most popular SQL databases. It also allows developers to easily deploy databases by offering a sophisticated visual data modeling environment.

Desktop/Cloud: Desktop
Commercial: Commercial
Free edition: Yes
ER Diagram: Yes
Runs on: (for desktop): Windows
Forward engineering: Yes
Reverse enginering: Yes
Synchronization: Yes

DrawSQL

DrawSQL helps dev teams create beautiful schema diagrams to document their database entity relationships. The app has a strong focus on crafting a delightful user experience, with keyboard shortcuts and a modern app design so you can create your document at the speed of thought. It currently supports MySQL, PostgresSQL and SQL server. It also has an extensive library of over 200+ database schemas of popular open-source packages, useful as inspiration when architecting a new app feature.

Desktop/Cloud: Cloud
Commercial: Commercial
Free edition: Yes
ER Diagram: Yes
Runs on: (for desktop): -
Forward engineering: Yes
Reverse enginering: Yes
Synchronization: No

Gleek.io

Gleek.io diagram maker is freemium text-to-diagram tool for developers and software architects. It is a cloud tool for model driven software development, and you can run in any browser. Gleek.io is designed to be used during software planning meetings and live collaboration, so it is vital that diagrams can be created quickly.

Desktop/Cloud: Cloud
Commercial: Commercial
Free edition: Yes
ER Diagram: Yes
Runs on: (for desktop): -
Forward engineering: No
Reverse enginering: No
Synchronization: No