Moon Modeler

Database modeling tool for PostgreSQL

PostgreSQL data model

Key features for PostgreSQL

Draw ER diagrams
Define entity-relationship diagrams for PostgreSQL easily. and model your database visually.
Reverse engineer
Connect to your PostgreSQL database and visualize existing database structures.
Export to PDF
Share your pixel-perfect diagrams in high-quality printable PDF format.

Create ER diagrams for PostgreSQL

Database modeling features include a visual definition of basic and nested PostgreSQL database structures. Visually design PostgreSQL data models, specify tables, composites, JSON objects, enums, draw relationships among tables and define PostgreSQL table and column specifics.

Quick Start Guide for PostgreSQL

ERD made in Moon Modeler database modeling tool

Quick and comfortable database modeling for PostgreSQL

Create new objects with predefined settings. Change field positions using drag and drop. Add referenced columns to target tables automatically etc. Changes are propagated and saved immediately and in case you need to revert changes, use UNDO. A dark or light theme in UI is only a matter of your preference.

PostgreSQL database modeling, erd with sample data

Keep your database designs
well documented

During your database modeling activities you can arrange PostgreSQL objects in diagrams, colorize items, change the view to show metadata, sample data or descriptions. Add notes in HTML format, connect objects using lines with custom end point graphics or include pictures to your database models. You can also export diagrams to high-quality, vector format, PDF files.

Generated SQL script

Preview and generate scripts

Generate SQL scripts together with other options. When you database modeling for PostgreSQL is finished, click a button on the main toolbar and immediately see code preview.
You can also add custom code to BEFORE and AFTER sections and save scripts for whole your PostgreSQL database modeling project or for just a single PostgreSQL table or relationship.

Database connection
New - reverse engineering included in version for MacOS

Reverse engineer existing structures

Connect to an existing PostgreSQL, MariaDB or MongoDB database platform and reverse engineer database structures with nested documents or JSON. SSH connections are for PostgreSQL are on our roadmap.

Download Moon Modeler
Supported platforms include PostgreSQL, MongoDB, MariaDB, SQLite, Mongoose and GraphSQL.
Moon Modeler for PostgreSQL and other platforms is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.

Key benefits - PostgreSQL database modeling

The following 3 points represent the main benefits for users interested in PostgreSQL database modeling.

1. Blueprint to your own product

A diagram can give you a clear model of your database structure and help you recognize errors. It's like a blueprint to your house. You know what you are building, how to connect the pieces and you have the necessary documentation.

2. Efficient communication

Database modeling allows all your team members or clients to understand the relationships among tables and work with nested JSON in your PostgreSQL structures in an effective manner.

3. Higher productivity

Database modeling activities helps you create your PostgreSQL databases visually, the work is faster, you can avoid typos and make changes quickly.

Looking for a FREE
database modeling tool for PostgreSQL?

Use Moon Modeler. The freeware version allows you to save projects with 10 objects at max.