DATENSEN

Luna Modeler
Professional Data Modeling Tool
for SQL Databases

Download
Download FREE Trial
FREE 14 days trial. No card required.
  • Major Databases Supported Oracle, SQL Server, Postgres...
    Local & Azure SQL, AWS, Supabase
  • For Everything You Need Data modeling, reverse & forward engineering, SQL scripts + reports
  • Offline / Secure Your data never leaves your device
  • Cross Platform Supported Operating SystemsRuns on Windows, macOS & Linux
  • Advanced Data Modeling Comparison & Synchronization
  • Excellent ROI Pay once, use forever
Screenshot of Luna Modeler - data modeling tool for creating data models and entity relationship diagrams

Easy and Professional 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!

Compare editions

What's new in version 13.6
  • Performance improvements
  • Entra ID authentication for Azure SQL
  • Support for PostGIS in PostgreSQL
  • Check constraints
  • UI/UX enhancements

Read what's new

Trusted by customers
in +85 countries worldwide.
Join the experts!
Draw data models easily and quickly
For popular databases like Oracle, PostgreSQL, MySQL, SQL Server, MariaDB, SQLite and compatible systems
Visualize existing database structures
Create ER diagrams from existing databases, add notes, and better describe your data models.
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.
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.

Draw Data Models & ERD

Luna Modeler stands out as a professional tool for creating advanced entity relationship diagrams. Create conceptual, logical or physical data models for the following databases:
  • PostgreSQL® + PostGIS
  • Oracle® Database
  • SQL Server®, Azure SQL Database
  • MySQL® and MariaDB®
  • SQLite®
See Key Features

Visualize your databases to understand their structure

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 how to visualize existing databases
Learn how to reverse engineer databases

Database modeling tool Luna Modeler with ER diagram generation from connected databases
Generate ER diagrams and document relational databases with interactive reports in HTML, PDF, and image formats.

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 includes - 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.
Schema synchronization form in Luna Modeler database modeling tool for syncing database and ERD

Compare and synchronize database schemas with your data models

Easily compare existing database schemas with data models to identify differences, update your projects and synchronize changes. For all supported databases you can also generate synchronization scripts.

Read more about synchronization
See how to update projects
See how to generate sync SQL scripts

Luna Modeler
Download Luna Modeler
Luna Modeler 13.6
Data Modeling Tool for relational databases like Oracle, SQL Server, PostgreSQL etc.
  • Free 14 days trial
  • No credit card required
Windows Installer
Tested on Windows 11
Linux AppImage
Tested on Ubuntu 24
macOS Apple
macOS Intel
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.
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.
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.
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.
Featured in the introduction of Apple's 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.
Purchase Luna Modeler

One-Time Purchase
User-Based Perpetual Licenses

Basic Edition
$99
USD
Pay once, use forever
  • Data Modeling + ER Diagrams
  • Unlimited Projects, Unlimited Tables
  • Popular Databases Supported
  • Reverse Engineering
  • Forward Engineering
  • Export to PDF / PNG
  • Custom Script Generation
  • Conceptual, Logical, Physical Model
  • Flowcharts, Data Flow Diagrams
  • User-based Perpetual License
  • 12 Months Updates Included
  • License for Multiple Devices
Professional Edition
$189
USD
Pay once, use forever
  • All Basic Edition Features
  • Sub-Diagrams
  • Secure SSH/TLS Connections
  • Advanced Oracle Connections
  • Synchronization Features
  • Model Conversion
  • Interactive Reports
  • Multiple Instances
  • User-based Perpetual License
  • 12 Months Updates Included
  • License for Multiple Devices
Basic Edition - EDU
$49
USD
Volume discounts available
  • All Basic Edition Features
  • Open File from URL
  • Support for data modeling for Oracle, SQL Server, PostgreSQL, MariaDB, MySQL, SQLite
Compare Luna Modeler Editions Purchase Renewal
Frequently Asked Questions
What is a data modeling tool?

A data modeling tool is software that helps database professionals visually design, document, and manage database schemas. It lets you draw data models with entity-relationship diagrams (ERDs), define tables, columns, relationships, and constraints, annotate diagrams, add other graphical elements and then generate SQL scripts or HTML documentation from the visual model.

Which databases does Luna Modeler support as a professional data modeling tool?

Luna Modeler supports PostgreSQL (including PostGIS extensions), Oracle Database, Microsoft SQL Server and Azure SQL, MySQL, MariaDB, and SQLite. It connects to local installations as well as cloud-hosted databases including Supabase, AWS RDS, and Azure SQL Database. The Professional edition adds SSH/SSL/TLS tunnel support for secure remote connections.

Is Luna Modeler a free data modeling tool?

Luna Modeler offers a free 14-day trial with no credit card and no account required — just download and start designing. After the trial, licenses start at $99 USD (one-time purchase). Luna Modeler uses a perpetual licensing model: you pay once and use the software forever. Optional annual update renewals are available for upgrading to the latest versions, but not required to keep using the tool.

What is the difference between a data modeling tool and a database IDE with ER diagrams?

The core difference comes down to designing from scratch versus viewing what already exists.

  • Data Modeling Tools (e.g., Luna Modeler): These are architect tools built for blueprints. They let you design complex database schemas visually and completely offline, without needing an actual database up and running. You use them to map out architecture, build new relationships, and generate the code needed to create the database later.
  • Database IDEs with ER Diagrams: These are developer tools built for maintenance and interaction. They look at a live, existing database and generate a visual diagram of its current structure. While great for visualizing data and writing queries, they typically aren't designed to architect new relationships or structurally remodel the schema visually.
Does this data modeling tool work offline?

Luna Modeler runs on your computer. No cloud. No subscriptions. You get professional data modeling, SQL generation, comparison, synchronization and documentation. Everything stays local. Used by organizations in 85+ countries who need complete control over their database designs.