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.
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.
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.
Code license: New BSD License
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.
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.