MyDBExpert is an Open-source tool for drawing entity-relation diagrams, and exporting them to any image. It is written in Delphi, and should make it a lot easier to design databases.

Important: Due to lack of time, I am currently looking for a new maintainer. Please contact Vegard A. Larsen (vegard (at) xaltra (dot) net) for more information.

General use | Why? | To-do list | Changelog | GNU GPL | Downloads

General use

You add tables, by rightclicking in the main window, and choosing "Tables", "Add". You can then change the name and contents of each table by right-clicking in the different tables and choosing "Edit". You add relations between tables by drag'n'drop-ing fields from one table to the other.

Using the Configuration, you can change a few colors and fonts, useful if you want to export it to an image that has to match a certain style. You can access the Configuration by right-clicking in the main window and choosing "Configuration".

By rightclicking in the main window, and choosing "Relations", "Remove all", all the relations between tables will be cleared. By rightclicking in the main window, and choosing "Output", "as JPEG", you will be prompted for a filename, and the current contents of the main window will be printed. The JPEG's dimensions will match those of the window, so you should resize the window to the proportions you need before saving.

The rest (there ain't that much more to it, actually) of the program is pretty self-explanatory.


There were no programs that did exactly what I wanted. I were up for an exam when I started writing this program, where the design of databases was one of the requirements, and as such, I started looking for a program that could draw entity-relation diagrams. There were one alternative, Microsoft Access, but as I have based my database-training upon mySQL and PHP, I decided that I should rather look at alternative solutions. I first started out drawing ASCII-representations of the diagrams, but quickly found out that this was to time-consuming to do at a 5-hour exam. This is the result. The images exported by this program could easily be included in any database documentation, and was used in the presentation of the resulting database.

To-do list

Features that will (probably) be added in the near future;



0.0.4; uploaded to Sourceforge, and renamed to MyDBExpert. Added support for primary keys, unique, index, binary and auto_increment constraints. Can dump mySQL to screen.

0.0.3; supports exporting to (my)SQL dump files, and therefore allows descriptions for each field, as well as a field type.

0.0.2; supports saving and loading of databases, using valid XML.

0.0.1; first public release.

GNU General Public License

myDBExpert - creating databases graphically
Copyright © 2002-2004
Vegard A. Larsen. All rights reserved.

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

Read the entire license.


SourceForge Logo Please visit our project page at Sourceforge to download the latest version.

Copyright © 2002-2004 Vegard A. Larsen. All rights reserved.
Licensed under the GNU GPL.