13

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

Improve this question
1

5 Answers 5

Reset to default
7

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).

Improve this answer
3
  • Do you need a plugin to get MySQL Workbench reverse engineer working? Where can I get it?
    – Raúl Roa
    Commented Mar 22, 2009 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
    Commented Mar 22, 2009 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
    Commented Mar 22, 2009 at 19:25
5

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.

Improve this answer
2

Enterprise Architect

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

Improve this answer
2

I recommend DBeaver: multi-platform, free, open source, connects to most popular DB engines and supports reverse engineering.

I have tried reverse engineering both a MySQL DB and a PostgreSQL DB and it worked like a charm :)

Improve this answer
1

pgDesigner for postgres, mysql workbench for mysql...

Improve this answer

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