pgModeler - PostgreSQL Database Modeler

Intuitive data modeling

Dynamic code generation

Built-in database management

Forward and reverse engineering

Full-featured comparison tool

Fully customizable UI

pgModeler is an open-source, cross-platform platform designed for professional PostgreSQL database modeling. Developed by Nullptr Labs, it stands as a premier solution in the PostgreSQL ecosystem, delivering a robust interface for efficient data modeling and rapid deployment.

Choose your edition
Open Source Freedom or Professional Convenience

Stable release

1.2.3

February 06, 2026

Ready for production environments.

Source code

View release notes

Get full access

Unlock the full potential of pgModeler.

No limitations. Perpetual license.

Purchase license

Manage key

Download full

Feature highlights
Everything you need to build scalable databases

Intuitive design

Create basic and advanced objects with ease. From simple tables to complex definitions like functions and operators, our intuitive UI streamlines the entire process.

Reverse engineering

Import existing databases instantly. Visualize your current schema and refactor legacy systems with our powerful reverse engineering engine.

Model-database diff

Synchronize your models with your servers. Generate SQL scripts to apply changes automatically without writing DDL commands by hand.

Validation & fixes

Automatic model validation ensures your design is error-free before deployment. Fix broken references and rule violations instantly.

Quick automation

Automatically generate columns and constraints when linking tables. Create indexes and relationships directly from the design view.

SQL tool

Manage your data without leaving the app. Browse schemas, execute SQL commands, and interact with your database using the built-in module.

CLI automation

Integrate into your CI/CD pipelines. Export models, comparisons, and validations using the robust Command Line Interface.

SSH tunneling PLUS

Secure your remote connections. Integrated SSH tunneling provides enterprise-grade security without complex VPN setups.

Team collaboration PLUS

Work together seamlessly. The split-model format allows effective version control (Git) by storing objects in separate files.

Comparison chart

Feature breakdown
Comparing editions side-by-side

Description	Open-source	Plus version
Software distribution	Source-code / Free of charge	Precompiled packages / Paid
Handle several types of objects pgModeler supports the creation of the most basic object like a simple column as well as advanced objects like user-defined languages, functions, operators, and many others.
Automatic generation of columns With the column propagation mechanism, pgModeler automatically creates all columns and constraints as the user links tables using the available relationship objects avoiding repetitive tasks and improving productivity.
Export models in five different ways pgModeler can export the models to a SQL script, to a PNG image, to an SVG file, in the form of a data dictionary in HTML format, or directly to a PostgreSQL server.
Generate models from existing databases With the reverse engineering process, pgModeler can create reliable models based upon existing databases.
XML based files for easy versioning As an open-source tool, pgModeler gives complete access to its source code and the contents of any generated file. All created files are XML based.
Restore previous work in case of failures In case of unexpected quit, the user doesn't lose all the work because pgModeler stores temporary models with the most recent changes and will restore them in the next startup.
Model structure validation and fixes Validation feature produces an almost error-free database model by checking references and rules during design.
Customizable features With an extensive set of configurations, pgModeler gives the user the freedom to customize most of its features.
Model-database sync (Diff) The diff feature generates SQL scripts to synchronize models and databases, based on their differences.
Manage existing databases pgModeler provides a simplistic yet helpful database management module where it is possible to run SQL commands, explore the objects, and handle data.
Command-line interface (CLI) The CLI offers a good set of operations that do not require the GUI to be running (export, diff, fix, etc).
Secure database connections via SSH Integrated SSH tunneling support for secure remote connections.
Split database model format Allows saving objects in separate files to improve version control management (Git).
Save and restore sessions Persist your opened tabs and connections in the database management module.
Query variables for SQL testing Use variables in your SQL scripts to facilitate testing and execution.
Database backup utilities Integrated interface for pg_dump and pg_restore tools.
Quickly create objects Shortcuts and wizards to create objects faster.
Quickly search and edit objects Global search tool to find and edit objects anywhere in your model.
Additional features Other notable features include an object finder for navigating large models, a plugin development interface, support for geospatial data types (as implemented by the PostGIS extension), a translatable user interface, and much more. For a comprehensive overview of all pgModeler's features, visit the official documentation.

Features highlight

Project news
Latest updates from the team

Feb

2026

Moving forward: pgModeler 1.2.3 and our new business model

Marking a historic milestone in this project

Today we are releasing pgModeler 1.2.3. While this version brings important stability fixes and UI refinements, it also marks a historic milestone in our journey: the official implementation of our new business model under Nullptr Labs. As the project grows, we need a structure that allows us to keep innovating and providing professional-grade support. In this post, we bring important details about what is changing and how you can manage your access moving forward.

0 Comments bugfixes newversion nullptrlabs 1.2.3

Secure your database connections with SSH tunnels (paid version exclusive feature)!

Change the relationships connection mode and name generation patterns.

Tweak almost all pgModeler features on-the-fly!

Navigate through your model via overview widget.

Identify how many objects depend on or are referenced by the current object.

Have a huge model? Need to find a specific object? We introduce to you the object finder!

The backup utility plugin helps to create and restore database backups (paid version feature)

More screenshots

Support Development
Invest in the tools you use

Why Donate?

pgModeler is proudly maintained by Nullptr Labs. While open source, continuous development requires significant resources.

By contributing financially, you ensure the project's long-term sustainability. If pgModeler adds value to your workflow, consider supporting its evolution.

This is a voluntary contribution to open-source development and does not grant access to pre-compiled binaries. To purchase the installer, please visit the Purchase section.

Amount:

10.00 USD

Donation method:

Choose your editionOpen Source Freedom or Professional Convenience

Stable release

Get full access

Feature highlightsEverything you need to build scalable databases

Feature breakdownComparing editions side-by-side

Project newsLatest updates from the team