Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to diagram an oracle database and I am hoping to find some good tools that are either cheap, or free.

Ideally the tool should allow me to draw the relationships between the tables, as well as remove unwanted tables from the diagram.

I already have access to MS Visual Studio 2008 as well as SSMS 2008, but I don't believe either will provide much help with oracle.

share|improve this question
up vote 2 down vote accepted

I'd used Power Architect for this. It is Open Source/GPL

share|improve this answer

the perl sqlt program from the SQLFairy project (aka SQL::Translator) can read a database schema from a text file (or by directly querying the database using perl DBI) and translate the schema into a variety of formats, including some graphical/documentation formats such as Diagram and GraphViz and HTML.

it supports several different database backends, including Mysql, Postgresql, Sybase, and Oracle.

share|improve this answer

There is a good article here on creating an Oracle schema diagramme in Visio.

There is also the opensource alternative to Visio, Dia.

share|improve this answer

From Wikipedia:

Some free software ER diagramming tools that can interpret and generate ER models, SQL and do database analysis are StarUML, MySQL Workbench, and SchemaSpy. Some free software diagram tools just draw the shapes without having any knowledge of what they mean, nor do they generate SQL. These include Kivio and Dia. DIA diagrams, however, can be translated with tedia2sql.

share|improve this answer

If you have access to MS Access, you can create an ODBC connection to the DB and then link all your tables and use the relationship builder inside Access to build the diagram. This is typically what I do, as while it is not the best method, it sure is the easiest.

share|improve this answer

Oracle just started to offer one.

Oracle SQL Developer Data Modeler:

share|improve this answer
I like the native option much better. I see they JUST release it about a month ago. Very nice. – Russ Aug 11 '09 at 13:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.