Luna Modeler logo

Luna Modeler
ER diagram tool for MySQL
and other relational databases

MySQL ER diagram - made in Luna Modeler

Key features for MySQL

ER diagram tool for MySQL - Luna Modeler

ER diagrams for
MySQL databases

Define database objects like tables, keys, indexes and relationships graphically. Manage your database structures in projects, export diagram to PDF and generate SQL code for your projects.

Download Luna Modeler

Easy database modeling with our ER diagram tool

Spend your time doing work that is fast and convenient. Luna Modeler is a tool that focuses on simplicity, clarity and a pleasant user interface. However, it provides advanced features and supports various MySQL database specifics.

Quick start guide for MySQL

MySQL database diagram made in Luna modeler - ER diagram tool for MySQL
MySQL connection details

Visualize existing structures

Connect to an existing MySQL or MariaDB database platform, reverse engineer and visualize existing database structures.

Secure SSH/SSL/TLS connections to MySQL databases are supported in the Professional Edition.

Read how to visualize existing database

Generate SQL scripts

When your database modeling for MySQL is finished, click a button on the main toolbar and immediately see SQL code preview.

Read how generate SQL scripts

Generated SQL script for MySQL
Style selection for database report

Generate documentation or export diagrams to PDF

  • generate interactive HTML reports with ER diagrams
  • compare your project with the database and generate a report with a list of detected differences
  • export your ER diagram to a multi-page PDF

Read more

Compare & Synchronize your database diagrams

Connect to your MySQL database, run comparison and either update your project or generate synchronization SQL script!

Read more about updating MySQL projects
See how to generate sync SQL scripts

Comparison and sychronization in Luna Modeler

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

How to Generate Delta Scripts for Database Changes

Database design tool for macOS

How to create an ER diagram for MongoDB

AWS Amazon DocumentDB

Top 5 Data Modeling Tools to know in 2025

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

Documenting Databases using ER Diagrams