Luna Modeler
is a powerful database design and
data modeling tool for relational databases


New - support for Oracle Database Design
Database design and ERD tool for creating data models and entity relationship diagrams
Screenshot of Luna Modeler used as an ER diagram and database design tool for visual modeling and generating SQL scripts.

Easy and Powerful Data Modeling Tool

Luna Modeler is an intuitive data modeling tool for relational databases.
With this powerful tool, you can create ER diagrams, design and visualize database structures, generate SQL scripts, and document your data models with ease.
Luna Modeler makes data modeling simple!

Download FREE Trial Compare editions

What's new in version 10.5
  • Compare, detect, and sync changes for Oracle
  • New themes for diagrams and reports
  • Export diagrams as images
  • Explorer for organized version control

Read what's new

Featured in the introduction of Apple's new MacBook Pro®
A big thank you to Apple® for featuring Luna Modeler 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.
It is simply a brilliant product
at a fantastic price!

Testimonial by Jeremy S.

Draw ER diagrams easily and quickly
For relational databases like Oracle, PostgreSQL, MySQL, SQL Server, MariaDB and SQLite
Visualize existing database structures
Create an ER diagram from existing databases or import a SQLite structure.
Create interactive documentation
Share your pixel-perfect diagrams in PDF format or generate interactive HTML reports.
Generate
SQL scripts
Preview and save DDL/SQL code or easily write templates for your own custom scripts.
Synchronize
Compare & Synchronize
Compare projects with databases, generate reports, update projects or generate synchronization scripts.
Entity Relationship Diagram (ERD) for Oracle Database showing tables, relationships, and other objects.
Example of an Entity Relationship Diagram (ERD) for Oracle Database, illustrating tables, relationships, and key database objects created in Luna Modeler.

Draw ER diagrams

Luna Modeler stands out as a powerful tool for creating advanced entity relationship diagrams. Create conceptual, logical or physical data models for the following databases:

  • PostgreSQL®
  • Oracle® Database
  • SQL Server®
  • MySQL® and MariaDB®
  • SQLite®

Download Luna Modeler See Key Features

Automatically generate ER diagrams and visualize databases

Easily connect to relational databases like PostgreSQL, Oracle, MySQL, MariaDB, SQLite and SQL Server to generate ER diagrams automatically.

In the Professional version, you can also establish secure SSH/SSL/TLS connections and visualize cloud databases.

See video
Learn how to visualize databases

Database modeling tool Luna Modeler with ER diagram generation from connected databases
Screenshot showing Luna Modeler generating ER diagrams automatically from connected relational databases such as PostgreSQL, Oracle, MySQL, MariaDB, SQLite, and SQL Server.
Generate ER diagrams and document relational databases with interactive reports in HTML, PDF, and image formats.
Screenshot showing Luna Modeler generating ER diagrams and exporting detailed database documentation as interactive HTML reports, PDF, and images.

Generate database documentation from ERD and data models

Automatically generate detailed database documentation from ER diagrams. Organize relational structures into sub-diagrams, add HTML annotations, and export reports in interactive HTML, image or PDF formats.

See how to work with sub-diagrams
Learn how to document databases

Generate SQL from ER diagrams or write templates for custom scripts

Easily generate SQL scripts from ER diagrams to define database schemas. Preview and export SQL code for PostgreSQL, Oracle, MySQL, MariaDB, SQLite and SQL Server — perfect for database architects and developers.

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

Generated SQL script from ER diagram using Luna Modeler database design tool.
Screenshot showing SQL script generated from ER diagram using Luna Modeler database design tool.
Schema synchronization form in Luna Modeler database modeling tool for syncing database and ERD
Screenshot of the schema synchronization form in Luna Modeler showing how to sync database schemas with ER diagrams.

Compare and synchronize database schemas with ER diagrams

Easily compare existing database schemas with ER diagrams to identify differences, update your projects and synchronize changes.

For Oracle, MariaDB, MySQL and SQLite you can also generate synchronization scripts.

Read more about synchronization

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

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

Windows OS
Windows Installer

Version: 10.5.0 | Tested on Windows 11

macOS
Apple chip Intel chip

Version: 10.5.0 | Tested on: macOS Sequoia 15.2

Linux
Linux AppImage

Version: 10.5.0 | Tested on: Ubuntu 24.04
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
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