What is pgModeler?

pgModeler is an impressive, multiplatform database modeler for PostgreSQL. It is a project that aims to be a leading database design tool within the PostgreSQL ecosystem. With its extensive range of features, pgModeler enables quick and efficient data modeling and seamless code deployment to a server.

Additionally, it offers reverse engineering capabilities, allowing users to visually represent existing databases. Furthermore, pgModeler has the capability to generate SQL scripts, facilitating the synchronization between a model and a database through a process known as "diff". It is important to emphasize that pgModeler is not solely focused on modeling, as it also includes a minimalist yet functional module for database server administration.

This module empowers users to execute various SQL commands, browse databases, and handle data through a straightforward and intuitive user interface.

Features

  • Impressive, multiplatform database modeler for PostgreSQL
  • Quick and efficient data modeling
  • Seamless code deployment to a server
  • Reverse engineering capabilities to visually represent existing databases
  • Generation of SQL scripts for database synchronization (diff)
  • Minimalist yet functional module for database server administration
  • Execution of various SQL commands
  • Browsing databases and handling data through a user-friendly interface
  • Easy creation and editing of database models
  • Simple and intuitive interface with forms indicating required fields for correct SQL code generation
  • Open source with a public repository for modification and redistribution of the source code
  • Multiplatform compatibility (Windows, Linux, macOS)
  • Dynamic code generation for exporting designed models to different versions of PostgreSQL (from 10 to 15)
  • Plug-in support for extending functionality without modifying the core code
  • Collaborative development with opportunities for feedback, suggestions, translations, bug reporting, and more via pgModeler's GitHub page

Platforms

  • Windows
  • Linux
  • macOS

License

  • GPL-3.0 License

Resources & Downloads

pgModeler - PostgreSQL Database Modeler
Open source data modeling tool designed for PostgreSQL. No more DDL commands written by hand. Let pgModeler do the job for you!
GitHub - pgmodeler/pgmodeler: Open-source data modeling tool designed for PostgreSQL. No more typing DDL commands. Let pgModeler do the work for you!
Open-source data modeling tool designed for PostgreSQL. No more typing DDL commands. Let pgModeler do the work for you! - GitHub - pgmodeler/pgmodeler: Open-source data modeling tool designed for P…