- Home
- Data Modeling Software
- pgModeler
pgModeler
Palmas, Tocantins, Brazil
What it is
pgModeler is a locally installed PostgreSQL schema engineering tool for Linux, macOS and Windows. It supports visual modeling, reverse engineering, schema comparison and synchronization, along with command-line deployment automation. Its relationship engine can add foreign-key columns, constraints and indexes when tables are connected, and the tool supports more than 30 PostgreSQL object types. Models can be exported as SQL, PNG, SVG or HTML data dictionaries, or sent directly to a PostgreSQL server. The command-line interface can export DDL, compare and validate models, and support deployment automation in CI/CD workflows. Models use human-readable XML; Plus adds a Git-based versioning workflow within the interface. The software runs on the user's machine without requiring an account, cloud service or internet connection. The community edition is GPL v3 and free forever. Plus offers pre-built binaries and additional 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.
For and against
For
- Runs locally without an account or cloud dependency.
- Supports more than 30 PostgreSQL object types.
- Exports models as SQL, images and HTML dictionaries.
- CLI supports validation and deployment automation.
- Community edition is free forever under GPL v3.
Against
- Supports PostgreSQL only.
- Stored connection passwords are plain text.
- Plus single-user six-month plan is $59.90 per month.
- Reverse engineering and schema synchronization are Plus features.
The verdict
pgModeler offers local PostgreSQL modeling, export and command-line workflows, with Plus adding live-server and versioning capabilities. Consider the documented plain-text password storage when configuring connections.
Who it suits
pgModeler suits PostgreSQL developers who want to design or compare schemas locally and use command-line deployment workflows. Teams needing Plus's Git workflow or SSH tunneling may consider that edition.
Plans and prices
Single user · 6 months
1 seat · 1 platform
Read 20 Sep 2026 · pgmodeler.io
Single user · 12 months
1 seat · 1 platform
Read 20 Sep 2026 · pgmodeler.io
Team lifetime · Perpetual
2 seats
Read 20 Sep 2026 · pgmodeler.io
pgModeler Community
source code · free forever
Read 30 Sep 2026 · pgmodeler.io
pgModeler Plus · Single user · 6 months
1 seat · single platform
Read 30 Sep 2026 · pgmodeler.io
pgModeler Plus · Team lifetime
2 seats
Read 30 Sep 2026 · pgmodeler.io
pgModeler Plus · Single user · 12 months
1 seat · single platform
Read 30 Sep 2026 · pgmodeler.io
On the record
- CLI
- The command-line interface can export DDL, run diffs, validate models, and automate deployments in CI/CD workflows.pgmodeler.io · read 30 Sep 2026
- Diff and sync
- pgModeler Plus compares a model with a live server and generates the required ALTER, DROP, and CREATE statements for synchronization.pgmodeler.io · read 30 Sep 2026
- Exports
- Models can be exported as SQL, PNG, SVG, HTML data dictionaries, or directly to a PostgreSQL server.pgmodeler.io · read 30 Sep 2026
- License
- The community software is distributed under GPL v3, while Plus supplies pre-built binaries and professional workflow features.pgmodeler.io · read 30 Sep 2026
- Local operation
- pgModeler runs entirely on the user's machine with no account, cloud dependency, mandatory internet connection, or hosted schema infrastructure.pgmodeler.io · read 30 Sep 2026
- Modeling
- The relationship engine automatically propagates foreign-key columns, constraints, and indexes when tables are linked.pgmodeler.io · read 30 Sep 2026
- PostgreSQL scope
- It supports more than 30 PostgreSQL object types, including domains, custom types, operators, collations, procedural languages, event triggers, foreign data wrappers, and extensions.pgmodeler.io · read 30 Sep 2026
- Purpose
- pgModeler is a locally installed, multi-platform PostgreSQL schema engineering tool for visual design, reverse engineering, schema diff and synchronization, and CLI deployment automation.pgmodeler.io · read 30 Sep 2026
- Remote access
- pgModeler Plus includes SSH tunneling for secure remote PostgreSQL connections without VPN configuration.pgmodeler.io · read 30 Sep 2026
- Reverse engineering
- pgModeler Plus can connect to a live PostgreSQL server and reconstruct a full schema model.pgmodeler.io · read 30 Sep 2026
- Security
- Connections support SSL modes, client certificates, Kerberos server settings, and GSSAPI authentication.pgmodeler.io · read 30 Sep 2026
- Security limitation
- The documentation warns that connection passwords are stored in plain text in the settings directory.pgmodeler.io · read 30 Sep 2026
- Support
- The project directs feature requests and bug reports to its GitHub issues page.pgmodeler.io · read 30 Sep 2026
- Version control
- The tool stores models as open, human-readable XML and Plus provides a Git-powered versioning workflow inside the interface.pgmodeler.io · read 30 Sep 2026
