DBDesigner

DBDesigner has features to create a visual model of any database. Starting from a reverse engineering engine to automatically retrieve a model from existing databases, extensive modeling tools and editors to a syncronisation function which will apply model changes automatically to the underlying database.

DBDesigner supports two switchable user interfaces

Design Model

Used to create and maintain the visual database model.

Query Mode

used to work with table data and build complex SQL statements for use in PHP, Kylix or other programming languages.

Screenshot

Official site