What’s new in
Luna Modeler version 8

This page was updated on April 24th

Custom Templates, Custom Properties,
Endless Possibilities

Imagine defining a template that generates not only SQL scripts but also parts of your application code.
Luna Modeler bridges the gap between databases and development.
Easily create custom output, SQL scripts, HTML reports, CSV files or
even UI components – it can all be done with custom templates!

Version 8.5
Customizations & Custom Properties

Custom Properties

You can easily add your own custom properties to Luna Modeler projects, display them directly on the diagram, edit values in the right side panel, embed them in HTML reports and use them to generate your own scripts or other outputs.

Read more about custom properties

Custom properties
Luna Modeler - customizations

Customizations

Custom properties are part of the so-called Customizations, which extend the capabilities of Luna Modeler. You can create your own customizations choose which element in the UI will be available for editing values etc. Of course, you can conveniently define customizations and custom properties directly in Luna Modeler.

Read more about customizations

Rapid Application Development

In combination with templates, you can generate custom output. Whether it is a piece of back-end code, forms for the front-end or HTML output with a list of objects where sensitive data is stored, etc.

Read more

A form for database table generated by Luna Modeler

Version 8
Scripts & Templates

Luna Modeler and custom template selection for template-based generated scripts.

Script and Templates

On the SQL Script form you can find the Script and Templates tab where template-based output is available. Here you can find several predefined templates, such as the SQL code template for outputting SELECT statements or DROP statements for tables. It also shows the possibility of generating the output to a CSV file or part of application code written in javascript.

Read more about templates

Templates Toolbar

On the Script and Templates tab you will find a toolbar with a diagram selection, a template selection and also the following buttons:

  • Syntax highlighting – especially useful for javascript or json code
  • Open folder with templates
  • Reload templates – if you add a custom template
  • Documentation – link to documentation
Luna Modeler and the templates toolbar.
Collapsible sections and easy copying in Luna Modeler custom template based scripts.

Collapsible Sections and Easy Copying

In terms of a user-friendly interface, you now have the option to collapse or expand the generated script for individual objects and to insert the script for selected object into the clipboard easily.

Modal Forms & Custom Template Based Scripts

The generated script for the selected object can be viewed also on the object Detail modal form. Navigate to the SQL Script tab where you will find everything you need, including:

  • Generation settings
  • Before and after scripts
  • Custom code
  • Script and Templates with custom template based output.

The combination of all options and possibilities provides exceptional flexibility!

Object detail modal form in Luna Modeler with SQL script and custom output.
Luna Modeler side panel with generated SQL script and custom output.

Side Panel & Template Based Output

In your templates you can write a code that will be generated only for the currently selected object. Thus, it is not necessary to generate the output for the whole project and then search for the file with the generated code. Just select a table, relationship or other object in the diagram and view your own template based script in the sidebar.

Templates Structure

When you open the templates folder, you will see a simple structure. To create a custom template, just create one simple json file describing the template and one hbs file containing the template written in Handlebars. You then only need to write a few lines of code to output the SELECT statement of the tables. Writing templates is easy and based on a well-known templating system. There is no need to reinvent the wheel!

Templates structure in Windows Explorer.
Template errors handling in Luna Modeler.

Comfortable Development

In rare cases, you may make a mistake when creating a template. In this case, the Handlebars templating system will display an error instead of the generated content. This way you can immediately see where to look and there is no need to restart Luna Modeler at all.

Our goal is to make your work comfortable and pleasant even if some modification of the templates is required.

Read more about templates

The latest improvements

Improvements & Fixes

  • Improvements in reverse engineering from Microsoft SQL Server, PostgreSQL, MySQL and MariaDB databases.
  • Synchronization of PK and Not Null settings.
  • Better naming for MySQL and MariaDB primary keys
  • Update of components
  • Bug fixes in SQL Server HTML reports
ERD with relationship names.

Download

Luna Modeler


Luna Modeler is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.

Download Luna Modeler

Purchase

Luna Modeler

You can use the same license key on Windows, Linux and MacOS.
EDU license for students and teachers is available for the Basic Edition.

Basic Edition
$99,-

Go to purchase page

Professional Edition
$189,-

Go to purchase page

Basic Edition – EDU
$49,-

Request EDU License

Luna Modeler

SQL Server

Key features for SQL Server
SQL Server database design

PostgreSQL

Key features for PostgreSQL
PostgreSQL database design

MariaDB

Key features for MariaDB
MariaDB database design

MySQL

Key features for MySQL
MySQL database design

SQLite

Key features for SQLite
SQLite database design

Moon Modeler

MongoDB

Key features for MongoDB
MongoDB schema design

Mongoose

Key features for Mongoose
Mongoose schema design

Galaxy Modeler

GraphQL

Key features for GraphQL
GraphQL schema design

Ideamerit Designer

Diagramming tool for OKRs
Objectives and key results

Data Modeling Tools

Overview of our data modeling tools

Articles from our blog

ER Diagram samples

Top 5 GUI tools for PostgreSQL

Database design tool for macOS

How to create an ER diagram for MongoDB

AWS Amazon DocumentDB

Top 5 Data Modeling Tools to know in 2024

Cosmos DB & MongoDB API

Heroku Postgres and ER diagrams

How to connect to MongoDB Atlas and create ERD

Database design tools for linux

What is entity relationship diagram?

NoSQL data modeling

How to Convert a Database Schema?

ER diagram tool for macOS

How to make a diagram of your GraphQL schema

Top 5 Benefits of Database Modeling Tools

How to Create a Database Diagram?

ER Diagram Tool