Luna Modeler

is a modern database design tool
for relational databases like SQL Server, PostgreSQL, MariaDB, MySQL and SQLite

SQL Server ERD - database design

Version 6.1 released!

Added support for SQL Server!
New comparison reports available
Support for multiple instances and more...

Read what's new in version 6

What you can do
with Luna Modeler?

Draw ER diagrams
Create designs for relational databases: SQL Server, PostgreSQL, MariaDB, MySQL and SQLite
Reverse engineer
Create an ER diagram from existing databases or import a SQLite structure.
Create reports
Share your pixel-perfect diagrams in PDF format or generate interactive HTML reports.
Generate scripts
Preview and save SQL scripts and generate custom code for existing objects.

Create ER diagrams for relational databases

Draw database designs for popular databases like SQL Server, PostgreSQL, MariaDB, MySQL or SQLite. Define database objects such as tables, keys, indexes, and draw relationships graphically in your entity relationship diagrams.

Read Quick Start Guides

Edit properties quickly
and conveniently

There is a right side panel where you can modify individual properties very quickly. If you need to define, for example, an SQL script, open the selected object in a larger, separate form.

ERD - column detail
Relational database - ERD

Compare a project with your database and generate a report or update the project

You can now compare your project to the structure that is 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. In version 6 you can also generate a detailed HTML report.

See video Read about Project Update

Keep your database designs well documented

When designing a database, you can organize objects into sub-diagrams, colorize items, add notes in HTML format, connect objects using lines with custom end point graphics. Dark or light theme in the UI is just a matter of your preference.

See video Read more about report generation

Database report
Generated SQL script

Preview and generate 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 database design or for just a single table or relationship.

Reverse engineer existing structures

Connect to existing SQL Server, MariaDB, MySQL or PostgreSQL databases and reverse engineer database structures. In the Professional Edition of the data modeling tool you can establish SSH/SSL/TLS connections to all supported database systems.

See video Read more about reverse engineering

Reverse enginering MariaDB, MySQL and PostgreSQL

Key benefits

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: It allows all your team members or clients to understand the relationships among tables and other objects in an effective manner.

Faster development: Draw data models and generate code. Avoid typos, make changes quickly.

Download Luna Modeler
Supported platforms: SQL Server, PostgreSQL, MariaDB, MySQL and SQLite
Trial/Early Access version expires 14 days after installation.

Windows OS
Windows Installer

Version: 6.1.0
File size: 77MB
Tested on: Windows 10 Pro

Linux AppImage

Version: 6.1.0
File size: 101MB
Tested on: Ubuntu 20.04

Windows OS
DMG file for MacOS

Version: 6.1.0
File size: 103MB
Tested on: MacBook Air & Mac M1
Purchase Luna Modeler

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
Go to purchase page
Basic Edition - EDU
Request EDU License
Want to get in touch?

Send Email to