Luna Modeler
is a powerful database design tool for relational databases

for SQL Server, PostgreSQL, MariaDB, MySQL and SQLite database design

PostgreSQL Database Design

Easy-to-use database design tool

Luna Modeler is an easy-to-use data modeling and database design tool for many popular databases. The software allows database developers to design database structures and generate SQL scripts for SQL Server, PostgreSQL, MariaDB, MySQL and SQLite. You can also use Luna Modeler to visualize existing databases, enhance entity-relationship diagrams, and generate interactive documentation with database diagrams.

Download Luna Modeler Compare editions

Version 7.5 available

  • Search and find on diagram
  • Windows authentication for SQL Server (Windows)
  • Compression column (PostgreSQL)
  • Project repair
  • Fixes for known issues

Read what's new

What you can do
with Luna Modeler?

Create ER diagrams
For relational databases like SQL Server, PostgreSQL, MariaDB, MySQL and SQLite
Reverse engineer
Create an ER diagram from existing databases or import a SQLite structure.
Create documentation
Share your pixel-perfect diagrams in PDF format or generate interactive HTML reports.
Generate SQL scripts
Preview and save DDL / SQL script for your complex database designs or selected database object.

Draw ER diagrams for relational databases

Use Luna Modeler for database design, data modeling and drawing entity relationship diagrams. Quickly define database objects such as tables, columns, keys, indexes, and draw relationships visually in your data models.

Read Quick Start Guides

Edit objects in your ER diagram quickly and easily

You can edit individual properties of your database design very quickly in the panel on the right side. Larger forms help you easily view more details, where you can use elements that can be easily expanded or collapsed. Use Luna Modeler to accelerate your data modelling tasks.

ERD Column Detail form in Luna Modeler, a data modeling tool
SQL script generated by Luna Modeler data modeling tool

Generate SQL scripts

Preview and generate SQL scripts for your database designs and diagrams. You can preview and save SQL scripts for whole your database design or for just a single database table or relationship.

Connect to existing databases and generate ER diagrams

Establish connections to existing SQL Server, MariaDB, MySQL, SQLite or PostgreSQL databases, run reverse engineering and create database diagrams automatically. In the Professional Edition of you can establish SSH/SSL/TLS connections to all supported database systems.

See video Read more about reverse engineering

Database connection created for PostgreSQL, multiple schema selection
ER Diagram creation with Luna Modeler | Project update

Compare & update your database diagrams

Compare your database design to the structure that exists in the database and easily update your project. See what objects no longer exist in the database, what objects have been added to the database, and what objects are different.

See video Read about Project Update

Create documentation

When designing a database, you can arrange objects into sub-diagrams, add HTML notes etc. A dark or light theme is just a matter of your preference. At any stage of the design process, you can easily generate an interactive HTML report to create useful documentation.

See video Read more about report generation

Database report creation in Luna Modeler - data modeling tool

Key benefits of Luna Modeler
data modeling and database design tool

A picture is worth a thousand words

Blueprint to your own product: A diagram can give you a clear model of your data 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: Luna Modeler helps team members understand relationships between tables and other objects in database diagrams in an efficient way.

Faster development: Draw database diagrams and generate code. Avoid typos, make changes quickly.

Increased Productivity: Luna Modeler data modeling tool helps increase your productivity by enabling rapid database design and automating repetitive tasks such as generating SQL scripts, creating database diagrams from existing databases, and generating interactive reports.

Cost-Effective Solution: The data modeling tool is a cost-effective solution because it helps to reduce the development time and effort required to create the database. This ensures that the project is completed within budget and on time.

Download Luna Modeler
For SQL Server, PostgreSQL, MariaDB, MySQL and SQLite
Trial version expires 14 days after installation.

Windows OS
Windows Installer

Version: 7.5.0 | Tested on Windows 11

Linux AppImage

Version: 7.5.0 | Tested on: Ubuntu 22.04

Windows OS
Apple chip Intel chip

Version: 7.5.0 | Tested on: MacBook Air & Mac M1
Purchase Luna Modeler

Data modeling tool for relational databases
Perpertual license with 12 months free updates included.
User-based licensing model. One license key can be used on Windows, Linux and MacOS.

Basic Edition
Go to purchase page
Professional Edition
$ 189,-
Go to purchase page
Basic Edition - EDU
Request EDU License
Want to get in touch?

Send Email to