Luna Modeler

ERD Creator for PostgreSQL

and SQL Server, MySQL, MariaDB, SQLite

Key features of the ERD Creator for PostgreSQL

Create ER diagrams

Define entity-relationship diagrams for PostgreSQL easily and model your database visually.

Load and compare

Connect to your PostgreSQL database and create ERD from existing databases.

Make documentation

Generate reports or export pixel-perfect diagrams in high-quality PDF format.

Generate SQL scripts

Preview, generate and save SQL scripts for your PostgreSQL databases.

Create ERD for PostgreSQL

Visually design PostgreSQL ER diagrams. Specify tables with columns, PostgreSQL specific objects like composites, enums, domains or other classic database objects like database functions, triggers etc. Draw relationships and define PostgreSQL schema easily.

Quick start guide for PostgreSQL

Easy and fast PostgreSQL database design

Create new objects with predefined settings.
Copy and paste tables or columns
Change field positions of table columns using drag and drop.
Add referenced columns to target tables automatically

Changes are propagated and saved immediately.

Make ERD from existing PostgreSQL databases

Connect to an existing PostgreSQL and reverse engineer your database.
SSH/SSL/TLS connections are supported in the Professional Edition.

Generate SQL scripts

Generate SQL scripts for your PostgreSQL database designs. Click a button on the main toolbar and immediately see code preview. You can save scripts for whole your PostgreSQL ERD or for just a single database table or relationship.

Download

Luna Modeler

Luna Modeler is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.

Download Luna Modeler

Key benefits of the ERD Creator for PostgreSQL

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.