I would like to know which tool do you use for modeling tables, relationships, etc, generic database modeling, in Ubuntu.

It would be good if that tool generate SQL scripts, and a plus with those scripts are SQLite compatible, but thats not necessary.

Currently, I am using Enterprise Architect for that under a virtual machine, which kind of sucks. I was able to run it under Wine, but not as good as I want to. It is a complete tool for modeling anything in this world, and right now I do not need so much.

  • u need UML Modelling tools..? – sum2000 Dec 21 '11 at 10:28

You may try DIA. You can use UML to create/model Databases and use one of the officially supported Scripts to convert it to SQL.

For instance you can find a basic How-To using DIA and TeDia2SQL at http://left.subtree.org/2007/12/05/database-design-with-dia/


Another good option is mysql-workbench. It can easily be installed using apt-get (the third command will do, yet I prefer to update and search first):

sudo apt-get update
sudo apt-cache search mysql-workbench
sudo apt-get install mysql-workbench

Then you can just type mysql in the HUB and voila.

enter image description here

It works like a charm. There is also a download from their website, yet that gave me in 12.10 a dependency error (the download is for 12.04 so that might explain it).

Others have also referred to: druid and DBDesigner. There is also another post on DB design on superuser.com.

  • +1 for mysql workbench. You can also synch changes to a mysql database. – nwaweru Oct 29 '19 at 8:31

You can try ArguoUML with its SQL plugin.

  • 1
    this answer is showing up in the low quality review queue??? So here goes the newbie blather: Although your answer is 100% correct, it might also become 100% useless if that link is moved, changed, merged into another one or the main site just disappears... :-( Therefore, please edit your answer, and copy the relevant steps from the link into your answer, thereby guaranteeing your answer for 100% of the lifetime of this site! ;-) You can always leave the link in at the bottom of your answer as a source for your material... – Fabby Aug 3 '15 at 16:16

I use ERBuilder data modeler under wine for modeling my PostgreSQL database and generating SQL script or directly the database. It works fine with wine and I think its support also SQLite.

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