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
Screenshot of Luna Modeler showing an ER diagram and database design canvas
Screenshot of Luna Modeler used as a database design tool, showing an entity relationship diagram canvas with tables, relationships, and properties panel.

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 on-premise and cloud databases (Azure, AWS, Supabase)
  • Lightweight, cost-effective, and secure option
  • ERD, sub-diagrams & graphics for data flow & data lineage diagrams
  • Schema comparison & synchronisation SQL scripts
  • SSH / SSL / TLS tunnel support (Professional edition)
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. Create sub-diagrams, add notes, flowcharts or even custom fields.
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.
Luna Modeler
Try Luna Modeler Free for 14 Days
No credit card. No account. Just download and start designing.
Luna Modeler 13.6
Data Modeling Tool for relational databases like Oracle, SQL Server, PostgreSQL...
  • Free 14-day trial
  • No credit card required

Specialized data modeling tools
for every part of your stack

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