Skip to content
SPECIFICTION
Get listed

pgModeler

pgmodeler.io

From $59.90/mo Free plan WindowsmacOSLinux
Visit pgmodeler.io
Spec score 8.2 #8 of 27 in Data Modeling Software

What it is

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.

Spec sheet

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.Read 30 Sep 2026 · pgmodeler.io
Security
Connections support SSL modes, client certificates, Kerberos server settings, and GSSAPI authentication.Read 30 Sep 2026 · pgmodeler.io
Support
The project directs feature requests and bug reports to its GitHub issues page.Read 30 Sep 2026 · pgmodeler.io
License
The community software is distributed under GPL v3, while Plus supplies pre-built binaries and professional workflow features.Read 30 Sep 2026 · pgmodeler.io
Headquarters
Palmas, Tocantins, BrazilRead 28 Sep 2026 · pgmodeler.io
Founded
2006Read 28 Sep 2026 · pgmodeler.io
CLI
The command-line interface can export DDL, run diffs, validate models, and automate deployments in CI/CD workflows.Read 30 Sep 2026 · pgmodeler.io
Diff and sync
pgModeler Plus compares a model with a live server and generates the required ALTER, DROP, and CREATE statements for synchronization.Read 30 Sep 2026 · pgmodeler.io
Exports
Models can be exported as SQL, PNG, SVG, HTML data dictionaries, or directly to a PostgreSQL server.Read 30 Sep 2026 · pgmodeler.io
Local operation
pgModeler runs entirely on the user's machine with no account, cloud dependency, mandatory internet connection, or hosted schema infrastructure.Read 30 Sep 2026 · pgmodeler.io
Modeling
The relationship engine automatically propagates foreign-key columns, constraints, and indexes when tables are linked.Read 30 Sep 2026 · pgmodeler.io
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.Read 30 Sep 2026 · pgmodeler.io
Remote access
pgModeler Plus includes SSH tunneling for secure remote PostgreSQL connections without VPN configuration.Read 30 Sep 2026 · pgmodeler.io
Reverse engineering
pgModeler Plus can connect to a live PostgreSQL server and reconstruct a full schema model.Read 30 Sep 2026 · pgmodeler.io
Security limitation
The documentation warns that connection passwords are stored in plain text in the settings directory.Read 30 Sep 2026 · pgmodeler.io
Version control
The tool stores models as open, human-readable XML and Plus provides a Git-powered versioning workflow inside the interface.Read 30 Sep 2026 · pgmodeler.io

Plans and prices

Single user · 6 months Priced on request 1 seat · 1 platform Read 20 Sep 2026 · pgmodeler.io
Single user · 12 months Priced on request 1 seat · 1 platform Read 20 Sep 2026 · pgmodeler.io
Team lifetime · Perpetual Priced on request 2 seats Read 20 Sep 2026 · pgmodeler.io
pgModeler Community Free source code · free forever Read 30 Sep 2026 · pgmodeler.io
pgModeler Plus · Single user · 6 months $59.90 a month from $59.90/6 months 1 seat · single platform Read 30 Sep 2026 · pgmodeler.io
pgModeler Plus · Single user · 12 months Price not published 12 months 1 seat · single platform Read 30 Sep 2026 · pgmodeler.io
pgModeler Plus · Team lifetime Price not published Perpetual 2 seats Read 30 Sep 2026 · pgmodeler.io

Every pgModeler plan and price →

Strong points and limits

Strong points

  • Supports more than 30 PostgreSQL object types.
  • Exports models to SQL, images, HTML, or a server.
  • CLI supports model validation and deployment automation.
  • Runs locally without an account or cloud dependency.

Limits

  • Connection passwords are stored in plain text.
  • Plus single-user six-month plan is $59.90 per month.
  • Supported database scope is PostgreSQL.

Who it suits

pgModeler suits PostgreSQL users who want local schema design, reverse engineering, comparison, or deployment automation across desktop platforms. The community edition is free; Plus adds workflow features, including Git-powered versioning and SSH tunneling.

Verdict

pgModeler offers a local workflow spanning visual modeling, schema comparison, exports, and CLI automation. Consider the documented plain-text password storage when configuring connections, and check plan terms for Plus features.

Where Specifiction places it

Alternatives to pgModelerAll alternatives →