ERD

ERD Tool - Data Modeling Software

Software Ideas Modeler

Software Ideas Modeler is a data modeling ERD tool that allows you to draw and model standard ERD diagrams or ERD diagram by Chen notation. You may model entities, relationships, primary and foreign keys, and indexes as well. You can create database models easily in no time.

ERD tool - Entity-Relationship Editor window
ERD tool - Entity-Relationship Editor window

Free ER Diagram Tool

You may draw entity-relationship diagrams for free with Software Ideas Modeler Standard (non-commercial usage). Even if you want to use the software for commercial purposes you may buy the software at a very affordable price.

Easy to Use ERD Software

Our ERD software helps you in every stage of database design. You can create a completely new data model, import existing database schema and edit it as an entity-relationship diagram, and finally export the changes to SQL scripts - create, alter, drop, insert, update, delete - whatever is needed based on your changes. You can document your data model to help to understand it by other people or even by you after a long time. You can generate documentation on few clicks.

Import from Database

With this ERD tool, you may import the tables with their relationships from MS SQL, MySQL or any other database which provides OLE DB provider (e.g. Oracle). This E-R diagramming software not only supports the import of new tables, but it may also import the changes. You may choose which tables you wish to add or update and whether you want to generate a diagram or only import tables to the model.

Script Generation

SQL DDL script generation is a must for a good E-R tool and Software Ideas Modeler is no exception. It allows you to generate database schema scripts and insert scripts for the defined enumerations. Using it with the change tracking feature, you may also generate change scripts.

Enumerations and Codebooks

Each table in a diagram may contain data directly in the model. This is useful especially for enumerations and codebooks.

ERD Relationship Highlighting

The ERD editor helps you navigate foreign key references. If you select a relationship, the linked attributes will be highlighted in both associated entities.

ERD Relationship Highlighting
ERD Relationship Highlighting

Different Styles for Primary/Foreign Keys and Relationships

Attribute Layout

Entity Relationship Diagram supports different styles of attribute layout:

  • Column
  • Flow

Primary and Foreign Keys

You may choose one of three key styles:

  • +, #
  • PK, FK
  • Icons (🔑, ➥)

ERD Cardinality

There are also two possible styles of relationships and their multiplicity:

  • Min-Max
  • Crow's foot
Entity Relationship Diagram supports different styles of attribute layout, keys and min-max notation for relationships

Types in E-R Diagrams

You may use the specific database types in your diagrams or you may utilize general UML types and let the software translate to the correct database type.

Included Type Sets

The following type sets come with Software Ideas Modeler in the default package:

  • MySQL
  • MS SQL
  • Oracle
  • PostgreSQL
  • SQLite

If your database is not present in the list, Software Ideas Modeler allows you to define your custom type set.

ER Diagram Examples

Data models created using Software Ideas Modeler's ER diagramming tools: