Luna Modeler
Professional Data Modeling Tool
for relational databases

FREE 14 days trial. No card required.
  • More than just static ER diagrams Start data modeling from scratch or reverse-engineer databases
  • Stop schema drift Compare dev, staging & production and generate synchronisation SQL
  • Works fully offline Supported Operating Systems Your schemas stay on your device, nothing uploaded to the cloud, ever
  • One-time purchase Pay once, use forever.
    No subscription, no lock-in

Design Databases Visually -
and Keep Them That Way

Luna Modeler turns database design into a picture your whole team can read: draw ER diagrams, generate deployment-ready SQL, document what you build, and keep the model in step with the real database — all on your own machine, no cloud required.

Explore Luna Modeler Compare editions Why Luna Modeler?

Why professionals
choose Luna Modeler
  • Works with Oracle, SQL Server, PostgreSQL, MySQL, MariaDB & SQLite
  • Enterprise-grade modeling at a fraction of the typical price
  • Keeps your live database and your data model in sync
  • Draws ER diagrams and generates deployment-ready SQL
  • Turns any diagram into interactive documentation
  • Headless CLI, git-friendly folder format (Ultimate edition)
Context Lens instantly shows every object connected to the one you select, instead of scrolling a large diagram to find it.
New in Version 14

Complex Diagrams, Instantly Readable

Once a model grows past a few dozen tables, finding what connects to what becomes guesswork. Context Lens ends that: select any table, view, or object and it opens a focused view of everything linked to it — relationships, dependencies, every line leading elsewhere — no more scrolling a 200-table diagram to answer "what does this touch?"

See what's new in v.14 Try it free

When you're designing a new system
Draw data models offline. No database required. Run forward engineering to turn your visual data model into deployment-ready DDL. Platform specific syntax, validated output.
When you inherit a database
Connect to a live database and reverse engineer it into a complete ER diagram automatically. Understand the database in minutes. New in v14: pick exactly which object types to bring in, so legacy databases don't drag in every trigger and procedure along the way.
When you need to change schema safely
Compare your data model against any connected database, see every diff highlighted, and generate a targeted synchronisation SQL script. Catch schema drift before it breaks a release and keep your environments in sync.
When documentation is always outdated
Keep your team aligned - generate interactive HTML documentation from your data model. When the schema changes, regenerate in one click — no doc maintenance, no stale wikis, just current database documentation.
SQL script generated from an ER diagram in Luna Modeler database design tool
Screenshot of Luna Modeler generating SQL DDL scripts from an ER diagram, with platform-specific syntax for the connected database.

Platform-Specific SQL for Every Database in Your Stack

Luna Modeler doesn't generate generic SQL that breaks at deployment. Every forward-engineered script matches your database's exact dialect.

  • PostgreSQL — PostGIS types, Supabase, AWS RDS for PostgreSQL
  • Oracle Database — on-premise, AWS RDS Oracle, Oracle Cloud
  • SQL Server — Azure SQL Database, Entra ID auth
  • MySQL and MariaDB — open-source stacks
  • SQLite — embedded, file-based, and mobile application databases

Explore Luna Modeler

Your Schemas Never Leave Your Machine

Luna Modeler is a desktop application. Your database credentials, ER diagrams, schema files, and generated SQL are stored on your own device only. No account required to use it. No schemas uploaded to our servers.

Your intellectual property stays in your hands.

Download free trial — no account needed

Luna Modeler data modeling tool — draw data models in offline-first application.
A data model created with Luna Modeler data modeling tool for relational databases.

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.

BM
Breno M.

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.

NR
Nathan R.

Beats the rest of the pack for ease of use. Very fast to do basic tasks but has some really neat extensions.

DF
Dave F.

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.

JS
Jeremy S.
Luna Modeler
Try Luna Modeler Free for 14 Days
No credit card. No account. Just download and start designing.
Luna Modeler 14
Data Modeling Tool for relational databases like Oracle, SQL Server, PostgreSQL...
  • Free 14-day trial
  • No credit card required
Luna Modeler 14 - Pricing
Data Modeling Tool for relational databases like Oracle, SQL Server, PostgreSQL, MySQL, MariaDB, SQLite.
Basic Edition
$ 99
USD
Pay once, use forever
  • Data modeling, ER diagrams
  • Unlimited projects, unlimited tables
  • Reverse & forward engineering
  • SQL scripts generation
  • Custom fields & customization
  • Templates for custom output
  • Assets & graphics
Professional Edition
$ 189
USD
Pay once, use forever
  • All basic edition features
  • Advanced reverse engineering
  • Secure SSH/TLS connections
  • Sub-diagrams
  • Interactive reports
  • Synchronization features
  • Model conversion
  • Multiple instances
Ultimate Edition
$ 349
USD
Pay once, use forever
  • All professional edition features
  • Navigator for easy schema exploration
  • Folder based format for team collaboration
  • Command line interface
  • CLI configuration wizard

Also working with
MongoDB or GraphQL?

Luna Modeler covers relational databases. If your stack also reaches into MongoDB or GraphQL, we built a dedicated tool for each — same one-time pricing, same offline-first design.

Moon Modeler

Data Modeling Tool
for MongoDB & noSQL

  • Visual MongoDB schema design
  • Reverse engineer existing MongoDB databases
  • Generate validation & creation scripts
  • Mongoose ODM support

Explore Moon Modeler for noSQL

Galaxy Modeler

Schema Design Tool
for GraphQL

  • Visual GraphQL schema design
  • Import from files or live URLs
  • Generate schema definition scripts
  • Export to PDF documentation

Explore Galaxy Modeler for GraphQL