Skip to main content

Native PostgreSQL data modeling

pgModeler is a specialized open-source and multi-platform PostgreSQL database modeler that features a powerful visual interface — no DDL commands required. It leverages a sophisticated code generation engine to support the database's vast specificities with ease. Purchase a license to get instant, ready-to-run binaries and directly fund Nullptr Labs, ensuring you save time while keeping the project independent and evolving.

See it in action

Stable release

1.2.3

February 06, 2026 | Release notes


  • Source code

    Alpha release

    2.0.0-alpha1

    February 13, 2026 | Release notes


  • Source code

    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.

    Feature breakdown
    Comparing editions side-by-side

    Description
    Plus version

    Open-source
  • Software distribution
    Precompiled packages / Paid Source-code / Free of charge
  • 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.

  • What developers say
    Trusted by database professionals worldwide

    Project news
    Latest updates from the team

    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

    Screenshots
    See what pgModeler is capable of


    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