37

ER diagram software for Ubuntu?

Jorge Castro
  • 73,717
Vassilis
  • 2,957

4 Answers4

27

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.

Marco Ceppi
  • 48,827
25

Dia

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

To install Dia in all currently supported versions of Ubuntu open the terminal and type:

sudo apt install dia
karel
  • 122,292
  • 133
  • 301
  • 332
tfmoraes
  • 534
5

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).

mguassa
  • 211
txwikinger
  • 29,406
1

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.

squallbayu
  • 3,054