Database Architect -- A GUI Database Management Tool

Database Architect

Database Architect is intended to be a powerful and easy to use tool for designing database schemas. It provides a visual design mode from which you can create, modify, and relate tables to one another. Its underyling architecture provides a mechanism by which any network-accessible database can be supported, though the current implementation solely supports PostgreSQL. It's most compelling feature to date is the ability to point it to any supported database and have it automatically construct a fully editable visual Database Architect representation -- complete with foreign key connections automatically established.

Main features:

Save and load Database Architect design files.
Print design files to any supported printer.
Decode any network-accessible PostgreSQL database into a Database Architect design file, and automatically show foreign key connections (the main limitation is that primary keys must consist of a single field. Multi-field primary keys are not yet supported).
Add, edit, delete database columns within design mode with simple mouse controls and dialogs. You can designate primary keys, foreign keys, unique fields, and fields that cannot be null. Foreign key connections are made via point and click.
Generate, print, save SQL text to create any table in your design.

System Requirements:

Qt 3.1 or later.
libpq for PostgreSQL.

Here is a sample of a decoded database. This is a web based BLOG I was developing for a relative. I had created the database schema by hand via psql, and decoded it into Database Architect specifically as an example for this page. Click on the thumbnail to get the full size image (1280x1024 PNG about 50K):

Database Architect is released under the terms of the GNU General Public License version 2; it is released with the hope that you may find it useful, but all disclaimers apply. Use it at your own risk. You can find the SourceForge page for Database Architect at http://sourceforge.net/projects/dbarchitect/

Thanks to SourceForge for hosting this project.

This page was created and is maintained by Tony O'Bryan, and is Copyright 2003 by Tony O'Bryan. All Rights Reserved.
No portion of this site may be reproduced without the express written permission of the copyright holder.
Last modified December 21, 2003.