pgmodeler

Open-source data modeling tool designed for PostgreSQL. No more typing DDL commands. Let pgModeler do the work for you!

What is pgmodeler?

Open-source data modeling tool designed for PostgreSQL. No more typing DDL commands. Let pgModeler do the work for you!

Overview of pgmodeler

What it is

pgModeler is a PostgreSQL-first, multiplatform database modeling platform designed specifically for the PostgreSQL ecosystem. It is built with C++ and Qt, delivering native performance on Linux, Windows, and macOS. The platform is distributed in two editions: pgModeler Community (open source under GPL-3.0) and pgModeler Plus (commercial). The Community Edition focuses on visual modeling, PostgreSQL schema design, SQL generation, and educational or development workflows. pgModeler Plus extends the Community Edition with advanced database lifecycle management capabilities for professional and enterprise environments. Revenue from pgModeler Plus funds the continuous development and long-term sustainability of the project. The project is officially backed by Nullptr Labs.

Key features

  • Visual modeling: Create and edit complex relational schemas through an intuitive drag-and-drop interface. Manage tables, views, relationships, functions, operators, and many other PostgreSQL-specific objects.
  • Schema generation: Generate high-quality SQL scripts directly from visual models while preserving PostgreSQL compatibility and advanced object definitions.
  • Validation and consistency tools: Detect modeling inconsistencies, broken references, and dependency issues before deployment.
  • Cross-platform native experience: Built with C++ and Qt, delivering native performance on Linux, Windows, and macOS.
  • Reverse engineering (Plus edition): Connect to existing PostgreSQL instances and generate complete visual representations of live databases.
  • Database Diff and Synchronization (Plus edition): Compare models against databases or other model files and generate precise synchronization scripts automatically.
  • Integrated database management (Plus edition): Execute SQL commands, browse data, and manage database objects through a streamlined administration interface.

Use cases

pgModeler is suitable for designing a new database system from scratch, maintaining large and complex PostgreSQL infrastructures, generating production-ready SQL scripts, and educational or development workflows. The Plus edition is designed for teams, consultants, DBAs, and large-scale PostgreSQL deployments requiring reverse engineering, database diff and synchronization, and integrated database management.

Getting started

Detailed, step-by-step guides for compiling from source are available in the installation section of the repository. For pre-compiled packages, visit the official website. See the repository README for build and installation instructions.

License and pricing

The pgModeler Community Edition is free software distributed under the terms of the GNU General Public License v3 (GPLv3). pgModeler Plus is a commercial edition with a paid license available on the official website. The names pgModeler, Nullptr Labs, and their associated logos and visual identities are registered trademarks and intellectual property of Nullptr Labs.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/nullptrlabspgmodeler.svg)](https://yunodb.com/tools/nullptrlabspgmodeler?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/nullptrlabspgmodeler?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/nullptrlabspgmodeler.svg" alt="Featured on YunoDB" height="20"></a>