Data modeling tools

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.

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. Discover and document any data from anywhere for consistency, clarity, and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence, and analytics initiatives.

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: Yes

ER/Studio

ER/Studio provides robust logical and physical modeling and determines all data sources along with managing the transformation of data between the staging area and data warehouse. It helps to build out an enterprise data model and represent business concepts with full documentation of attributes, definitions, relationships, etc.

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

GenMyModel

GenMyModel is a modeling platform in the cloud for software architects and developers. It enables to create Archimate, BPMN, and Flowchart diagrams with ease for more efficient business processes and models.

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

MagicDraw

MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support. Cameo Data Modeler plugin for MagicDraw provides data-related modeling features. MagicDraw provides intuitive controls within a very well designed GUI which allows users to model without having to spend time learning about the controls.

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: -

RISE

RISE is a software suite for Information System Engineering. It's a tool for model driven system development, packed with features and functions needed to build your information model and to turn it into a complete information management solution.

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

Software Ideas Modeler

Software Ideas Modeler is a smart diagram software that provides software design and modeling tools through diagrammatic approach with UML, SysML, ERD, BPMN, ArchiMate, flowcharts, user stories and wireframe support.

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

Moon Modeler

Moon Modeler is a data modeling tool that lets you draw data models quickly and comfortably, create ER diagrams for databases, design nested structures, do documentation of schema design, reverse engineer, generate scripts, and more.

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

DB-Main

Rever DB-Main is an easy-to-use data modelling and data architecture platform. The tool offers powerful components rarely seen in standard data modeling tools. The main features are model neutrality, reverse engineering, methodology neutrality, programmable and extensible, short error detection/fixing cycle.

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

Enterprise Architect

Enterprise Architect is a multi-user, graphical tool designed to help enterprises built logical and physical data models. It provides complete traceability from requirements, analysis, and design models to implementation and deployment.

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: -

IBM InfoSphere Data Architect

IBM InfoSphere Data Architect is a data design solution that enables you to discover, model, relate, standardize and integrate diverse and distributed data assets throughout the enterprise. It enables information designers to create both logical and physical data model diagrams, which can be used to describe a variety of applications and systems.

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

ModelSphere

ModelSphere is an exciting and unique modeling tool that combines many features, such as business process modeling, data modeling and UML modeling, and provides a flexible model management environment. It provides complete data modeling features covering conceptual, logical and physical modeling.

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

PowerDesigner

PowerDesigner DataArchitect is the industry-leading data modeling tool. It offers a model-driven approach to empower and align business and IT. PowerDesigner enables enterprises to more easily visualize, analyze, and manipulate metadata for effective enterprise information architecture.

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: -

SQL Power Architect

SQL Power Architect data modeling and profiling tool provides many unique features geared specifically for the data warehouse architect. Whether you are building a data warehouse or using data models to communicate business rules, SQL Power Architect will facilitate and automate your data modeling efforts.

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: -

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: -

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

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:
• Compatibility with different models and their levels,
• Ability to create new models from existing ones,
• Management of atomic data element definitions,
• Support for common modeling tasks (normalization, denormalization, etc.),
• Management of relationships and dependencies between models and their objects,
• Business glossary,

Creating and maintaining a data model requires collaboration among members from different areas (Data architect, business stakeholders, end-users). The use of data modeling software unifies and clarifies the information flow as well as ensures the correct representation of all data objects required by the database. Additionally, the tool helps to create the model at three levels: physical, logical and conceptual.

Moreover, it helps in finding missing and redundant data.

The result of the above benefits is a reduction of very time-consuming data modeling tasks and consequently saving money for the organization.

There are many free and open-source data modeling tools available now. We have prepared a list of the best free & paid options for data modeling in your organization.