ER diagram software for Ubuntu?

  • 2
    Could you please explain what is lacking in Dia, so that we can answer with the most suitable alternatives? – dv3500ea Oct 13 '10 at 20:31

Dia Install electric sheep

Dia is a GTK+ based diagram creation program for GNU/Linux, Unix and Windows released under the GPL license. For more information visit the Dia project page

  • workflows with inkscape??? – Vassilis Oct 14 '10 at 9:23
  • 1
    why not? See this ioncannon.net/utilities/123/… – tfmoraes Oct 14 '10 at 11:43
  • What does "Install electric sheep" mean? The link heads to an auto-download page for dia. Is it some jargon? – Taegyung Aug 5 at 2:32

I've found MySQL Workbench to be most useful for creating "ER" diagrams.

alt text

Though the format is only MySQL Workbench specific I can take a diagram created in Workbench and export it to SQL and execute it against any number of SQL servers.

alt text

If you're working with MySQL this tool also doubles as an Administration and Querying tool as well providing the added benefit of integration between the three.

  • It's a good tool, a good explanation, but I will use DIA. Thank you!!!! – Vassilis Oct 14 '10 at 9:20
  • 1
    Extremely buggy (lost my work twice, crashed 5 times total), and printing to a PDF has unacceptable font quality issues (and I would assume a real printer also). – Iiridayn Feb 7 '17 at 23:35
  • 1
    WB is not only buggy in behavior but in look and feel too (try to use it in a HiDPI monitor and you will see). There is a bug report about that since 2009 without any work on it (and so many other marked as duplicated). – sdlins Sep 16 '18 at 23:29

Umbrello can also create ER-Diagrams besides most other UML diagrams. In addition it allows you to export the Diagrams in form of code (i.e. in this case SQL).

  • 1
    umbrello umbrello.org/index.php and is for KDE if you use gnome it install a lot of KDE dependency – hhlp Oct 17 '10 at 22:08

try to use Astah Comunity, the application was able to create ER diagrams, class diagrams, etc.To develop applications that application is very suitable. I even heard the professional version could generate java code to class diagram and generate sql code for the ER diagram.

that application was built using java, so the application is multi platform.

  • the astha comunity FREE only support UML Modeling Tool the other thing you coment is the paid one – hhlp Oct 17 '10 at 21:43

protected by Community Jun 24 '14 at 3:27

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.