SQL modeling and design tools?

Question

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 — sum2000, Dec 21 '11 at 10:28

score 11 · Answer 1 · edited Mar 20 '17 at 10:18

11

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.

edited Mar 20 '17 at 10:18

Community

1

answered Feb 08 '13 at 09:48

don.joey

28,662

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

score 5 · Accepted Answer · answered Dec 21 '11 at 10:55

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/

score 1 · Answer 3 · answered Jan 04 '12 at 09:44

1

You can try ArguoUML with its SQL plugin.

answered Jan 04 '12 at 09:44

htorque

64,798

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 03 '15 at 16:16

score 0 · Answer 4 · answered Jul 21 '19 at 14:24

0

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.

answered Jul 21 '19 at 14:24

feliciano popov

18

SQL modeling and design tools?

4 Answers4

Linked