Moon Modeler

Database modeling tool for MySQL

Database modeling tool - Moon Modeler for MySQL

Key features for MySQL

Draw ER diagrams
Enjoy drawing entity-relationship diagrams for MySQL and create your databases easily and visually.
Reverse engineer
Connect to your MySQL database and visualize existing database structures.
Export to PDF
Share your pixel-perfect diagrams in high-quality printable PDF format.
Generate scripts
Save your time and generate, preview and save SQL scripts for your MySQL databases.

Create ER diagrams for MySQL

Define database objects like tables, keys, indexes and relations graphically and visualize JSON in entity relationship diagrams for MySQL. Manage your database structures in projects, export diagram to PDF and generate SQL code for your projects.

Quick Start Guide for MySQL

ERD made in Moon Modeler database modeling tool

Quick and comfortable database modeling for MySQL

Draw new objects with predefined settings. Change column positions using drag and drop. Add referenced columns to target tables automatically etc. Changes are saved immediately and in case you need to revert your changes, use the UNDO functionality. You can also easily swith between dark and light theme.

Database connection
New - reverse engineering included in version for MacOS

Reverse engineer existing structures

Connect to an existing MySQL, MariaDB, PostgreSQL or MongoDB database platform and reverse engineer database structures with nested documents or JSON.

MySQL database modeling, ERD with sample data

Keep your database designs
well documented

During your database modeling activities you can arrange MySQL objects in diagrams, colorize items, change the view to show metadata, sample data or descriptions. Add notes in HTML format, connect objects using lines with custom end point graphics or include pictures to your database models. You can also export diagrams to high-quality, vector format, PDF files.

Generated SQL script

Preview and generate SQL scripts

Generate SQL scripts together with other options. When you database modeling for MySQL is finished, click a button on the main toolbar and immediately see code preview.
You can also add custom code to BEFORE and AFTER sections and save scripts for whole your MySQL database modeling project or for just a single MySQL table or relationship.

Download Moon Modeler
Supported platforms include MySQL, MariaDB, PostgreSQL, MongoDB, SQLite, Mongoose and GraphSQL.
Moon Modeler for MySQL and other platforms is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.

Key benefits - MySQL database modeling

The following 3 points represent the main benefits for users interested in MySQL database modeling.

1. Blueprint to your own product

A diagram can give you a clear model of your database structure and help you recognize errors. It's like a blueprint to your house. You know what you are building, how to connect the pieces and you have the necessary documentation.

2. Efficient communication

Database modeling allows all your team members or clients to understand the relationships among tables and work with nested JSON in your MySQL structures in an effective manner.

3. Higher productivity

Database modeling activities helps you create your MySQL databases visually, the work is faster, you can avoid typos and make changes quickly.

Looking for a FREE
database modeling tool for MySQL?

Use Moon Modeler. The freeware version allows you to save projects with 10 objects at max.