Luna Modeler

Database design tool for SQL Server

and PostgreSQL, MySQL, MariaDB, SQLite

Key features of the database design tool for MS SQL Server

Draw ER diagrams

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

Reverse engineer

Connect to your SQL Server database and visualize existing database structures.

Create documentation

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

Generate scripts

Preview, generate and save SQL scripts for your SQL Server databases.

Create database designs for SQL Server

Database design features include a visual definition of MS SQL database structures. Visually design SQL Server ER diagrams, specify tables, sequences, draw relationships and define SQL Server table and column specifics.

Quick start guide for SQL Server

Quick and comfortable database modeling for SQL Server

Create new objects with predefined settings. Change field positions using drag and drop. Add referenced columns to target tables automatically etc. Changes are propagated and saved immediately and in case you need to revert changes, use UNDO. A dark or light theme in UI is only a matter of your preference.

A form that shows how to easily edit column in ERD for SQL server.

Keep your database designs
well documented

When designing a database, you can organize SQL Server objects into diagrams, colorize items, add notes in HTML format, connect objects using lines with custom end point graphics. You can also export diagrams to PDF or HTML.

Generate SQL scripts

Generate SQL scripts for your database designs. 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 SQL Server database design or for just a single SQL Server table or relationship.

ER diagram for SQL Server - SQL script generated by Luna Modeler

Connection form for reverse engineering of SQL Server database

Reverse engineer existing structures

Connect to an existing SQL Server and reverse engineer database. SSH/SSL/TLS connections are supported in the Professional Edition.

Detect changes, generate report or update your projects

Connect to your database, compare the structure of your existing database with your project and generate a detailed HTML report or update your project easily.