Skip to content


Subversion checkout URL

You can clone with
Download ZIP
pgModeler - PostgreSQL Database Modeler - is an open source data modeling tool designed for PostgreSQL. No more DDL commands written by hand let pgModeler do the job for you! This software reunites the concepts of entity-relationship diagrams and the features that PostgreSQL implements as extensions of SQL standards. Support this project by dona…
C++ Eagle QMake Shell Inno Setup Prolog

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.


PostgreSQL Database Modeler, or simply, pgModeler is an open source tool for modeling databases that merges the classical concepts of entity-relationship diagrams with specific features that only PostgreSQL implements. The pgModeler translates the models created by the user to SQL code and apply them onto database clusters from version 8.0 to 9.1.

Please, let me know how the pgModeler is working on your system! Help to improve this project, give your feedback about the software or report any bug at Issues page. Additionaly, follow the pgModeler profile on Facebook or Twitter and be up-to-date with new features, fixes and releases.


This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation version 3.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

See LICENSE for details.

Donate to pgModeler

Making a software is no easy task! With pgModeler was no different. Much effort, coffee, chocolate, time and knowledge has been devoted to the project so that a usable and constantly improved product is delivered to the community free of charge.

Despite all many feature contribution all open source project needs sometimes a financial incentive, this way the developer realizes that his product is even more valuable.

If you like the project and think it deserves a contribution please donate any amount (via PayPal) on project's official site. The pgModeler's author will be immensely grateful for your support and will continue to improve the tool until its maximum pontential.

Developers and Reviewers wanted!

pgModeler grow bigger and reached a state that its lonely developer cannot handle all the modification and new features requests as well to create a user's manual. So if you know C++ and Qt framework programming and wants to contribute with coding or an user's manual let me know! I'll be grateful for any help to the project!


For details about installation process from source code see If you don't want to compile pgModeler there are binaries available for download at Downloads section.

Known bugs

  • pgModeler in some situations can crash when undo / redoing operations. This is still in a deep investigation but the causes were not yet discovered.

Change Log


Release date: March 19, 2013

  • [Change]: user can now prepend a CTE (commom table expression, a.k.a "with queries") on view's definition.
  • [Change]: user can now create a single reference containing a expression that defines the entire view.
  • [Change]: improvements on permissions, user now can control GRANTs and REVOKEs via permission editing form.
  • [Fix]: fixed invalid UTF-8 chars on function definition.
  • [Fix]: fixed unavailable "nocreatedb" role option.

The complete change log can be found on file.

Older Releases/Code

The older code and releases of pgModeler can be found at

Something went wrong with that request. Please try again.