current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 12 down vote favorite
12

Is there an application to reverse engineer an existing database in mysql and/or postgre?

I'm interested in obtaining the DB diagram from an existing one, similar as it can be done in MSSQL Server

share|improve this question
    
Possible dupe: stackoverflow.com/questions/11099444/… –  Sualeh Fatehi Jul 10 '12 at 11:49
add comment

4 Answers 4

up vote 2 down vote

Enterprise Architect

Reverse engineer from many popular DBMS systems, including Oracle 9i and 10g, SQL Server, My SQL, Access, PostgreSQL and others

share|improve this answer
add comment
up vote 6 down vote

For MySQL, try MySQL Workbench.

For both MySQL and PostgreSQL, try TOAD Data Modeler.

If you use the open-source diagram app Dia, there are several tools to generate Dia diagrams from SQL databases including MySQL and PostgreSQL.

update: MySQL Workbench 5.2 supports reverse-engineering diagrams from a live database in addition to an SQL script. MySQL Workbench 5.2 just announced their Release Candidate 1 (as of 5/12/2010).

share|improve this answer
    
Do you need a plugin to get MySQL Workbench reverse engineer working? Where can I get it? –  Raúl Roa Mar 22 '09 at 3:39
    
MySQL Workbench 5.1 is in beta now and it seems reverse engineering works only on a SQL script in the current version. I don't know if or when a plugin will be available. –  Bill Karwin Mar 22 '09 at 3:52
    
Thanks, I had MySQL Workbench already but the reverse engineering works as you say from a CREATE DATABASE SQL script. You should check out DBVisualizer. –  Raúl Roa Mar 22 '09 at 19:25
add comment
up vote 1 down vote

pgDesigner for postgres, mysql workbench for mysql...

share|improve this answer
add comment
up vote 2 down vote

SchemaSpy is a very good option for reverse engineering. For diagramming bit it uses another tool GraphViz. For everything to work together make sure GraphViz is installed and its path to its bin is accessible to the SchemaSpy.

Here is a sample output.

share|improve this answer
add comment

Your Answer

 
discard

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.