Go beyond general-purpose tools or manual DDL writing—you deserve more. pgModeler is the premier design tool built specifically for the PostgreSQL ecosystem.
While general-purpose tools offer basic compatibility, we deliver deep integration with native support for partitions, inheritance, and advanced types.
From seamless reverse engineering to intelligent schema diffing, experience a workflow that understands your database as deeply as you do.
Choose your edition Open Source Freedom or Professional Convenience
Changes since: v1.2.2
This patch release for pgModeler 1.2.x brings the following improvements and fixes:
* [New] Added the method TaskProgressWidget::setNoProgressState.
* [Change] Refactored MainWindow initialization by moving startup timers to a new startOtherTimers method.
* [Change] Improved MainWindow initialization control by overriding the showEvent method.
* [Change] Updated AboutWidget and WelcomeWidget UI layouts.
* [Change] Updated GlobalAttributes with new site URL.
* [Fix] Fixed a bug in DatabaseModel::loadObjectsMetadata that was causing crashes in some circumstances.
* [Fix] Fixed a bug in NumberedTextEditor that was copying all text when hitting Ctrl+C when there was only a portion of the text selected.
* [Fix] Fixed a bug in ModelValidationHelper that was not properly swapping ids between table children objects and their dependencies (e.g., trigger -> function).
* [Fix] Fixed a bug in the Connection class that was creating an invalid connection string when other params were manually specified.
*Changes since:* ***v2.0.0-alpha***
**Summary:** After three months of continuous development since the initial alpha release, pgModeler 2.0.0-alpha1 represents a major milestone in the ongoing UI modernization effort. This release focuses primarily on completing the redesign of all model object editing forms, improving overall usability, and introducing several quality-of-life enhancements that make working with database models more intuitive and efficient. Along with these visual improvements, this version includes important bug fixes and new features that further enhance the stability and functionality of the tool.
**Complete editing forms redesign:** The most significant change in this release is the comprehensive redesign of all object editing forms. Every single form, from simple objects like Roles and Schemas to complex ones like Tables, Relationships, and Constraints, has been modernized with a cleaner, more organized layout. The new design adopts a tabbed interface for complex forms, making it easier to navigate through different configuration sections. All forms now share a consistent visual language with improved label organization, better spacing, and more intuitive control grouping. This redesign not only makes the forms look better but also significantly improves the editing workflow by reducing visual clutter and making related options easier to find.
**Enhanced keyboard navigation:** Recognizing that many users prefer keyboard-based workflows, this release introduces a new tab order manager system that automatically configures the tab order for all editing forms. This means you can now navigate through form fields using the Tab key in a logical, predictable manner without any manual configuration. The system is smart enough to skip hidden or disabled widgets and properly handles Shift+Tab for reverse navigation. This enhancement significantly speeds up data entry and makes the application more accessible to keyboard-centric users.
**Improved visual feedback:** To make the interface more responsive and intuitive, this version introduces subtle visual effects throughout the application. Input widgets, buttons, checkboxes, and radio buttons now feature custom hover effects that provide immediate feedback when you interact with them. Focus borders have been added to checkboxes and radio buttons, making it clearer which element is currently selected. Progress bars now display smooth busy indicator animations during long-running operations. These small touches combine to create a more polished and professional user experience.
**Modernized code preview:** The code preview functionality has been completely overhauled with a more capable and user-friendly widget that replaces the old implementation. The new code preview offers better syntax highlighting, improved filtering capabilities, and a cleaner interface that makes reviewing generated SQL and XML code much more pleasant. This is particularly useful when inspecting complex database objects or troubleshooting code generation issues.
**Object associations visualization:** Understanding the relationships between database objects is crucial for effective database design. This release introduces a new object associations viewer that provides a much clearer and more intuitive view of how objects are connected. The improved interface makes it easier to track dependencies and references, helping you understand the impact of changes before applying them to your model.
**Enhanced CLI capabilities:** The command-line interface has received several improvements in this release. The help menu now features automatic line wrapping with sentence-based breaks, making it much easier to read on narrow terminals. Support for version-only printing has been added, which is particularly useful for integration with deployment pipelines and automation scripts. These enhancements make pgModeler-CLI more versatile and easier to use in automated workflows.
**Quality and stability improvements:** Beyond the visible changes, this release includes numerous under-the-hood improvements. Several crash bugs have been fixed, including issues when editing connections while browsing databases and crashes in the model export widget. Memory management has been improved with fixes for critical memory-related issues. The validation system now catches more potential issues, such as foreign keys with SET NULL actions tied to NOT NULL columns. These fixes contribute to a more stable and reliable application.
**Experimental features:** This release introduces experimental support for disabling name quoting, allowing pgModeler to treat object names as case-insensitive. This feature addresses a long-standing request from users who prefer to work with unquoted identifiers. While still experimental, it represents progress toward supporting different naming conventions and workflows.
**Visual refinements:** The application's visual identity continues to evolve with updated logos and icons that maintain the flatter, more colorful style introduced in the alpha release. Numerous small UI adjustments throughout the application improve consistency and polish. The theme system has been refined with better detection and more sophisticated rendering of various UI components.
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.
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.
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.
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.
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.
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.
The first release officially under the umbrella of Nullptr Labs.
The release of pgModeler 2.0.0-alpha1 marks an important evolution in the project’s history, signaling its official move under the professional banner of Nullptr Labs. This transition from a solo endeavor to a dedicated startup ensures the long-term sustainability of the tool we love, allowing for faster innovation and professional-grade support without losing our community-driven spirit. At the heart of this milestone is a complete modernization of the user experience. Every single object editing form has been redesigned with a clean, tabbed interface that simplifies complex database design, complemented by a brand-new code preview engine and an intuitive object associations viewer. Beyond the aesthetics, this version prioritizes workflow efficiency with smart keyboard navigation and a more robust command-line interface for modern DevOps pipelines. As we march toward the stable 2.0 release, we are also unveiling an ambitious roadmap for pgModeler Plus, which will soon feature native Git integration and AI-powered management tools. Our long-term vision is to introduce a dedicated AI modeling assistant, elevating pgModeler from a design tool to an intelligent engineering partner. This alpha release is more than just an update; it is an invitation to join us in this new chapter. Download the alpha, explore the changes, and let’s build the future of pgModeler together!
The access to binary packages has changed. You must create a download token in the key management section before proceeding with the download.
Get source code
pgModeler has two main development branches: main and develop. The main branch is where features considered stable can be found. The development branch, reserved for alpha and beta releases, is where patches, new unstable features are placed and tested.
You can retrieve the source using the git command by running the following:
If you prefer, there are source tarballs ready to be compiled. Once you got the source, you can follow the instructions to compile pgModeler described in the Installation page.
Do you really want to generate a new token for this user? The current token will be invalidated and a new one will be sent by email.
Terms and Conditions
Data Privacy Terms
Access key recovery
Preparing your
payment, please wait...
Do not close the page or cancel the loading!
Payment invoice
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.
10.00 USD
Preparing your
donation, please wait...
Do not close the page or cancel the loading!
Purchase successful
Thank you for your purchase! In a few minutes you'll receive an email containing the instructions on how to download your packages as well some important notes about your purchase. Note that some email servers can flag the email as spam so make sure to check your SPAM box too. In case of problems, please contact the developer from the Support menu.
Enjoy pgModeler!
Contact the developer
For feature requests or bug reports we kindly ask you to open a ticket on the GitHub issues page.
