Blog
Stay tuned with all pgModeler news.

The future of pgModeler Project

A path toward sustainability

After nearly 20 years of continuous open-source development, pgModeler is entering a new phase focused on long-term sustainability, independence, and continuous evolution. As the project approaches version 2.0, maintaining advanced features has reached a level of complexity and engineering effort that is no longer sustainable under the current financial model. Starting with version 2.0.0-beta, the advanced database lifecycle management features will continue development exclusively in the commercial pgModeler Plus edition. pgModeler Community will remain free and open source, continuing to receive active maintenance, PostgreSQL compatibility updates, performance improvements, bug fixes, and ongoing evolution as the foundation of the platform itself. This transition is intended to ensure that pgModeler remains independent, professionally maintained, and able to continue serving the PostgreSQL ecosystem for many years to come.

Read more

We're glad to announce pgModeler 2.0.0-alpha1!

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!

Read more

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.

Read more
A new chapter: Introducing Nullptr Labs

A new chapter: Introducing Nullptr Labs

A company created to secure the longevity of pgModeler

Nullptr Labs is now the official home of pgModeler, marking the project's transition into a solid corporate structure. This move ensures the software's longevity, guaranteeing consistent releases and technical innovation for years to come. Aiming to gain further ground in the PostgreSQL market, Nullptr Labs introduces a more flexible business model, including tailored licensing and custom development for specific features required by enterprise clients. Despite this commercial evolution, our commitment to code transparency and the open-source community remains unchanged. Our focus is to consolidate pgModeler as a robust and efficient data engineering tool, fully prepared for the demands of today's market.

Read more
pgModeler 2.0.0-alpha is finally here!

pgModeler 2.0.0-alpha is finally here!

The beggining of a new era for the project.

The pgModeler 2.0.0-alpha release introduces significant improvements aimed at enhancing usability, flexibility, and maintainability. One of the most notable changes is the migration of the build system from qmake to CMake. The user interface has also received a major update. While still a work in progress, this alpha version introduces a refreshed logo, updated icon colors with a flatter and more colorful style, and the integration of the configuration form and core tools — diff, import, export, and fix — directly into the main window. The diff tool has been enhanced with a new model-to-model comparison mode, allowing offline comparisons between two loaded database models and generating the corresponding SQL diff for later application. Import and export tools have undergone similar refinements. Components have been reorganized for a cleaner interface, allowing users to freely choose which models to operate on, rather than being restricted to the active model. This ensures a smoother and more intuitive experience across all data handling operations. For more details, please read the full post; don't skip it!

Read more

pgModeler 1.2.0 is finally ready!

Closing the 1.x development cycle.

pgModeler’s new release delivers 72 features, 93 improvements, and 74 fixes. Debugging capabilities now include dedicated log tabs for import and diff operations. The user can now visualize the SQL code from multiple selected objects. Relationships now generate indexes on foreign-key columns. The layer management now supports synchronizing visibility between tables and their relationships. Export operation can run transactionally for atomic DDL execution (except database and tablespace creation commands). The SQL editor's code completion now handles ALTER/DROP commands and ORDER BY columns. In the manage view, the handling form now uses a tabbed interface for better data visualization. The schema microlanguage supports escaped metacharacters and file includes. Data dictionaries can now be exported to Markdown format. The configuration files are now migrated more smoothly from prior major versions. The Plus edition adds plugins for quick constraint/index/relationship creation and query variable testing. The support for Qt 6.2 and 6.3 was dropped to simplify the codebase maintenance, and now Qt 6.4+ is required. Those and many other key changes are fully detailed in this post, so don't skip them!

Read more

I proudly announce pgModeler 1.2.0-beta1!

UX/UI enhancements, pgModeler Plus, and much more!

This release delivers some cool improvements to database modeling capabilities. The SQL source code editor has been upgraded with per-instance line wrapping controls and a built-in search/replace widget, centralizing these functions while removing redundant search implementations across the application. The debugging workflows are enhanced through dedicated output tabs in both database import and diff forms, providing clearer visibility into operations. When running in debug mode, the import form now remains open, allowing users to examine the executed commands and generated objects' code. The diff tool reintroduces the forced object re-creation option with added granularity - users can now select specific object types for re-creation through a dedicated popup menu in GUI. The SQL generation offers finer control by permitting disabled code segments to be included in output SQL scripts when needed. The extension objects received a better child object tracking (currently supporting types and schemas) and proper handling of custom schema names in managed data types. Those and some other user experience refinements are described in the full post.

Read more

pgModeler 1.2.0-beta is out!

One step closer to stable release!

This release brings two interesting features that will improve the design process by diminishing repetitive operations while speeding up the object creation process. The first one is the automatic creation of indexes on the columns generated by relationships. The other feature introduced through an exclusive plugin in the paid version of the tool allows the creation of constraints, indexes, and relationships based on the objects selected in the design view without the need to open a single editing form or fill lots of fields. There are some bug fixes and other minor improvements too. Everything is covered in the full post, don't miss it!

Read more
Hooray! pgModeler 1.2.0-alpha1 is here!

Hooray! pgModeler 1.2.0-alpha1 is here!

Lots of enhancements aiming at productivity increasing.

After 4 months of work, I'm quite happy to announce another release of our beloved PostgreSQL database modeling tool! This version brings 23 new features, 22 improvements, and 14 fixes since the release of the previous alpha. This time, some important decisions were taken to make the code base a bit less complicated to maintain, at the same time some other portions of the tool were refactored to allow plugins' development to be more flexible. New features and important changes are also included, and I hope they will improve the tool's usage. Briefly speaking, this release introduces some nice features that can help in productivity. In the database modeling process, 1.2.0-alpha1 introduces a new way to quickly configure and assign layers to objects. The SQL export operation can be executed in a transaction block for atomic command executions, reverting changes if a single error occurs. In the SQL execution widget (in the management view), the code completion widget is now triggered for ALTER/DROP commands. Also, we're presenting the support for query variables which facilitates the test of queries using different variable formats adopted by ORMs. Finally, the data handling form received an important patch and now reunites the browsed tables in tabs drastically diminishing the use of standalone windows which could be confusing for the users. Everything will be fully explained in the full post, don't miss it!

Read more

Say hello to pgModeler 1.2.0-alpha!

Another development cycle starts aiming new features!

After a work of three months here we are announcing pgModeler 1.2.0-alpha which bundles 20 new features, 26 improvements, and 22 bug fixes. Most are not directly visible to the user but will enhance the overall experience when designing database models or managing live databases. This version brings important changes to the schema microlanguage, improving the code reusability when writing schema files for code generation. This new pgModeler also supports markdown data dictionaries and a redesigned routine that copies legacy configuration files. Finally, there were several improvements in the SQL code generation and bug fixes here and there. Everything is detailed in this blog post, don't miss it!

Read more