<p>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.</p>

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

<p>Thanks.</p>

[{'answer_id': 14091, 'author': 'SCdF', 'author_id': 1666, 'author_profile': 'https://Stackoverflow.com/users/1666', 'pm_score': 1, 'selected': False, 'text': '<p>No recommendations as such, but,</p>\n\n<p>You might want to broaden your search to Eclipse plugins such as <a href="http://eclipse-erd.sourceforge.net/" rel="nofollow noreferrer">http://eclipse-erd.sourceforge.net/</a>.</p>\n\n<p>Apart from that there are various ERD tools you have to pay for like <a href="http://www.thekompany.com/products/dataarchitect/" rel="nofollow noreferrer">Data Architect</a>.</p>\n'}, {'answer_id': 14112, 'author': 'Steve M', 'author_id': 1693, 'author_profile': 'https://Stackoverflow.com/users/1693', 'pm_score': 2, 'selected': False, 'text': '<p>Check out SQL Developer: [<a href="http://sqldeveloper.solyp.com/download/index.html]" rel="nofollow noreferrer">http://sqldeveloper.solyp.com/download/index.html]</a></p>\n'}, {'answer_id': 14598, 'author': 'Rob Wilkerson', 'author_id': 1665, 'author_profile': 'https://Stackoverflow.com/users/1665', 'pm_score': 1, 'selected': True, 'text': "<p>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.</p>\n\n<p>Thanks.</p>\n"}, {'answer_id': 20999, 'author': 'Dave Marshall', 'author_id': 1248, 'author_profile': 'https://Stackoverflow.com/users/1248', 'pm_score': 3, 'selected': False, 'text': '<p>I\'d definitely recommend <a href="http://www.gliffy.com/" rel="nofollow noreferrer">Gliffy.com</a> for simple ER diagrams; it\'s an online flash-based tool. I wrote a small <a href="http://www.davedevelopment.co.uk/2008/08/11/review-gliffycom/" rel="nofollow noreferrer">review</a> of it a week ago.</p>\n'}, {'answer_id': 65420, 'author': 'levhita', 'author_id': 7946, 'author_profile': 'https://Stackoverflow.com/users/7946', 'pm_score': 2, 'selected': False, 'text': '<p>Mmm I think the Linux version of MySQL Workbench is out for download at:\n<a href="http://forums.mysql.com/read.php?3,56274,56274#msg-56274" rel="nofollow noreferrer"><a href="http://forums.mysql.com/read.php?3,56274,56274#msg-56274" rel="nofollow noreferrer">http://forums.mysql.com/read.php?3,56274,56274#msg-56274</a></a></p>\n\n<p>You can see the pre-release announcement here:\n<a href="http://dev.mysql.com/workbench/?p=138" rel="nofollow noreferrer"><a href="http://dev.mysql.com/workbench/?p=138" rel="nofollow noreferrer">http://dev.mysql.com/workbench/?p=138</a></a></p>\n\n<p>They are still in alpha, but judging from the windows version this is gonna be "THE" ERD tool.</p>\n\n<p>PD: For the ubuntu part, you are in luck, they say that ubuntu is "our Linux distro of choice".</p>\n'}, {'answer_id': 65587, 'author': 'Sten Vesterli', 'author_id': 9363, 'author_profile': 'https://Stackoverflow.com/users/9363', 'pm_score': 2, 'selected': False, 'text': '<p>Look at Oracle JDeveloper (freeware). It is pure Java, so it will run on any platform. It will work against any database that you can connect to via JDBC. It builds database diagrams (and lots of other diagrams - it happens to be a complete Java IDE).</p>\n\n<p>It works with a concept of "offline database objects" stored in XML files. So if you have existing database objects, you start by capturing them into JDeveloper and then build your diagram. If you make changes to your offline objects, you can "reconcile" them back into your database, either as new objects (DROP-REPLACE) or as modifications (ALTER).</p>\n\n<p>Download at <a href="http://www.oracle.com/technology/software/products/jdev/index.html" rel="nofollow noreferrer">http://www.oracle.com/technology/software/products/jdev/index.html</a></p>\n'}, {'answer_id': 103682, 'author': 'levhita', 'author_id': 7946, 'author_profile': 'https://Stackoverflow.com/users/7946', 'pm_score': 4, 'selected': False, 'text': '<p>MySQL just officially released the alpha of "MySQL Workbech for linux":</p>\n\n<p>See the announcement here:\n<a href="http://dev.mysql.com/workbench/?p=153" rel="noreferrer">MySQL Workbench 5.1 Alpha for Linux available</a>.</p>\n'}, {'answer_id': 265368, 'author': 'Gianluca Della Vedova', 'author_id': 34613, 'author_profile': 'https://Stackoverflow.com/users/34613', 'pm_score': 2, 'selected': False, 'text': '<p>For a generic (vendor independent) tool, you can try dia (I prefer the dia-gnome package).\nThere are also some plugins for generating the SQL files.</p>\n'}, {'answer_id': 609446, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 2, 'selected': False, 'text': '<p>MySQL Workbench is available on MacOS, Fedora, Ubuntu, Windows. </p>\n\n<p>WB 5.1 is focused on Data Modeling (replacing Mike Zinner’s popular DBDesigner product).</p>\n\n<p>WB 5.2 (coming April 2009) will include a ground up rewrite of the MySQL Query Browser.</p>\n\n<p><a href="http://forums.mysql.com/index.php?151" rel="nofollow noreferrer">http://forums.mysql.com/index.php?151</a></p>\n'}, {'answer_id': 1530456, 'author': 'Leigh Pyle', 'author_id': 32010, 'author_profile': 'https://Stackoverflow.com/users/32010', 'pm_score': 1, 'selected': False, 'text': '<p>I had bad experience with Workbench on Linux in the past and wish it got better now. </p>\n\n<p>I am quite happy with <a href="http://schemabank.com" rel="nofollow noreferrer">SchemaBank</a> these days \'cause they are purely web-based. You drop them a few bucks every month and they host your diagram for private / public sharing. Usual stuff like forward / reverse engineering, alter scripts, etc are all supported.</p>\n'}, {'answer_id': 2062935, 'author': 'Ludek Vodicka', 'author_id': 113842, 'author_profile': 'https://Stackoverflow.com/users/113842', 'pm_score': 0, 'selected': False, 'text': '<p>You can try ORM Designer <a href="http://www.orm-designer.com" rel="nofollow noreferrer">http://www.orm-designer.com</a> \nTool is similar to DBDesigner, but has much more functions and is under everyday development.</p>\n'}, {'answer_id': 12171823, 'author': 'sahar', 'author_id': 1632198, 'author_profile': 'https://Stackoverflow.com/users/1632198', 'pm_score': -1, 'selected': False, 'text': '<p>You can try Base from <a href="https://www.libreoffice.org/features/base/" rel="nofollow">LibreOffice</a>. It can connect to any database and you can easily create, design and write queries using visual wizards and tools.</p>\n'}]
['https://Stackoverflow.com/questions/14032', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1665/']