Moon Modeler

Database design tool for PostgreSQL

and MongoDB, Mongoose, MySQL, MariaDB, SQLite and GraphQL

PostgreSQL database design - Moon Modeler

Key features for PostgreSQL database design

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.

Create documentation

Share your pixel-perfect diagrams in high-quality printable PDF format.

Create database designs for PostgreSQL

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

Quick start guide for PostgreSQL

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 design. ERD in light theme.
PostgreSQL diagram with pictures

Keep your database designs
well documented

When designing a database, you can organize PostgreSQL objects into diagrams, colorize items, add notes in HTML format, connect objects using lines with custom end point graphics. You can also export diagrams to PDF or HTML.

Generate SQL scripts

Generate SQL scripts for your database designs. 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 design or for just a single PostgreSQL table or relationship.

Generated SQL script
PostgreSQL connection
New - reverse engineering included in version for MacOS

Reverse engineer existing structures

Connect to an existing PostgreSQL and reverse engineer database structures with nested documents or JSON. SSH/SSL/TLS connections are supported in the Professional Edition.

Read how to create ERD from Heroku Postgres.

Download

Moon Modeler

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

Download Moon Modeler

Key benefits – PostgreSQL database design

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.

Efficient communication

A good database design allows all your team members or clients to understand the relationships among tables in your PostgreSQL structures in an effective manner.

Higher productivity

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

Purchase

Moon Modeler

You can use the same license key on Windows, Linux and MacOS.
EDU license for students and teachers is available for the Basic Edition.

Basic Edition
$99,-

Go to purchase page

Basic Edition – EDU
$49,-

Request EDU License