Native PostgreSQL schema engineering

Supports 30+ PostgreSQL object types including domains, custom types, operators, collations, procedural languages, event triggers, foreign data wrappers, extensions, and more.

Relationships automatically propagate FK columns, constraints, and indexes with PostgreSQL-aware DDL generation.

Compares models against live PostgreSQL databases and generates minimal ALTER/DROP/CREATE statements for controlled schema synchronization.

Reconstructs editable PostgreSQL models including views, functions, triggers, RLS policies, inheritance, partitions, extensions, and more.

Create, visualize, validate, and export PostgreSQL RLS policies directly in the model.

Native support for PostgreSQL table inheritance with correct diagram representation and DDL generation.

Model PL/pgSQL functions, procedures, and triggers directly in the schema with full source export support.

Supports declarative PostgreSQL partitioning (RANGE, LIST, HASH) including partition definitions and child partitions.

Detects broken references, circular dependencies, naming conflicts, and PostgreSQL rule violations before deployment.

Run exports, diffs, validation, and deployments through command-line workflows and automation pipelines.

Models stored as plain XML files designed for Git workflows, diffs, scripting, and long-term accessibility.

Export models as SQL, PNG, SVG, HTML data dictionaries, and deployment scripts from a single source model.

Fully local PostgreSQL modeling and engineering workflow with offline-capable usage and no mandatory cloud infrastructure. Commercial editions use periodic license validation without requiring cloud-hosted workflows.

Fully open-source under GPL with source-code access and self-compilation support.

Flexible licensing focused on ready-to-run binaries, perpetual ownership options, and sustainable independent development.

Open model format, local-first workflows, and no proprietary hosted backend dependency.

Models remain accessible independently of hosted infrastructure or subscription continuity.

PostgreSQL-native schema engineering, architecture design, reverse engineering, and advanced database lifecycle workflows.

Deep PostgreSQL specialization combined with independent, sustainable, and ownership-friendly tooling.

Design tables, views, schemas, functions, operators, custom types, domains, sequences, triggers, row-level security policies, and more — pgModeler covers the breadth of PostgreSQL's object model natively.

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.

pgModeler can export the models to a SQL script, to a PNG image, to an SVG file, in the form of a data dictionary in HTML format, or directly to a PostgreSQL server.

Model files are stored in open, human-readable XML. You can diff them line-by-line in Git, process them with standard tooling, or inspect them in any text editor — no proprietary format, no vendor dependency.

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.

The validation engine checks cross-object references and constraint rules at design time, surfacing errors before deployment. Most issues can be fixed automatically.

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

Export DDL, run diffs, and automate schema deployments without launching the GUI. Designed to integrate cleanly into CI/CD pipelines and scripted workflows.

Geometry and geography types are recognized natively — not treated as unknown custom types. Design spatial schemas without workarounds.

Connect to any live PostgreSQL server and reconstruct a full schema model from your existing database. Useful for documenting production systems, recovering legacy designs, or baselining a schema for ongoing lifecycle management.

Compare your schema model against a live PostgreSQL server and generate the exact ALTER, DROP, and CREATE statements needed to bring them in sync — no hand-written migrations.

Browse schemas, run SQL commands, and manage data directly in the built-in module — no need to switch to an external client for day-to-day operations.

Integrated SSH tunneling support for secure remote connections.

Allows saving objects in separate files to improve version control management (Git).

Persist your opened tabs and connections in the database management module.

Use variables in your SQL scripts to facilitate testing and execution.

Integrated interface for pg_dump and pg_restore tools.

Shortcuts and wizards to create objects faster.

Global search tool to find and edit objects anywhere in your model.

Other notable features include an object finder for navigating large models, a plugin development interface, a translatable user interface, and much more. For a comprehensive overview of all pgModeler's features, visit the official documentation.