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, 2018 at 15:29


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.