I have done quite a lot of SQL Server work where I could use SSMS. Now I'm working with Postgres and I miss the ability to generate models (diagrams) from existing relations (taking into account relationships).

I really like pgAdmin, but it looks like the designer is separate (pgDesigner) and old. I really like Navicat's designer, but it's quite expensive.

What are the best options for postgres ER models that are open source/free?

closed as off-topic by a_horse_with_no_name, Md Haidar Ali Khan, Colin 't Hart, Marco, hot2use Sep 18 '18 at 13:08

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – a_horse_with_no_name, Md Haidar Ali Khan, Colin 't Hart, Marco, hot2use
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    pgDesigner is not "old - it is actively maintained, but you have to compile it yourself (or donate to get a pre-built binary) – a_horse_with_no_name Sep 18 '18 at 10:48
  • Thank you @a_horse_with_no_name. I did not know that it was still actively maintained. Ideally I would like the designer and db navigator to be the same IDE. Just like SSMS :/ – Zach Smith Sep 18 '18 at 10:59

I found only one.


It's free, but nobody's stopping you from donating.

  • Thanks - happy to donate to software I use (and I do). i try to avoid spending $1200 though, which is what an all encompassing license for navicat costs! – Zach Smith Sep 18 '18 at 11:00
  • If you try it, let us know how it went. – Gerard H. Pille Sep 18 '18 at 11:10

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