Data modeling tools for MySQL

List of data modeling and database design tools.

Data modeling is the process of creating and analyzing data models for resources stored in a database. The Data Model is an abstract model that standardizes the data description, data semantic, and consistency constraints of data. Its main purpose is to represent the types of data within a system, the relationships between objects, and its attributes. The data model helps to understand what data is needed and how data should be organized. It is like a blueprint for an architect to better understand what is being created.

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

Tree Schema

The Tree Schema data catalog provides all of the essential catalog capabilities including rich-text documentation, data lineage, assigning data stewards and technical owners to your data assets, tagging your assets and much more. You can point Tree Schema to your database and fully populate your catalog in under 5 minutes. Tree Schema also supports non-traditional data sources including S3, Kafka and DynamoDB.

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

The wider the scope of data works in an organization, the more advanced data modeling tool is needed. The functionality spectrum of these tools can be very broad. However, the core features of these tools include: