Luna Modeler
is a powerful data modeling tool
for relational databases


PostgreSQL database design created in Luna Modeler - data modeling tool for relational databases

Easy and Powerful Data Modeling Tool

Luna Modeler is the easy-to-use data modeling tool for your favorite databases like SQL Server®, PostgreSQL®, MariaDB®, MySQL® and SQLite®. Effortlessly design and visualize your database structures, generate SQL scripts, and create interactive documentation. Perfect for both pros and beginners, Luna Modeler makes data modeling simple!

Download FREE Trial Compare editions

Version 9 available

  • Comparison and Synchronization Features
  • Alter Scripts for MariaDB, MySQL and SQLite
  • Detailed Comparison Reports
  • Schema Assignment, Improved Export to PDF
  • Diagram Move and Pan Options

Read what's new

What can you do
with Luna Modeler?

Draw ER diagrams easily and quickly
Visualize existing database structures
Create interactive documentation
Generate
SQL scripts
Synchronize
Compare & Synchronize

Draw ER diagrams

Luna Modeler stands out as a fantastic tool for creating data models and drawing entity relationship diagrams. It simplifies the process of defining database elements such as tables, columns, keys, and indexes, while also helping you visually depict the relationships in your database designs.

Download Luna Modeler

Visualize existing databases and generate ER diagrams

You can seamlessly connect to your databases and generate database diagrams automatically using our software. In the Professional version, you can also establish secure SSH/SSL/TLS connections and visualize cloud databases.

See video Read more

How to create a new database connection to PostgreSQL in Luna Modeler.
Database report creation in Luna Modeler - data modeling tool

Create documentation

When designing a database, you can arrange objects into sub-diagrams, add HTML annotations, etc. At any stage of the design process, you can easily generate an interactive HTML report to create useful documentation or export the ER diagram to a multi-page PDF.

See how to work with sub-diagrams Read more

Generate SQL or write templates for custom scripts

Generate SQL scripts for your database designs and diagrams. You have the flexibility to preview and save SQL scripts for your entire database design or for individual database tables or relationships.

You can also easily create custom output, SQL scripts, HTML reports, CSV files or even UI components - it can all be done with custom templates.

See how to use custom properties

SQL script generated by Luna Modeler data modeling tool
New - custom scripts

Compare & Sync your database diagrams

Compare your database design to the structure that exists in the database and update your project. For MariaDB, MySQL and SQLite you can also generate synchronization scripts.

See how to update projects See how to generate sync SQL scripts

Testimonials

BM
Breno M.
The Luna Modeler sped up exponentially my modeling time and its highly detailed and well built model visualization helped the understanding throughout all knowledge levels users.
Feb 7, 2025
NR
Nathan R.
I have never found a data modeling system that is easy to use... Until I used your suite of tools Luna, Moon, Galaxy. Plus, all this at a fantastic price. Definitely recommend for anyone using data models in a full stack app.
Feb 7, 2025
DF
Dave F.
Beats the rest of the pack for ease of use. Very fast to do basic tasks but has some really neat extensions.
Feb 3, 2025
JS
Jeremy S.
When I bought my licence I couldn't believe the range of features for the price point. It is simply a brilliant product at a fantastic price.
Jan 29, 2025

Featured in the introduction of Apple's new MacBook Pro®

A big thank you to Apple® for featuring our tool in the announcement and to everyone who has supported us on our journey.
Read the press release at apple.com and navigate to the second image in the gallery.

FAQ - Frequently Asked Questions

Why is Luna Modeler the ideal data modeling tool?

Users love the simplicity of working with Luna Modeler

  • The intuitive user interface makes working with Luna Modeler a pleasure.
  • You can create ER diagrams quickly. No need to confirm changes, everything is updated automatically in the project.
  • The product features are suitable for both beginners and professionals. Compare editions.
  • It is an affordable tool and purchasing a perpetual license is an ideal choice.
  • You are in full control of your data - nothing is stored in the cloud. Everything you create and store stays with you.
  • Luna Modeler is a modern tool that you can install on macOS, Windows or Linux and easily switch from one OS to another.

What makes ER diagrams from Luna Modeler unique?

Visual elements that add value to your ER Diagrams

  • Beautiful ER diagrams is the foundation.
  • You can add titles, captions, lines and other common elements to diagrams.
  • In addition, you can easily customize what elements are displayed, such as table comments, indexes and more.
  • With customization you can also add other elements and view, for example, the progress of your work on a given object and add other UI elements.
  • With sub-diagrams you can break down a more complex design into smaller diagrams.
ER Diagram made in Luna Modeler

What are the main advantages of using Luna Modeler?

A visual representation can convey so much!

  • Your product's blueprint: A diagram made in Luna Modeler serves as a clear representation of your data architecture, allowing you to spot mistakes easily. Think of it as the architectural plan for your home; it shows you what you're constructing, how everything fits together and provides essential documentation.
  • Streamlined communication: Luna Modeler enhances collaboration among team members by clarifying the relationships between tables and other elements in database diagrams.
  • Accelerated development: Create database diagrams and generate code swiftly. This minimizes errors and allows for quick adjustments.
  • Boosted productivity: The Luna Modeler data modeling tool significantly enhances your efficiency by facilitating rapid database design and automating repetitive tasks like SQL script generation, creating diagrams from existing databases and producing interactive reports.
  • Budget-friendly option: This data modeling tool is a cost-effective choice, as it minimizes the time and effort needed for database creation, ensuring projects stay within budget and are completed on schedule.

What kind of licensing model do you offer?

We offer a cost-efficient user-based licensing model

  • The perpetual license never expires. Read the details on the licensing model page.
  • One license can be used on multiple machines and operating systems.
  • You can participate in our discount programs and save on new license purchases.
  • The purchase process is secure - managed by professionals at FastSpring. Read details.
Download Luna Modeler
For SQL Server, PostgreSQL, MariaDB, MySQL and SQLite
Trial version expires 14 days after installation.

Windows OS
Windows Installer

Version: 9.1.0 | Tested on Windows 11

macOS
Apple chip Intel chip

Version: 9.1.0 | Tested on: macOS Sequoia 15.2

Linux
Linux AppImage

Version: 9.1.0 | Tested on: Ubuntu 22.04
Purchase Luna Modeler

Easy Database Modeling Tool for Relational Databases

Perpetual License - One Time Purchase
Enjoy 12 months of free updates on us!

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

Send Email to support@datensen.com