pgModeler

Open source

pgModeler is a locally installed PostgreSQL schema design tool with reverse engineering, diffing and a command-line interface.

pgmodeler.io
pgModeler homepage screenshot
GitHub stars
3.6k
Last 30 days
+43(+1%)
Last commit
8 days ago
Repository age
14 years
Version
v2.0.0
Licence
GPL-3.0
Self-hosted
Yes

About pgModeler

pgModeler is a multi-platform PostgreSQL schema engineering tool that is installed locally and designed to work with Git. You design schemas visually, reverse-engineer production databases, diff and sync across environments, and automate deployments through a CLI.

The site states there is no cloud dependency, no telemetry and no lock-in, with schemas kept in open files on your machine. It is offered as community and commercial editions that share the same core features. The paid pgModeler Plus adds pre-built binaries and workflow features such as versioning and an SSH tunnel plugin.

The stable release shown is 1.2.3 from February 2026, and a 2.0.0 beta line is available. The project is maintained by Nullptr Labs under the GPL-3.0 licence, and academic students are offered 50% off Plus.

Key features

  • Visual schema design for PostgreSQL
  • Reverse engineering of existing databases
  • Local use with no cloud dependency or telemetry
  • Plus edition adds Git versioning and SSH tunnel plugins
  • Beta adds support for PostgreSQL 18 temporal keys

Good fit for

  • Designing database schemas visually
  • Reverse engineering production databases
  • Comparing schemas across environments
Tags
postgresql
database
erd
schema design
modeling
desktop

pgModeler: questions and answers

What is pgModeler used for?
pgModeler is a locally installed PostgreSQL schema design tool with reverse engineering, diffing and a command-line interface. It is a good fit for designing database schemas visually, reverse engineering production databases and comparing schemas across environments.
Is pgModeler open source?
Yes. pgModeler is open source under the GPL-3.0 licence. Its source code is on GitHub at nullptrlabs/pgmodeler and is written mainly in C++.
Is pgModeler free?
Yes. pgModeler is open source, so the software itself is free to use.
Can I self-host pgModeler?
Yes. pgModeler can be self-hosted on your own server or infrastructure.
What is pgModeler an alternative to?
pgModeler is an open-source alternative to DbSchema, SqlDBM, erwin Data Modeler and ER/Studio. Other open-source alternatives to DbSchema include DBeaver, ChartDB and MySQL.
Is pgModeler actively maintained?
Yes. The most recent commit to pgModeler was on 5 November 2026, and the latest release is v2.0.0, published on 30 October 2026. The project has 3.6k stars on GitHub, with 43 added in the last 30 days.

Open-source alternatives to pgModeler

See all

SaaS alternatives to pgModeler

See all