DATENSEN
Design, document and communicate
your data models.

Luna Modeler
Professional Data Modeling Tool
for DBAs & Developers

Download
Download FREE Trial
FREE 14 days trial. No card required.
  • Understand any legacy database Reverse engineer into a visual ER diagram in minutes, not hours
  • Stop schema drift Compare dev, staging & production and generate synchronisation SQL
  • No hand-written DDL Forward engineer validated SQL scripts from your data models
  • Documentation that stays current Auto-generate interactive HTML reports from your data model
  • 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

The Database Professional's
End-to-End Workflow

Most database teams scatter their schema work across text editors, wiki pages, migration scripts, and outdated diagrams — none of it in sync. Luna Modeler brings your entire database lifecycle into a single desktop application: from first entity to production SQL, from reverse engineering a legacy system to documenting it for the next developer.

Trusted by database architects, senior developers, and DBAs in 85+ countries who need a reliable, professional tool that respects their workflow.

Compare editions

Why professionals
choose Luna Modeler
  • No mandatory cloud sync — data stays on your machine
  • Works with on-premise and cloud databases (Azure, AWS, Supabase)
  • Conceptual, logical & physical model supported
  • Schema comparison & synchronisation scripts
  • Interactive HTML reports your team can actually read
  • Custom script templates for any output format
  • SSH / SSL / TLS tunnel support (Professional edition)
Featured in Apple's MacBook Pro launch.
Used by professionals in 85+ countries.
Understand any database — instantly
Connect to a live database and reverse engineer it into a complete ER diagram automatically. No manual diagramming. No reading raw DDL. The full picture in front of you in minutes.
Keep your team aligned — automatically
Generate interactive HTML documentation and PDF exports directly from your data model. When the schema changes, regenerate in one click — no doc maintenance, no stale wikis.
Deploy schema changes — without writing SQL
Forward engineering turns your visual data model into deployment-ready DDL SQL for your exact database platform. Platform-specific syntax, validated output.
Catch schema drift — before it hits production
Compare your data model against any connected database, see every diff highlighted, and generate a targeted synchronisation SQL script. Keep your environments in sync.
SQL script generated from an ER diagram in Luna Modeler database design tool

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 generating ER diagrams from connected 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
Windows Installer
Tested on Windows 11
Linux AppImage
Tested on Ubuntu 24
macOS Apple
macOS Intel

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

View all data modeling products
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 entity-relationship diagrams (ERDs), define tables, columns, relationships, and constraints — then generate SQL scripts or HTML documentation from the visual model. Luna Modeler is a desktop data modeling tool supporting Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, and SQLite.

What is an ER diagram?

An ER diagram (Entity-Relationship diagram) is a visual representation of a database schema showing entities (tables), their attributes (columns), and the relationships between them. ER diagrams are used by DBAs and developers to plan, communicate, and document database structures. Luna Modeler lets you create, edit, and export ER diagrams for all supported relational databases.

What is reverse engineering in database design?

Reverse engineering is the process of connecting to an existing database and automatically generating a visual ER diagram from its structure. Instead of drawing diagrams by hand, the tool reads your live database schema — tables, columns, relationships, indexes — and produces an accurate diagram automatically. Luna Modeler supports reverse engineering for all supported database platforms.

What is forward engineering in database design?

Forward engineering is the process of generating DDL SQL scripts from a visual data model. You design your database structure as an ER diagram, then Luna Modeler generates the corresponding CREATE TABLE and ALTER statements ready to deploy to your database. This eliminates manual SQL writing and reduces errors. Learn more about forward engineering in Luna Modeler.

What databases does Luna Modeler support?

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, Heroku Postgres, and Azure SQL Database. The Professional edition adds SSH/SSL/TLS tunnel support for secure remote connections.

Is Luna Modeler free?

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 but not required to keep using the tool.

What is the difference between a logical and physical data model?

A logical data model describes the structure of your data in business terms — entities, attributes, and relationships — without being tied to any specific database technology. A physical data model maps the logical design to a specific database platform, defining actual tables, columns, data types, indexes, and constraints. Luna Modeler supports conceptual, logical, and physical models, letting you work at whichever level of abstraction suits your current task. See logical data models and conceptual data models in Luna Modeler.

Get Updates
Never miss important updates or offers.
Join Our Newsletter