pgModeler VS SchemaSpy

Co-creator of Trek here. Trek generated migration files based on the diff between a pgModeler(1) schema definition and existing migration files. Trek also helps deploying those migrations. I'd be happy to respond to any questions here :) 1) https://pgmodeler.io/. - Source: Hacker News / 3 months ago

PgModeler is an open source tool that does diagramming as well as database management, including asking if you want to cascade when trying to drop tables. UI is a big quirky but once you get used to it, it’s very nice. I swear by it. https://pgmodeler.io. Source: almost 2 years ago

Here is the one I have used in the past, https://pgmodeler.io/. Source: almost 2 years ago

Is there free and open-source database/data modeling tools available? I am looking for a tool that covers both OLTP (normalized schema) and OLAP (dimensional/STAR schema) modeling. I only found https://pgmodeler.io but it is not fully free (a little fee is required to download). Source: about 2 years ago

Once you compile it for the first time and start using it, you'll keep doing it again with each new version. I haven't found a better Postgres tool yet. [0]: https://pgmodeler.io/. - Source: Hacker News / over 2 years ago

If you don't need a tool where you can edit an ERD, try SchemaSpy it generates a nice HTML report of all tables, columns and creates an ER diagram based on declared foreign keys. I have never used it with SQL Server, but with Oracle and Postgres it also extracts the comments for tables and columns. I think that relies on the JDBC driver returning them properly, not sure if the MS driver does that (using the... Source: over 2 years ago