Moon Modeler
MongoDB, Mongoose, Azure Cosmos DB and DocumentDB. Design schemas visually, reverse engineer databases, generate $jsonSchema validation scripts.
from $99
Luna Modeler The database design tool for the schema you haven't built yet
Draw the model offline, generate DDL in your database's own dialect, and get ALTER scripts when a live database drifts from it.
Free 14-day trial. No account, no card.
orders
PK
id
serial
NN
FK
customer_id
integer
NN
status
order_status
total
numeric(10,2)
shipped_at
timestamptz
IX
orders_customer_id_idx
customer
PK
id
serial
NN
AK
email
varchar(255)
NN
phone
varchar(30)
created_at
timestamptz
Status updates
ENUM
order_status
C
'pending'
C
'paid'
C
'cancelled'
- Offline, alwaysNo account. Nothing uploaded. Your schema stays on your machine.
- 8 databases + any driverOracle, SQL Server, PostgreSQL, MySQL, MariaDB, Neon, Supabase, SQLite, anything else through ODBC or JDBC.
- 85+ countriesThousands of professionals in both small companies and corporations use Luna Modeler.
- Featured by AppleIn the MacBook Pro launch.
One model. Every job after the diagram.
A diagram editor stops at the picture. A database design tool keeps working after it: the same model drives the SQL, the comparison with your live databases and the documentation.
-
Design or reverse engineer
Start on a blank canvas with no server, or connect to the database you inherited and reverse engineer it into an ER diagram. Pick which object types come in.
-
Generate the DDL
Forward engineering writes deployment-ready scripts in the exact dialect: Oracle sequences, PostgreSQL enums and domains, SQL Server user-defined types.
-
Compare and synchronize
Compare the model with dev, staging or production and generate a targeted ALTER script. Catch schema drift before it breaks a release.
-
Document
Publish interactive HTML reports and regenerate them in one click, so your database documentation is never older than the schema.
New in version 15.0
Model any database with an ODBC or JDBC driver
Firebird, the engine inside your ERP, a legacy system with no modeling tool of its own. If it has a driver, Luna Modeler can read it. Use the driver you already have. Tables, columns, keys and relationships load into a logical data model with an ER diagram you can document and share.
Capture what the database can't tell you
Tables and keys show how data is stored, not what it means. On the same canvas as the tables, add flowchart and data flow elements, lineage arrows showing where a field came from, and ownership and sensitivity flags for an auditor.
The next person understands the why, not just the what.
Platform-specific SQL for every database in your stack
- PostgreSQL
- Enums, domains, composite types, PostGIS. Runs on Supabase, Neon and AWS RDS.
- Oracle Database
- Packages and sequences. On-premise, AWS RDS for Oracle and Oracle Cloud.
- SQL Server
- User-defined types. Azure SQL Database with Entra ID authentication.
- SQLite
- Embedded, file-based and mobile application databases.
- Anything with a driver
- New in version 15.0: connect through ODBC or JDBC (Firebird, a legacy system, a niche engine) and load the structure into a logical data model. Every edition.
What database professionals say
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.
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.
Beats the rest of the pack for ease of use. Very fast to do basic tasks but has some really neat extensions.
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.
How to choose a database design tool
Most tools in this category are compared on how their diagrams look. That is the least useful question: a diagram is an output. Six questions separate a database design tool from a database GUI that happens to draw boxes.
-
Does it work without a database connection?
A database GUI needs a live server before it can show you anything. A data modeling tool holds the model independently, so you can design a structure that does not exist yet, hand it to a colleague for review, or work on a train with no VPN.
Luna Modeler: yes. A model is a file on your disk; no server, no account.
-
Does it generate SQL in your dialect?
Generic DDL is easy. Correct DDL is not. Each dialect has constructs the others do not, and a tool that flattens them into lowest-common-denominator SQL produces scripts you then fix by hand.
Luna Modeler: a dedicated generator for each of PostgreSQL, Oracle, SQL Server, MySQL, MariaDB and SQLite.
-
Can it compare a model against a live database?
Schema drift is inevitable: dev moves ahead of staging, someone patches production directly. A modeling tool should show exactly what differs and generate the ALTER script that closes the gap, so every change is reviewed before it runs.
Luna Modeler: yes, in the Professional and Ultimate editions.
-
Can you draw what the database doesn't know?
A database GUI draws only what sits in the catalogue: tables, columns, keys. The context that explains them belongs in the same picture, not in a folder of generated Markdown almost nobody reads.
Luna Modeler: flowchart, data flow, lineage and governance elements on the ER diagram canvas.
-
Where does your schema live?
Your database structure describes your business. Browser-based tools upload it to someone else's infrastructure: for regulated industries, government work or client projects under NDA, that often decides the tool.
Luna Modeler: on your machine. Nothing is uploaded, ever.
-
What happens when you stop paying?
Under a subscription, access to your own models usually ends with the invoice. Under a perpetual licence, the version you bought keeps working indefinitely. Decide deliberately rather than by default.
Luna Modeler: perpetual. The version you buy is yours to keep.
Pay once. Keep it.
Perpetual licenses per user, Luna Modeler 15.0. Renewals are optional and only needed for newer versions.
Basic
$ 99
Best for designing and documenting schemas on your own. Unlimited designs, unlimited tables.
Buy BasicProfessional Most popular
$ 189
Best for live and cloud databases: secure connections, sync scripts, interactive reports
Buy ProfessionalUltimate
$ 349
Best for teams: Git-friendly project folders, headless CLI for CI/CD, Navigator
Buy UltimateCompare editions All products and prices Renewals Free 14-day trial first
Also designing for MongoDB or GraphQL?
Luna Modeler covers relational databases. The rest of your stack gets its own tool: same offline-first design, same one-time pricing.
Galaxy Modeler
GraphQL schemas. Import from files or live URLs, design types visually, generate schema definitions and PDF documentation.
$99
Merit Modeler
Flowcharts, data flow diagrams and use case diagrams.
Free
Database Design Tool & Data Modeling Software: FAQ
What is the difference between a data modeling tool and a database design tool?
In practice the two terms describe the same category and are used interchangeably.
Database design tool tends to be used when the focus is a single relational database and its tables, keys and constraints. Data modeling tool tends to be used when the work spans conceptual, logical and physical models, several database platforms, or documentation that outlives any one schema.
Both describe software that lets you design a structure visually and generate the SQL to build it, which is what separates either from a diagram editor.
Can I design a schema using a database design tool before the database exists?
Yes, and that is the main thing separating this category from a database GUI.
A database design tool holds the model independently of any server, so you can design tables, columns, keys and relationships with no connection at all, review the design with your team, and only then generate the DDL that creates it. Datensen tools run entirely on your own machine, so no connection is required at any point.
How does a database design tool apply changes to an existing database?
By comparison, not by guesswork. You change the model, then compare it against the target database: development, staging or production.
The tool reports exactly what differs and generates an ALTER script that closes the gap. You review that script before it runs, and every change is applied together rather than piecemeal, which is what keeps environments from drifting apart.
Which database design tool should I choose for PostgreSQL, MongoDB or GraphQL?
Luna Modeler covers relational databases: PostgreSQL, Oracle, SQL Server, MySQL, MariaDB and SQLite.
Moon Modeler covers MongoDB, Mongoose, Amazon DocumentDB and Azure Cosmos DB. Galaxy Modeler covers GraphQL schemas.
Merit Modeler is free, and covers flowcharts, data flow diagrams and use case diagrams rather than database schemas.
They are separate products with the same offline-first design and the same one-time pricing, so a mixed stack does not mean a compromise on any one platform.
Is there a database design tool for macOS and Linux?
Yes. Luna Modeler, Moon Modeler and Galaxy Modeler are desktop applications that run natively on Windows, macOS and Linux, with the same features on each.
This matters in this category because several long-established database design tools remain Windows-only, which leaves macOS and Linux users running a virtual machine to model a database.
How much does a database design tool cost?
Luna Modeler and Moon Modeler start at $99 USD for a perpetual licence: you pay once and keep using that version indefinitely, with no subscription.
Annual update renewals are optional and only needed if you want newer versions. Every tool has a free 14-day trial that requires no credit card and no account. Full details are on the pricing page.
Try Luna Modeler free for 14 days
No credit card, no account: download and start designing.