Blog articles

Compare editions – Luna Modeler

Luna Modeler is available in two editions, Basic and Professional.

Luna Modeler FeaturesBasicProfessional
Supported platforms
PostgreSQL Yes Yes
MariaDB Yes Yes
MySQL Yes Yes
SQLite Yes Yes
Data modeling
ER diagrams and visual schema design Yes Yes
Support for platform specific objects Yes Yes
Automatic creation of foreign keys Yes Yes
Default values for a project Yes Yes
Custom data types for a project Yes Yes
User interface
Dark and light theme Yes Yes
Custom colors for items on ER diagrams Yes Yes
Undo Yes Yes
Find an object Yes Yes
Objects filtering Yes Yes
Automatic object resizing, lock dimensions Yes Yes
Multiple objects alignment and resizing Yes Yes
Multiple line modes Yes Yes
Multiple display modes Yes Yes
Optional display of database/schema name Yes Yes
Optional display of estimated size Yes Yes
Optional display of relationship captions Yes Yes
Autolayouts Yes Yes
Zoom Yes Yes
Subdiagrams for objects in a subject area Yes
Subdiagram creation for schema/database Yes
Code generating
Generating project script Yes Yes
Generating subdiagram script Yes
Settings for output formatting Yes Yes
Order items Yes Yes
Export to PDF Yes Yes
Export subdiagram to PDF Yes
Interactive HTML reports Yes
Multiple styles for HTML reports Yes
Visualization of existing structures
Basic database connections & reverse engineering (RE) Yes Yes
Secure SSH connection & reverse engineering Yes
Secure SSL/TLS connection & reverse engineering Yes
Import from SQLite files Yes Yes
List price99 USD149 USD

Buy a license now

About Luna Modeler

Luna Modeler is a data modeling tool for relational databases – PostgreSQL, MariaDB, MySQL and SQLite.

Key features

  • visual creation of ER diagrams for relational databases
  • support for database specifics (like composite types in PostgreSQL etc.)
  • easy-to-use user interface
  • various display modes
  • forward engineering & code generation
  • reverse engineering (for MariaDB, MySQL and PostgreSQL)
  • secure SSL/TLS connections to cloud based solution like Heroku Postgres etc.
Read the rest

What’s new in versions 5

We are pleased to announce the release of new versions of our products! We’ve added new features, fixed known bugs and focused on better UI/UX. Let’s take a look at the main changes.

  1. Adding referenced objects to sub-diagrams
  2. Modeling of hierarchies in Moon Modeler
  3. Text notes
  4. Product line changes

1. Adding referenced objects to sub-diagrams

This feature is designed to make it easier to work with larger projects and is available in Professional editions.… Read the rest

AWS Amazon DocumentDB

In this article, we will explain how to connect to AWS Amazon DocumentDB in Moon Modeler and how to automatically create a diagram of an existing database.

What is AWS DocumentDB?

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads.… Read the rest

Installing AppImage on Ubuntu 22

If you downloaded AppImage for Linux from our website and the product fails to run on Ubuntu 22.04, install libfuse2 and check permissions.

Step 1: Installing libfuse2

Open a terminal and type the command
sudo apt install libfuse2
Then enter a password. When entering the password no character is displayed, this is by design.… Read the rest

What’s new in Moon Modeler version 4.6

Published: 10.5.2022, Updated 12.8.2022

During the development of this release, we have focused on improvements related to data modeling for all databases. We have addressed the use of naming conventions for PostgreSQL and fixed reported bugs. We also addressed internal improvements. This resulted in smaller installation package sizes and increased application stability.… Read the rest

MongoDB schema design

Quick start guide for MongoDB schema design in Moon Modeler.

How to get started with MongoDB schema design?

The following text explains how to design a new database structure for MongoDB.

1. Create a new Project

To create a new project in Moon Modeler click the New item on the toolbar.… Read the rest

Heroku Postgres and ER diagrams

How to create ER diagram of PostgreSQL database running in Heroku? With Luna Modeler, the process is simple. Just create a database connection, retrieve the information from Heroku Postgres and create a project containing the ER diagram. But let’s start one step at a time.

What is Heroku and Heroku Postgres?

Read the rest