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
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
DBeaver
Database Tools
Free universal database tool and SQL client
Apache-2.0vs DataGrip★ 52k
ChartDB
Database Tools
Database diagrams editor that allows you to visualize and design your DB with a single que
AGPL-3.0vs dbdiagram.io★ 23k
MySQL
Databases
MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-tim
OSSvs Oracle Database★ 13k
drawDB
Database Tools
Free, simple, and intuitive online database diagram editor and SQL generator.
AGPL-3.0vs dbdiagram.io★ 40k
Liam ERD
Database Tools
Automatically generates beautiful and easy-to-read ER diagrams from your database.
Apache-2.0vs dbdiagram.io★ 5.2k
HeidiSQL
Open source
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbas
GPL-2.0vs DbVisualizer★ 6.3k
SaaS alternatives to pgModeler
See all
DbSchema
Database Tools
Visual database design and documentation tool for relational and NoSQL databases
SaaSSqlDBM
Database Tools
Browser-based database modeling tool that generates SQL for cloud data warehouses
SaaS
erwin Data Modeler
Database Tools
Enterprise data modeling tool for designing and documenting database schemas
SaaS
ER/Studio
Database Tools
Enterprise data architecture and database modeling tool from Idera
SaaS
Dataedo
Database Tools
Data catalog and database documentation tool that generates schema docs and ER diagrams
SaaS
Hackolade
Database Tools
Polyglot data modeling tool for NoSQL, JSON schema, Avro and relational databases
SaaS

