Why Luna Modeler

Desktop-native by design, not by accident

Most tools moved to the browser. Luna Modeler went the other way — on purpose.

• Opens instantly. No login screen, no loading spinner.
• Works fully offline. No internet connection required.
• Connects to your database directly from your machine.
• Schemas, credentials, and business logic never pass through a third-party cloud.

That removes an entire category of risk that SaaS tools introduce by default.

Perpetual license — pay once, own it

Luna Modeler is sold under a perpetual license. You pay once.

• No subscription that expires mid-project.
• No price changes or tier shuffles next quarter.
• No seat portals, no usage-based billing, no recurring budget line.

You buy. You install. That's it.

Compare editions and pricing

Privacy-first — by architecture, not by policy

• No account required.
• No telemetry collected.
• No project files uploaded — ever.

A tool that never receives your data cannot leak it, sell it, or expose it in a breach. That is not a privacy policy you have to trust. It is how the software is built.

Modeling personal data, payments, or health records? Under GDPR or other regulation? Your story stays simple: the data never leaves your machine.

Read more about the offline-first architecture

Platform-specific SQL — because generic SQL is not enough

Every database speaks its own dialect. Generic DDL needs manual cleanup before it runs. Luna Modeler generates SQL you can execute as-is:

• Native data types, indexes, and constraints per platform.
• PostgreSQL domains, composite types, and schemas.
• Oracle packages, tablespaces, and sequences.
• SQL Server user-defined types and filegroups.

Supported platforms: PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, and SQLite.

Built by a team with decades of database experience

• Developed by Ideamerit s.r.o., a Czech software company with 20+ years in data modeling tooling.
• Multiple major versions, updated platform support, active documentation.
• Users in more than 85 countries.
• The same team builds Moon Modeler for MongoDB and NoSQL — modeling is the core business, not a side project.

Your schemas and diagrams accumulate value over time. They deserve a tool with a track record.

A data model is more than an ER diagram

ER diagrams show structure. Real communication needs context. Luna Modeler lets you add both — directly alongside your schema objects:

• Notes that explain naming decisions and business rules.
• Graphics and visual elements for context.
• Flowchart, use case, and data flow diagram components.

Stakeholders may never read a DDL script. They can follow a well-annotated diagram. A model that explains itself is simply more useful.

Data models created by humans, not generated by AI

AI can draft a schema from a prompt. Some of it will be reasonable. Some will be confidently wrong — and you won't notice until production.

Modeling is a design activity. Deciding what entities exist, how they relate, and what constraints apply requires domain understanding. Skipping that thinking is not a shortcut — it is debt: integrity issues, migration pain, undocumented decisions.

Luna Modeler gives you the canvas, the constraints, and the forward engineering. The design decisions stay yours.

Who Luna Modeler is for

Luna Modeler fits best when some of the following are true:

• You work with Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, or SQLite and need executable DDL.
• You prefer tools that run on your machine — no cloud, no mandatory accounts.
• You want a perpetual license, not a subscription.
• You need forward engineering, reverse engineering, or ALTER scripts in your workflow.
• Schema data leaving your machine is a compliance concern.
• You want HTML reports and PDF diagrams you control — no third-party viewer.

Download Luna Modeler — free 14-day trial