Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
What is a "DB design tool"? – Charles Stewart Feb 27 '10 at 16:24
I'm not strong in terminology. Does DB modeling sound better? – codeholic Feb 27 '10 at 18:36
up vote 10 down vote accepted

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.

share|improve this answer
Can I export SQL for SQLite and PostreSQL with MySQL Workbench? Because DBDesigner4, its predecessor, claimed it could. – codeholic Mar 2 '10 at 15:37
It can be achieved with a plugin for SQLite: Still looking for PostgreSQL. – codeholic Mar 5 '10 at 7:15

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

share|improve this answer

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.
share|improve this answer
I've used this one a bunch of times and love it! – warren Mar 2 '10 at 14:31
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 Mar 2 '10 at 15:34

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.

share|improve this answer

You can try Vertabelo - an online database designer developed by company I work for.

The most important/interesting features include:

  • Sharing database models across the team
  • Collaborate on your design via web browser (working under Chrome)
  • Support for PosgreSql, MySQL, Oracle, MS SQL Server, DB2, SQLite, HSQLDB
  • Model versioning
  • Dynamic/Visual search
  • Live database model validation
  • Reverse engineering

It is free to use up to 3 models and 20 tables within each model. Commercial versions are available for bigger team/projects.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .