• Stable release: 0.9.2
  • December 26, 2019


  • Purchase
  • Download
  • Source code

  • Project overview
    Some reasons to use pgModeler

    Easy to use

    Create and edit database models easily with a simple and intuitive interface. The forms indicate which fields must be filled in order to provide the correct generation of SQL code.

    Open source

    Get, modify and redistribute the source code without any charge. This project has a public repository that allows forks and full access to the source code. Developers can create their own versions from the existing code.

    Multiplatform

    Built on top of Qt framework, pgModeler can be compiled on Windows, Linux and macOS. The build scripts are easily configurable in order to resolve specific dependencies on each operational system.

    Dynamic code generation

    Design once and export to multiple versions. With its dynamic code generation pgModeler is capable to export the designed models to different versions of PostgreSQL (currently from 9.x to 12.x).

    Plug-ins support

    Missing some functionality? Use the plug-in development interface and create your own extension for pgModeler without change a single line of the core code. See the official plug-ins repository for more details.

    Collaborative development

    Developer or not you can collaborate! Give your feedback with suggestions for improvements, submit UI translations, report bugs and much more via pgModeler's page at GitHub.

    Screenshots
    See what pgModeler is capable of

    Quickly configure connections to use in validation, export, import, diff and management.
    Preview what will change in your database prior to the applying of the diff code
    Tweak almost all pgModeler features on-the-fly!
    Append or prepend any SQL command to an object
    Navigate through your model via overview widget
    Support to canvas layers in order to restrict the visualization to a custom set of objects
    More screenshots

  • Main features
    Surely pgModeler can be integrated to your development tool set

    Handle several types of objects with an easy interface

    pgModeler supports the creation of the most basic object like a simple column as well advanced objects like user-defined languages, functions, operators and many others with easy-to-use forms.

    Automatic generation of columns and constraints

    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 is capable of exporting the models to a SQL script, to a PNG image, to a SVG file, in form of 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

    As an open source tool pgModeler gives the complete access to its source code as well to the contents of any generated file. All created files are XML based which means the user can handle them in third party softwares.

    Restore previous work in case of failure

    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 automatic fixes

    In order to avoid breaking references and/or rules during design time as well when exporting the model to PostgreSQL, pgModeler validates models from time to time. This validation feature produces an almost error-free database model.

    Customizable features

    With an extensive set of configurations pgModeler gives to the user the freedom to customize the majority of its features.

    Generate SQL scripts to synchronize both model and database

    Through the diff feature the user is capable of generating SQL scripts based on the differences between a model and database, or between two databases. The script contains the needed commands to keep synchronized the involved entities.

    Manage existing databases

    pgModeler provides a simplistic yet helpful database management module where is possible to run SQL commands, explore the objects and handle data.

    Command line interface to automate processes

    The CLI offers a good set of operations that do not require the GUI to be running. One of these features is the export process that can be integrated to third party scripts to automate deployment processes. Another useful feature is the model file fix which consists in repair a model's structure to make it loadable again (this feature is also available in the GUI). Many other operations are available too.

    Additional features

    Some other important features are the object finder for large models, the plugin development interface, support to geospatial data types (as implemented by PostGiS 2.x extension), translatable user interface and many others.
    More at documentation

  • Let's help pgModeler?
    Donate to keep alive the development

    pgModeler is brought to you thanks to a great effort to create and distribute a quality product. This project is reaching out levels of maturity never imagined. All this is the result of a joint work between its author and the Open Source community. The software has a long way to go yet and with your help we'll keep maintaining the good job and bringing new improvements in each release. If you did like pgModeler and thinks it deserves a contribution please make a donation via PayPal™. Note that donations don't grant access to binary packages.

    10.00 USD