ER Designer vs pgModeler
ER Designer
ermap.iopgModeler
pgmodeler.ioSide by side
| Figure | ER Designer | pgModeler |
|---|---|---|
| Price from | Free | $59.90/mo |
| Free plan | Yes | Yes |
| Free trial | — | Yes |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| Plans published | 3 | 7 |
| Spec score · Database Design Tools | 7.6 (#18) | 8.2 (#11) |
| Purpose | ER Designer is a browser-based platform for creating ER diagrams, restructuring database schemas and generating logical schemas. | pgModeler is a locally installed, multi-platform PostgreSQL schema engineering tool for visual design, reverse engineering, schema diff and synchronization, and CLI deployment automation. |
| Support | The help page invites bug reports and improvement suggestions through a feedback form. | The project directs feature requests and bug reports to its GitHub issues page. |
Plans
pgModeler
- Single user · 6 monthsPriced on request
- Single user · 12 monthsPriced on request
- Team lifetime · PerpetualPriced on request
- pgModeler CommunityFree
- pgModeler Plus · Single user · 6 months$59.90 a month
- pgModeler Plus · Single user · 12 monthsPrice not published
- pgModeler Plus · Team lifetimePrice not published
In their own words
pgModeler
pgModeler is a locally installed PostgreSQL schema engineering tool for Linux, macOS, and Windows. It supports visual design, reverse engineering, schema comparison and synchronization, and command-line deployment automation. Its relationship engine can propagate foreign-key columns, constraints, and indexes when tables are linked, and it supports more than 30 PostgreSQL object types. Models can be exported as SQL, PNG, SVG, HTML data dictionaries, or directly to a PostgreSQL server. The command-line interface can export DDL, run diffs, validate models, and automate CI/CD deployments. Models use human-readable XML; Plus adds a Git-powered versioning workflow. The software runs on the user's machine without an account, cloud dependency, or required internet connection. The community software is GPL v3 and free forever. Plus provides pre-built binaries and professional workflow features. Its listed single-user, six-month plan is $59.90 per month, billed from $59.90/6 months. Documentation warns that connection passwords are stored in plain text in the settings directory.