What's a Good Database ERD Tool for Linux?

Question

I've recently switched to Linux on my work machine and, new to the Linux desktop environment, I'd like to find a decent ERD tool for database design. Booting back into my Windows partition every time I need to create a diagram is going to get unpleasant quickly. I looked at Dia, but didn't see any DB tools - only UML, networking, etc.

Anyone have any recommendations? For what it's worth, I'm using Ubuntu (Hardy Heron).

Thanks.

Solution 1

As a stop gap, I've installed DBDesigner via Wine (I should have just done that first) since that's what my Windows developers are using, but will look at both of these as well. The Eclipse plugin would be ideal if it's decent.

Thanks.

Solution 2

MySQL just officially released the alpha of "MySQL Workbech for linux":

See the announcement here: MySQL Workbench 5.1 Alpha for Linux available.

Solution 3

I'd definitely recommend Gliffy.com for simple ER diagrams; it's an online flash-based tool. I wrote a small review of it a week ago.

Solution 4

For a generic (vendor independent) tool, you can try dia (I prefer the dia-gnome package). There are also some plugins for generating the SQL files.

Solution 5

Mmm I think the Linux version of MySQL Workbench is out for download at: http://forums.mysql.com/read.php?3,56274,56274#msg-56274

You can see the pre-release announcement here: http://dev.mysql.com/workbench/?p=138

They are still in alpha, but judging from the windows version this is gonna be "THE" ERD tool.

PD: For the ubuntu part, you are in luck, they say that ubuntu is "our Linux distro of choice".

View more solutions