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?

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

| improve this answer | |
  • 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.