jakob / Postico

Public issue tracking for Postico
https://eggerapps.at/postico/
476 stars 9 forks source link

Reverse engineering Entity-Relationship diagram from database feature #238

Open sul4bh opened 8 years ago

sul4bh commented 8 years ago

MySQL Workbench can reverse engineer an ER diagram from a table. I wish we had a similar feature in Postico.

I know this is a big feature to wish for and might not fall under the scope of Postico. I will be happy if anybody can point me to a decent tool that does ER digram from database. Please suggest something that you have experience with.

mtvspec commented 6 years ago

JetBrains DataGrip have excellent database structure visualization tool. But software based on Java technologies so slowly works on Mac (and not only on Macs :) ).

corysimmons commented 4 years ago

I still prefer postico for general use, but DBeaver has ERD generation.

https://github.com/dbeaver/dbeaver/wiki/ER-Diagrams

  1. https://dbeaver.io
  2. connect db
  3. bottom left of GUI, right click on ER Diagrams
  4. "create new ER diagram"
  5. name your ERD
  6. drill down to the tables of the db you want to diagram