I'm looking for a free (gratis) tool to create database models, i.e. ERM diagrams (entity relationship models).

The tool

  • runs on Windows 10 x64
  • is free (gratis)
  • works offline and not in a Browser (local websites are not acceptable)
  • does not use Java, because our IT does not like/allow it
  • stores the diagram in a single file for easy backup purposes
  • supports unlimited number of diagrams with unlimited number of tables and unlimited number of columns, because I don't know the constraints of my database yet.
  • provides a GUI for graphical input, not some description language (I like those very much in general)


  • multi user support, since only 1 user will use it for small database projects
  • it needn't synchronize data to the cloud, backup etc. I want a single file which I can copy or delete.
  • no need for importing databases or creating databases based on the model. This will all be done manually.

I have found the following potential candidates, but they don't match:

Closest so far is yEd, but things like that should not happen:

Manual fiddling required

I don't want to be fiddling around manipulating the sizes of objects just to make the text fit.

I found the following questions here on SR:

  • 1
    I used DeZign for Databases some time ago, but it's not free. Main advantage is ability to work with multiple databases. datanamic.com/dezign/index.html – Dmitry Jan 8 '18 at 15:29
  • @Dmitry: thanks for the suggestion – Thomas Weller Jan 8 '18 at 15:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.