LUNA MODELER

Database Design Tool for SQL Server

and PostgreSQL, Oracle, MySQL, MariaDB, SQLite

Key database design features for MS SQL Server

Create database designs for SQL Server

Database design comes with cool features that let you visually define the structures of an MS SQL Server database. You can create SQL Server ER diagrams, set up tables, define views, triggers, procedures and user-defined types, map out relationships, and detail the specifics of SQL Server tables and columns.

Download Luna Modeler

Quick and comfortable database modeling for SQL Server

In Luna Modeler, all changes are saved immediately. You can edit objects in the sidebar or larger forms. Details of columns, indexes, etc., are available in expandable areas. If you change a property, you can instantly see how the SQL script changes.

Quick start guide for SQL Server

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

Generate documentation for SQL Server Database Designs

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

Generate SQL scripts from your database designs

The generation of SQL scripts for database designs can be initiated by clicking a button on the main toolbar, which will immediately present a code preview.

You can also write templates and generate a custom output.

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

Connection form for reverse engineering of SQL Server database

Visualize existing SQL Server structures

Connect to an existing SQL Server and reverse engineer the database. Secure SSH/SSL/TLS connections for visualization of cloud databases are supported in the Professional Edition.

Read about the visualization of existing databases
Learn how to visualize an Azure SQL Server database
Find out how to visualize SQL Server Express Database

Detect changes and 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.