Luna ModelerDatabase Design Tool for SQL Server & Azure SQL

SQL Server & Azure SQL On-premise or cloud. One tool for both. Azure AD authentication included.
Keep Databases Aligned Compare. Detect differences. Sync safely across environments.
Complete Database Management Design. Reverse engineer. Generate SQL. Document.
Excellent ROI Pay once, use forever. No cloud subscriptions.

Looking for a powerful and user-friendly data modeling tool to visually design and document your SQL Server databases?

Luna Modeler helps you design clean ER diagrams, generate SQL Server scripts, and improve your workflow – even if you’re new to data modeling.

Learn more about Luna Modeler

Who is Luna Modeler for?

Luna Modeler is the perfect fit for database professionals, developers, consultants, DBAs, teachers, and anyone passionate about data modeling. If you’re looking for a modern, user-friendly, and budget-friendly tool, Luna Modeler is the ideal solution.

Download Luna Modeler

What Luna Modeler Does
for SQL Server & Azure Professionals

Design SQL Server Schemas Properly

Luna Modeler handles SQL Server the right way. Create ER diagrams for complex schemas. Design tables, views, triggers, stored procedures, user-defined types. Set up relationships, constraints, indexes. All the SQL Server features you need.

Then generate ready-to-run SQL scripts.

Download Luna Modeler

Work Offline, Stay Secure

Luna Modeler runs on your machine. No cloud. No internet required. Everything stays local, under your control. Changes save instantly.

Edit any object. Watch the SQL script update in real-time. See exactly what you’ll deploy before you deploy it.

Quick start guide for SQL Server

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

Export ERD to image, pdf or generate HTML documentation from your SQL Server data model

Generate documentation for SQL Server Database Designs

Luna Modeler creates documentation from your schemas. Organize objects, add notes, colorize for clarity. Then export to PDF, HTML, or images.

Generate SQL Ready to Deploy

One click generates working SQL scripts. Preview before running. Support for indexes, constraints, collation – everything SQL Server needs.

Or create custom templates. Generate any output format you need – scripts, forms, API schemas, documentation.

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

Connection form for reverse engineering of SQL Server database

See Your Current Databases

Connect Luna Modeler to SQL Server or Azure SQL. It extracts your schema and shows it as a diagram. Useful for understanding existing systems. Good for planning changes.

The Professional version has secure options – SSH, SSL/TLS – for cloud connections. Works with Azure SQL Database, on-premise SQL Server, all of it.

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

Keep Databases Aligned

Luna Modeler compares a database with a data model. Shows exactly what’s different.

Then you decide: fix the database, update the design, or generate a migration script. Get a report for audits. Everything documented.

Download

Luna Modeler

Luna Modeler is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.

Download Luna Modeler

Frequently Asked Questions on Database Design for SQL Server

Which data modeling tool for SQL Server is recommended?

There are many tools available, ranging from expensive to free. If you’re looking for a modern tool that’s easy to install on Windows, macOS, or Linux, we recommend Luna Modeler. It has a number of features specific to SQL Server.

Can I reverse engineer my existing SQL Server database?

Absolutely. Luna Modeler can connect to your SQL Server instance and generate ER diagrams automatically. You can also visualize Azure SQL databases.

Is SQL script generation supported for SQL Server?

Yes. You can generate SQL scripts from ER diagrams created in Luna Modeler, including custom SQL blocks.

What reporting and documentation capabilities does it have?

Luna Modeler offers the ability to export an ER diagram to PDF or image and also includes the ability to generate an interactive HTML report in a variety of styles and themes.

Does Luna Modeler store information in the cloud?

Everything you create stays with you. Luna Modeler does not store database connections or projects online. Your data is yours and everything is completely under your control.

Is a free trial of Luna Modeler available?

Yes, Luna Modeler offers a 14-day fully functional trial for Windows, macOS, and Linux. You can download the trial from https://www.datensen.com