nullptrlabs/pgmodeler

Health v2 · maintenance only

Adoption not part of the score

3585 stars · 422 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

pgModeler is an open-source, cross-platform visual database modeling tool built specifically for PostgreSQL, letting users design entity-relationship diagrams and generate DDL/SQL scripts without hand-writing them. It is written in C++ with Qt and offers a free Community Edition plus a commercial Plus edition with reverse engineering, diff/sync, and database management features.

Use cases

• design a postgresql database schema visually with an ER diagram
• generate DDL SQL scripts from a database model instead of typing them
• model tables, views, relationships, triggers and functions for postgres
• validate a database model for inconsistencies before deployment
• teach database modeling with an open-source ERD tool
• maintain complex postgres schemas with version-controlled model files

When to choose

• you work primarily with PostgreSQL and want deep support for its specific features
• you prefer visual drag-and-drop schema design over writing DDL by hand
• you want a free, open-source, cross-platform modeling tool with no cloud dependency
• you need Git-friendly schema model files stored locally

When to avoid

• you need reverse engineering or database diff/sync, which require the paid Plus edition
• you model databases other than PostgreSQL (e.g., MySQL, SQL Server)
• you only need a lightweight SQL client or query browser rather than a modeler

Facets

application · maturity active

gui developer-tools database documentation databases developer-tools web-development windows cross-platform postgresql erd data-modeling ddl-generation sql qt schema-design reverse-engineering database-diff linux macos desktop

Member repositories

For agents

markdown · JSON · MCP: product_card(name="nullptrlabs/pgmodeler")