What FLOSS DB design tool for Linux would you recommend?

I want to find a relational DB design tool for Linux, that could export DB schema for MySQL, SQLite and PostreSQL at least. And it should be handy, of course. Good-looking GUI is also a plus ;-) I use Gnome, but KDE tools are interesting too.

database

codeholic

Posted 2010-02-23T20:20:02.680

Reputation: 445

What is a "DB design tool"? – Charles Stewart – 2010-02-27T16:24:00.303

I'm not strong in terminology. Does DB modeling sound better? – codeholic – 2010-02-27T18:36:44.710

Answers

For MySQL there is MySQL Workbench:

MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench will be available as a native GUI tool on Window, Linux and OS X.

hlovdal

Posted 2010-02-23T20:20:02.680

Reputation: 2 760

Can I export SQL for SQLite and PostreSQL with MySQL Workbench? Because DBDesigner4, its predecessor, claimed it could. – codeholic – 2010-03-02T15:37:43.523

It can be achieved with a plugin for SQLite: http://wb.mysql.com/?p=227. Still looking for PostgreSQL.

– codeholic – 2010-03-05T07:15:29.980

You can have a look at WWW SQL designer

WWW SQL Designer allows users to create database designs, which can be saved/loaded and exported to SQL scripts. Various databases and languages are supported. Ability to import existing database design.

This tool allows you to draw and create database schemas (E-R diagrams) directly in browser, without the need for any external programs (flash). You only need JavaScript enabled. The Designer works perfectly in Mozillas (Firefox, Seamonkey), Internet Explorers (6, 7, 8), Safari and Operas. Konqueror works, but the experience is limited.

Code license: New BSD License

alt text

Sathyajith Bhat

Posted 2010-02-23T20:20:02.680

Reputation: 58 436

Take a look at DBDesigner 4. Its a MySQL database design tool that also supports other database products like SQL Server, Oracle, SQL Lite and ODBC.

Its free, opensource (GPL), available for Linux/GNOME.

Some interesting features:

If you are using a database not directly supported, you can create your own data type. Right click in the data type window and select Create New Datatype.
You can connect to an existing database and it will import your model.

teknikqa

Posted 2010-02-23T20:20:02.680

Reputation: 412

I've used this one a bunch of times and love it! – warren – 2010-03-02T14:31:07.110

But isn't it the prototype of MySQL Workbench? EDIT: Yes, it is. "MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project." – codeholic – 2010-03-02T15:34:00.880

Try Knoda. It's a database front-end that can be used to create, view, and modify many different types of databases. You just need to install the relevant hk_clasess database drivers for the database you want to work with(e.g.MYSQL, SQLite, Postgresql and even Access (read only)). What's nice about Knoda is that a) you can export and import from one database format to another and b) it has a visual query builder if you are not proficient in SQL. Unfortunately, the package is not being maintained and so is no longer available in repositories of recent Ubuntu releases. You can still install it from Lucid repository.

Wayne

Posted 2010-02-23T20:20:02.680

Reputation: 1