CLI automation Detect schema drift using the CLI, regenerate documentation and export diagrams from a terminal or CI job. No desktop window, no manual clicks before every release. Navigator - Context Lens Select any table in Luna Modeler and Navigator - Context Lens instantly opens a focused diagram of every relationship, dependency and line connected to it. Team collaboration with Git Save your data model as a folder of readable files for real data model collaboration: review schema changes as a Git diff, open pull requests, and keep merge conflicts scoped to one object. Data Privacy & Security Datensen tools are desktop-native and offline-first. Your project files, schemas, and database connections never leave your machine. No cloud storage, no telemetry, no vendor access. Why Luna Modeler Why Luna Modeler? Discover the deliberate choices behind Luna Modeler — desktop-native, perpetual license, offline-first, and platform-specific SQL — and why they matter for serious database work. Why Moon Modeler Why Moon Modeler? Discover the deliberate choices behind Moon Modeler — desktop-native, perpetual license, offline-first, MongoDB-specific code generation — and why they matter for serious NoSQL work. Assets for Better Data Modeling with Luna Modeler Explore assets for better data modeling with Luna Modeler. Design databases visually while adding context and flow. PostgreSQL Check Constraints Find out how to implement check constraints in PostgreSQL to ensure data quality and enhance your database design. SQL Server Check Constraints Learn how to use check constraints in SQL Server to ensure data integrity and prevent invalid entries in your database. PostGIS Core Support Unlock powerful mapping features with PostGIS Core Support in Luna Modeler and enhance your diagrams with specific data types. Visualization of existing SQL Server databases Connect to your SQL Server and reverse engineer your existing database structures. Visualize databases and create ER diagrams. Free Flowchart & Data Flow Diagram Tool? Simplify your workflow with Merit Modeler, the user-friendly desktop tool for free data flow diagrams and flowcharts. Free ER diagram tool? Free ER diagram tool for Sequelize - ORM for PostgreSQL, MariaDB, SQLite and SQL Server. Create smaller projects with the free version. Oracle Database Design Luna Modeler for Oracle database design. See how to visually create ER diagrams for Oracle Database and generate SQL Scripts. Oracle Database Packages Learn how to define Packages in projects for Oracle Database. See how to define and visualize packages in ER diagrams in Luna Modeler. Other objects in Oracle Database Learn how to define other objects like functions, triggers, synonyms, types and other Oracle-specific objects in Luna Modeler. Oracle Database Sequences Learn how to define Sequences in projects for Oracle Database. See how to define and visualize sequences in ER diagrams in Luna Modeler. Themes in Luna Modeler Learn about the various themes in Luna Modeler and how they can instantly improve the look of your diagrams and user interface. Database Schema Assignment Explore the features of Schema Assignment in Luna Modeler. Assign, remove, or replace schemas effortlessly for your objects. Custom Templates & Scripts All Datensen products support custom templates for generating SQL scripts, HTML, CSV and JavaScript outputs. Learn how to create snippets etc. Setting Default Values for Columns in SQL Server Learn how to set default values for columns to your SQL Server database design. Explore Luna Modeler database design tool. Subject Areas in Moon Modeler Explore subject areas in Moon Modeler to enhance your data modeling with advanced features and visualizations. Auto Layout in Moon Modeler Learn how the auto-layout function in Moon Modeler automatically arranges MongoDB diagram items for better readability and structure. Datatype aliases in Moon Modeler Explore how a data type alias enhances your diagrams in Moon Modeler. Reduce changes to one location for better efficiency. HTML Reports & Generating documentation for noSQL Discover the process of generating documentation for noSQL databases. Create detailed HTML reports with ease using Moon Modeler. Updating projects and ER diagrams In Luna Modeler 5 you can compare your project with your database, review differences and easily update your project and ER diagram. Themes in Moon Modeler Uncover the benefits of using themes in Moon Modeler, including instant changes to your diagrams and user interface settings. Sub-diagrams in Moon Modeler Learn how to use sub-diagrams in Moon Modeler for better organization in your projects, focusing on specific parts of your data model. ER diagrams & sub-diagrams Draw ER diagram on one diagram or create multiple sub-diagrams for specific parts of your database design. Secure database connections - SSH/SSL/TLS Read how to create a new secure database connection, load the database structure and create an ER diagram from noSQL databases. Moon Modeler User Interface Moon Modeler - a data modeling tool for noSQL databases. Find out the basics and see various elements of the user interface. Moon Modeler - Visual Schema Design Tool for noSQL Databases Visual database modeling for MongoDB, Mongoose ODM, DocumentDB and Cosmos DB. Design, generate, and document NoSQL schemas with ease. Forward engineering & SQL scripts Generate SQL CREATE scripts from your ER diagram in Luna Modeler. Supports PostgreSQL, MySQL, Oracle, SQL Server, MariaDB & SQLite. Database Schema Conversion in Luna Modeler Learn about database schema conversion. Find out how Luna Modeler can help you with the conversion from one database platform to another. Interactive HTML reports Generate interactive HTML reports from your ER diagrams in Luna Modeler. Share database documentation with your team without extra tools. Database Schema Comparison & HTML Reports Compare two database schema versions in Luna Modeler and generate a visual HTML diff report highlighting added, modified & removed objects. Referenced Objects Learn how to easily detect dependencies and how to add referenced objects to an ER diagram created in Luna Modeler - data modeling tool. Projects & Data models Create and manage data modeling projects in Luna Modeler. Start from scratch, reverse-engineer a database or import an existing schema. Projects & Data models Create a new database design or schema design from scratch, by reverse engineering existing databases or by importing metadata from files. Luna Modeler User Interface Dive into our guide on the Luna Modeler user interface and enhance your experience with practical insights on its core components. Luna Modeler - Database Design Tool for Relational Databases A data modeling tool that supports creation of ER diagrams for databases like Oracle, SQL Server, PostgreSQL, MariaDB and other RDBMS. Reverse engineering Connect to PostgreSQL, MySQL, Oracle or SQL Server and automatically generate ER diagrams from your live database. Luna Modeler — free trial. Subject Areas in data models Use subject areas in Luna Modeler to group related tables and organise complex ER diagrams into logical sections. Generating Schema Synchronization Scripts Learn how to compare a project created in Luna Modeler with an existing Oracle Database and how to generate schema synchronization scripts. Generating Schema Synchronization Scripts Learn how to compare a project created in Luna Modeler with an existing Oracle Database and how to generate schema synchronization scripts. Version Control & Explorer Track and manage different versions of your ER diagrams directly in Luna Modeler using the built-in Version Control Explorer. Layout - for an Easy Arrangement of Diagram Items Learn how the Layout function in Luna Modeler enables an easy arrangement of diagram items for better readability and structure. Dependencies in Data Models Discover how to create and manage dependencies in data models with Luna Modeler for comprehensive data visualization. Generating Alter Scripts for MySQL Learn how to compare MySQL schema and generate alter scripts for changes detected by Luna Modeler - a database design tool. Generating Synchronization SQL Scripts for MariaDB Learn how to compare MariaDB schema and generate synchronization SQL scripts for changes detected by Luna Modeler - a database design tool. How to Generate Synchronization Scripts in Luna Modeler Learn how to easily compare your project to existing database structures and how to generate synchronization scripts in Luna Modeler Database connections Set up connections to PostgreSQL, MySQL, Oracle & SQL Server in Luna Modeler. Load the database schema and generate ER diagrams automatically. Visualization of existing PostgreSQL databases Connect to a PostgreSQL database and reverse engineer your existing database structures. Visualize databases and create ER diagrams. Explorer for Organized Version Control Learn how to manage different versions of your data models directly in Luna Modeler. Themes - How to Make Nice Diagrams Learn how to create nice ER diagrams in Luna Modeler, how to change the theme and modify diagram settings. How to Generate Alter Scripts for Oracle Databases Learn how to compare a project created in Luna Modeler with an existing Oracle Database and how to generate SQL scripts for the differences. How to submit an error log? We test new versions of Moon Modeler both manually and with automatic tests. However, an error might occur. See how to submit an error log. Visualization of existing MongoDB databases How to create a connection, run MongoDB reverse engineering and visualize existing MongoDB structures in form of a ER diagram. Generating MongoDB Schema Validation Scripts Generation of MongoDB schema validation scripts. Draw diagrams in Moon Modeler and generate MongoDB schema validation scripts. Mongoose schema design Mongoose schema design in Moon Modeler - draw diagrams for Mongoose ODM and generate Mongoose schema creation scripts or generate reports. PostgreSQL database design Luna Modeler for PostgreSQL database design. See how to visually create ER diagrams for PostgreSQL and generate SQL Scripts PostgreSQL ER diagram - graphics Use Luna Modeler and visualize PostgreSQL tables, composite types and other objects in a PostgreSQL ER diagram. Enumerated type - Enum - PostgreSQL How to define enumerated types (enum) for PostgreSQL in Luna Modeler - ER diagram tool for PostgreSQL and other databases. Domains in PostgreSQL projects Read how to specify PostgreSQL domains in Luna Modeler, a database modeling tool for PostgreSQL and other databases. Generating SQL scripts for PostgreSQL Read how to easily generate SQL script for PostgreSQL in Luna Modeler. Draw ERD and generate SQL for PostgreSQL database designs. MariaDB database design Luna Modeler - a tool for MariaDB database design. See how to visually create database design for MariaDB and how to generate SQL scripts. Sequelize schema design Draw diagrams for Sequelize ORM. Use Meteor Modeler for visual schema design and generate code for Sequelize automatically. Meteor Modeler for Sequelize ORM Meteor Modeler is a visual ORM design tool for Sequelize. Draw diagrams, define models and generate Sequelize code automatically. Primary and foreign keys in MariaDB projects How to define primary keys, foreign keys and primary foreign keys in Luna Modeler, a tool for database design for MariaDB and other platforms MariaDB indexes How to create indexes in Luna Modeler - data modeling tool for MariaDB, PostgreSQL, SQL Server and other relational databases. MySQL database design Luna Modeler - a data modeling tool for MySQL database design. Learn how to draw ER diagrams and generate SQL scripts easily. Visualization of existing MariaDB databases Connect to a MariaDB database and reverse engineer your existing database structures. Visualize databases and create ER diagrams. Generating SQL script for MariaDB How to generate SQL scripts for MariaDB database design in Luna Modeler - a data modeling tool for MariaDB and other databases. Other database objects in MariaDB projects How to define other database objects like stored procedures, functions, triggers and other MariaDB specific objects in Luna Modeler Enum and Set in MariaDB projects Enum and Set datatypes defined for MariaDB in Luna Modeler - a data modeling tool for MariaDB, PostgreSQL and other databases. Relationships in ER diagrams for MariaDB Database modeling and relationships defined in Luna modeler - a tool for visual database modeling for MariaDB and other databases. Primary and foreign keys in MySQL projects How to define primary keys, foreign keys and primary foreign keys in Luna Modeler, a tool for database design for MySQL and other platforms Generating SQL script for MySQL How to generate SQL scripts for MySQL database design in Luna Modeler — a data modeling and ER diagram tool for MySQL and other databases. Visualization of existing MySQL databases Connect to MySQL and reverse engineer existing database structures. Visualize databases and create ER diagrams. SQLite database design Luna Modeler - a tool for SQLite database design. See how to visually create database design for SQLite and generate SQL script. Import & Visualization of existing SQLite databases Import SQLite files and reverse engineer existing database structures. Visualize databases and create ER diagrams for your SQLite structures. GraphQL Schema Design Learn how to create a GraphQL schema design in Galaxy Modeler. See how to draw a diagram and display GraphQL structures easily. Line modes in GraphQL schema diagram A schema design tool for GraphQL. Draw diagrams and generate scripts or easy to understand documentation using our data modeling tools. Script Generation for GraphQL Learn how to generate a GraphQL schema with Galaxy Modeler a data modeling and schema design tool for GraphQL. Script generation for Sequelize How to use Meteor Modeler for script generation for Sequelize. Automatically generate creation scripts from your Sequelize projects. Default values How to define default values for new objects in Moon Modeler - database modeling and reporting tool for various platforms. Custom data types How to define custom data types for your projects in Luna Modeler. Add new data types as needed and generate SQL or schema validation scripts Export ER diagram to PDF Read how to export ER diagram to PDF easily. Visualize your database structure and export it to PDF for high-quality printing. Compare Editions Compare Moon Modeler with other NoSQL data modeling tools. See how Moon Modeler stacks up for MongoDB schema design and documentation. MongoDB ER diagram & Graphics ER Diagram tool for visualization of MongoDB database structures. See collections, fields, documents and references in MongoDB ER diagrams. MongoDB indexes Learn how to create indexes in projects for MongoDB. Try Moon Modeler - data modeling and schema design tool for MongoDB and other databases. How to draw ER diagrams for MongoDB How to draw ER diagrams for MongoDB in Moon Modeler | Video | Learn how to easily draw diagrams for MongoDB schema design. How to visualize a MongoDB schema How to visualize a MongoDB schema in Moon Modeler | Video | Learn how to connect to your MongoDB database and create a diagram automatically. Importing a GraphQL schema from URL GraphQL schema visualization. Learn more about how to import a GraphQL schema from URL and how to automatically create a diagram. Importing a GraphQL schema from a file Learn how to import a GraphQL schema and create a diagram. Use our data modeling tool for visualization of GraphQL schemas. MongoDB schema design MongoDB schema design in Moon Modeler, a tool for creation, visualization and code generation for MongoDB schema designs. Compare Editions Compare Luna Modeler's Basic, Professional and Ultimate editions, including the version 14 additions: Navigator - Context Lens, the folder-based Git format and the headless CLI. Luna Modeler - Key features Check out the key features and benefits of Luna Modeler - database design tool - in a short introductory video. How to visualize existing PostgreSQL databases How to visualize existing PostgreSQL database structures using Luna Modeler | Video | Database design tool. Updating PostgreSQL projects Read how to create a new database connection and update your existing PostgreSQL ER Diagram created in Luna Modeler - a database design tool. Updating SQLite projects Read how update your existing SQLite entity relationship diagram created in Luna Modeler - a database modeling tool for relational databases. SSH or SSL/TLS database connections Connect to databases securely over SSH tunnels, SSL or TLS in Luna Modeler. Load schema structure and auto-generate ER diagrams. SSH or SSL/TLS database connections Read how to create a new secure database connection, load the database structure and create an ER diagram from relational and noSQL databases. SQL Server database design Luna Modeler for SQL Server database design. See how to visually create ER diagrams for SQL Server and generate SQL scripts. Updating SQL Server projects Read how to create a new database connection and update your existing SQL Server ER Diagram created in Luna Modeler - a database design tool. How to generate SQL script for SQL Server Read how to easily generate SQL script for SQL Server in Luna Modeler. Draw ERD and generate scripts for your SQL Server database designs. SQL Server indexes How to create indexes in Luna Modeler - data modeling tool for SQL Server and other relational databases like PostgreSQL, MySQL, MariaDB etc. How to easily update ER diagrams in Luna Modeler Learn how to easily compare your project to existing database structures and how to update ER diagrams in Luna Modeler How to work with sub-diagrams in Luna Modeler - Professional Edition Learn how to split large ER Diagram to multiple sub-diagrams easily in Luna Modeler and how to work with referenced objects. Galaxy Modeler for GraphQL Schema Design A schema design tool for GraphQL. Draw diagrams, import existing GraphQL schema, generate HTML reports or GraphQL schema definition scripts. Conversion from MongoDB to Mongoose How to convert a MongoDB project to Mongoose in Moon Modeler. Load existing MongoDB structure and generate Mongoose scripts. How to configure a proxy in Luna Modeler Learn how to configure a proxy server in Luna Modeler to activate your license and connect to databases from behind a corporate firewall. Advanced Copy and Paste in Luna Modeler See how to copy and paste one or more tables or individual columns in your ERD. Find out how to work with dependencies in Luna Modeler. Advanced Copy and Paste in Moon Modeler See how to copy and paste one or more collections or individual fields in MongoDB ERD. Find out how the Paste inside works in Moon Modeler. Advanced Copy and Paste in Galaxy Modeler See how to copy and paste one or more types or individual properties in GraphQL schema design. Find out advanced features in Galaxy Modeler. Naming Conventions for PostgreSQL Learn how to use naming conventions for PostgreSQL, how to synchronize object names and how to generate SQL script using Luna Modeler. Using Enum in Mongoose Learn how to define Mongoose Enum in a project created with Moon Modeler - data modeling tool for MongoDB and Mongoose. Copy and Apply Format Learn how to select the format of a graphical object and apply it to other selected objects in our data modeling tools. Multiple Data Types in MongoDB Projects Learn how to use multiple data types for a field in your MongoDB collection and how to specify restrictions in Moon Modeler for MongoDB. Enum in MongoDB Learn how to define Enum in a MongoDB project created with Moon Modeler - data modeling tool for MongoDB and Mongoose. Validation in MongoDB Learn how to set validation criteria for MongoDB project created with Moon Modeler - data modeling tool for MongoDB and Mongoose. PostgreSQL Indexes How to create PostgreSQL indexes in Luna Modeler - data modeling tool for PostgreSQL and other relational and databases. Relationships in ER diagrams for PostgreSQL Learn how to define relationships in ER diagrams for PostgreSQL and find out how to use Luna modeler - a database modeling for PostgreSQL Composite types & PostgreSQL ER Diagram Learn how to define composite types for PostgreSQL in Luna Modeler - ER diagram tool for PostgreSQL and other databases. Other database objects in PostgreSQL Learn how to define other database objects like functions, triggers, views and other PostgreSQL-specific objects in Luna Modeler. Datatype aliases How to define data type aliases for your projects in Luna Modeler. Add new data types as needed and generate SQL scripts. Logical data model Learn how to use Luna Modeler for logical data model. See how to visually create ER diagrams and convert them to selected target platform. Database Schema Conversion Explore how to convert a database schema from PostgreSQL to SQL Server using Luna Modeler database design tool. How to repair your project Learn how to manually repair older or corrupted Luna Modeler and Moon Modeler project files, and how to send diagnostic logs to Datensen support. How to solve problems with license activation Troubleshoot license activation problems in Luna Modeler, Moon Modeler and Galaxy Modeler — steps for offline activation, proxy issues and common errors. Custom Schema Definition See where to specify custom schema definition for MongoDB in Moon Modeler - database modeling tool. Explore noSQL data modeling. Customizations and Custom Properties Our data modeling tools are customizable. Add your own custom properties and turn the tool into RAD - rapid application development tool. How to use Custom Properties in Luna Modeler Learn how to work with custom properties in Luna Modeler, how to activate customizations and how to generate custom output. References in Diagrams for MongoDB Learn how to define references in ER diagrams for MongoDB and find out how to use Moon modeler - a database modeling for noSQL. Simple Lines in Diagrams for MongoDB Learn how to define simple lines in ER diagrams for MongoDB and find out how to use Moon modeler - a database modeling for noSQL. Containment Lines in Diagrams for MongoDB Learn how to define containment lines in ER diagrams for MongoDB and find out how to use Moon modeler - a database modeling for noSQL. References, Lines and Containment Lines Learn how to define references and lines in diagrams for noSQL database and find out how to use Moon modeler. Objects on Diagrams for MongoDB ER Diagram tool for visualization of MongoDB database structures. Learn the object types displayed in Moon Modeler - database design tool. Grouping & Alignment For efficient visualization of objects in a diagram for noSQL, use automatic grouping, and different display modes in Moon Modeler. Moon Modeler - Key features Check out the key features and benefits of Moon Modeler - database design tool - in a short introductory video. Are some buttons on the toolbar disabled? Fix inactive or greyed-out toolbar buttons in Luna Modeler or Moon Modeler — step-by-step troubleshooting guide to restore full UI functionality. Updating MariaDB projects Read how to create a new database connection and update your existing MariaDB ER Diagram created in Luna Modeler - a database design tool. Updating MySQL projects Read how to create a new database connection and update your existing MySQL ER Diagram created in Luna Modeler - a database design tool. Galaxy Modeler - Key features Check out the key features and benefits of Galaxy Modeler - a schema design tool for GraphQL - in a short introductory video. Visualization of existing Oracle Databases Connect to your Oracle Database, visualize the database structure and create ER diagrams automatically in Luna Modeler. Generating SQL Scripts for Oracle Database Read how to easily generate SQL script for Oracle Database. Draw ERD and generate SQL for Oracle Database using Luna Modeler. Indexes in Oracle Database How to create indexes in Luna Modeler - a data modeling tool for Oracle Database and other relational databases. Relationships in ER diagrams for Oracle Database Learn how to define relationships in ER diagrams for Oracle Database and find out how to use Luna modeler - a database modeling for Oracle ER diagram - Graphics in projects for Oracle Database Use Luna Modeler and visualize Oracle tables, procedures, view, synonyms and other objects in ER diagrams for Oracle. Updating projects for Oracle Database Read how to create a new database connection and update your existing ER Diagram for Oracle Database created in Luna Modeler. Oracle Synonyms How to define synonyms in projects for Oracle Database. Learn how to define and visualize synonyms in ER diagrams in Luna Modeler. Oracle Database Types How to define Types in projects for Oracle Database. Learn how to define and visualize types in ER diagrams in Luna Modeler. Logical Data Modeling Across Databases Explore the benefits of a logical data modeling across databases. Learn how to create a logical model in Luna Modeler. Conceptual data model Learn how to create a conceptual data model in Luna Modeler. Visually sketch entities and relationships before committing to a physical schema. How to Add an Identity Column to SQL Server Database Design Learn how to add an Identity column to your SQL Server database design in Luna Modeler database design tool.
