Moon Modeler

ERD creator for SQLite

and MongoDB, Mongoose, PostgreSQL, MySQL, MariaDB and GraphQL

ERD SQLite - Chinook sample - Moon Modeler

Key features for SQLite database design

Draw ER diagrams

Define entity-relationship diagrams for SQLite easily and model your database visually.

Import from files

Load metadata from files and visualize existing database structures.

Create documentation

Share your pixel-perfect diagrams in high-quality printable PDF format.

Generate scripts

Preview, generate and save SQLite DDL scripts.

Create ERD for SQLite

Visually design SQLite structures, specify database tables, columns, indexes and other objects. Draw relationships among tables and visualize nested JSON structures.

Quick start guide for SQLite

Quick and comfortable database modeling for SQLite

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.

ERD creator for SQLite
Notes in SQLite project - Moon Modeler

Keep your database designs
well documented

Arrange SQLite objects in diagrams, 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 generate HTML reports or export diagrams to PDF files.

Preview and generate scripts

Generate SQL scripts together with other options. When your ERD for SQLite is finished, click a button on the main toolbar and immediately see code preview.

Generated DDL script for SQLite
Import from files - ERD creator for SQLite
New - reverse engineering included in version for MacOS

Import from files

Import SQLite structures from existing files and visualize database objects or references in ERD. Then add notes or other logical information to your diagrams.


Moon Modeler

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

Download Moon Modeler

Key benefits – SQLite database modeling

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.

Efficient communication

Database modeling allows all your team members or clients to understand the relationships among database tables in your SQLite structures in an effective manner.

Higher productivity

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


Moon 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

Go to purchase page

Basic Edition – EDU

Request EDU License