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, 2010 at 20:31
  • drawerd.com is a online erd tool.
    – Hooopo
    Jun 26, 2020 at 1:31

4 Answers 4


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, 2010 at 9:20
  • 2
    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, 2017 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, 2018 at 23:29
  • can you export and execute on Oracle? Mar 23, 2020 at 0:00

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, 2010 at 9:23
  • 1
    why not? See this ioncannon.net/utilities/123/…
    – tfmoraes
    Oct 14, 2010 at 11:43
  • What does "Install electric sheep" mean? The link heads to an auto-download page for dia. Is it some jargon?
    – Ignatius
    Aug 5, 2019 at 2:32

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, 2010 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, 2010 at 21:43

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