Design. Connect. Refine.

Turn your ideas into clear database designs without starting over.

Move between conceptual diagrams and relational schemas in one connected project—
refining what you already built, not throwing work away.

Download ERDFlow

ERD in action

From the first diagram to the possibilities ahead.

Company DatabaseConceptual Design
Conceptual ER diagram of a companyEmployee works on Project, many to many, recording the hours worked. Department employs every employee and controls every project, one department to many of each. Employee has a key ID, a composite Name made of First, Middle and Last, Gender, Birth Date, an Age derived from it and any number of Phone numbers. Project has a key ID, a Name and a Budget. Department has a key ID, a Name and any number of Locations.MMM1M1IDNameFirstMiddleLastGenderBirth DateAgePhoneHoursIDNameBudgetIDNameLocationWorks OnControlsEmploysEmployeeProjectDepartment
Conceptual designEntities, relationships and every kind of attribute.
Company Database — Relational SchemaSchema Design
Relational schema of a companyThree tables. Employee has the primary key EmployeeID, name, contact and employment columns, and foreign keys to its job, office, supervisor and department. ProjectAssignment joins employees to projects: its primary key is EmployeeID and ProjectID together, each a foreign key, with Hours, AssignedDate and Role. Project has the primary key ProjectID, its name, dates, budget and status, and foreign keys to its department and client.EmployeeColumnTypePKEmployeeIDintFirstNamenvarchar(50)MiddleNamenvarchar(50)LastNamenvarchar(50)BirthDatedateGendernvarchar(20)Emailnvarchar(255)Addressnvarchar(200)HireDatedateSalarydecimal(12,2)FKJobIDintFKOfficeIDintFKSupervisorIDintFKDepartmentIDintProjectAssignmentColumnTypeFKEmployeeIDintFKProjectIDintHoursdecimal(6,2)AssignedDatedateRolenvarchar(60)ProjectColumnTypePKProjectIDintProjectNamenvarchar(150)Descriptionnvarchar(1000)StartDatedateEndDatedateBudgetdecimal(14,2)Statusnvarchar(20)FKDepartmentIDintFKClientIDint
Relational schemaTables, keys and types for the same company.
Company Database — SQLFuture Feature Preview
Future feature preview: SQL for the company exampleAn illustrative CREATE TABLE statement for ProjectAssignment, with EmployeeID and ProjectID as a composite primary key, each also a foreign key referencing Employee and Project, and columns Hours, AssignedDate and Role. SQL generation is not part of ERDFlow today.ProjectAssignment.sql1-- Illustrative preview: SQL generation is not part of ERDFlow today.23CREATE TABLE ProjectAssignment (4 EmployeeID INT NOT NULL,5 ProjectID INT NOT NULL,6 Hours DECIMAL(6, 2) NULL,7 AssignedDate DATE NOT NULL,8 Role NVARCHAR(60) NULL,9 CONSTRAINT PK_ProjectAssignment10 PRIMARY KEY (EmployeeID, ProjectID),11 CONSTRAINT FK_ProjectAssignment_Employee12 FOREIGN KEY (EmployeeID)13 REFERENCES Employee (EmployeeID),14 CONSTRAINT FK_ProjectAssignment_Project15 FOREIGN KEY (ProjectID)16 REFERENCES Project (ProjectID)17);
SQLIllustrative only: SQL generation is not part of ERDFlow today.
Company Database — EmployeeFuture Feature Preview
Future feature preview: sample rows of the Employee tableAn illustrative grid of eight invented Employee records with EmployeeID as the primary key, FirstName, LastName, HireDate, Salary and DepartmentID as a foreign key. The Data workspace is a future feature and is not part of ERDFlow today.Employee8 rows · illustrative sample dataEmployeeIDPK int101102103104105106107108FirstNamenvarchar(50)LenaDanielSaraMarcoAishaJonasMiaTomásLastNamenvarchar(50)HoferWeberNovakRossiRahmanBergerKovačSilvaHireDatedate2021-03-152020-09-012022-01-102019-06-242023-04-032021-11-222024-02-122022-08-29Salarydecimal(12,2)4,850.005,320.004,410.006,050.004,180.005,040.003,960.004,720.00DepartmentIDFK int12132312Sample records for illustration only — not connected to a database.
Table dataSample records only: the Data workspace is a future feature.
Download ERDFlow

Coming to Windows, macOS and Linux

ERDFlow is in development. Installers will be published here once packaging and testing are complete.

Windows 10/11

Planned for
Windows 10 and 11

  • Open-source Core
  • Native C++ and Qt app
  • Installer in preparation

macOS

Planned for Intel and Apple Silicon

  • Open-source Core
  • Native C++ and Qt app
  • App bundle in preparation

Linux

Planned as an x64 AppImage

  • Open-source Core
  • Native C++ and Qt app
  • AppImage in preparation