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
- 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.
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):
- Qt 4.0 or later is the only dependency.
Database Architect is released under the terms of the GNU General
Public License version 3 or, at your option, any later version; 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-2008 by Tony O'Bryan. All
No portion of this site may be reproduced without the express written
permission of the copyright holder.
Last modified January 22, 2008.