# app

# Datensen.com

Datensen.com is a website created by Ideamerit, a company based in the Czech Republic. The Ideamerit company is a manufacturer of software products for data modeling. Its main products are:
1. Luna Modeler - a data modeling tool for relational databases
2. Moon Modeler - a data modeling tool for NoSQL, and
3. Galaxy Modeler for GraphQL schema design. 
The company works with professionals who have 20+ years of experience in data modeling and software development for database design and management.

# Luna Modeler

Luna Modeler is a powerful and user-friendly data modeling tool designed for relational databases such as Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, and SQLite. It enables developers and database architects to create and manage data models with ER diagrams, perform reverse and forward engineering, and generate SQL scripts or database documentation with ease.

To get Luna Modeler installer, head over to the [Downloads page](https://www.datensen.com/downloads) and download an installer for your operating system.
Luna Modeler is available for macOS, Windows, and Linux.

## What can I do with Luna Modeler

1. Draw data models easily and quickly - For popular databases like Oracle, PostgreSQL, MySQL, SQL Server, MariaDB, SQLite and compatible systems
2. Visualize existing database structures - Create ER diagrams from existing databases, add notes, and better describe your data models.
3. Create interactive documentation - Share your pixel-perfect diagrams in PDF format or generate interactive HTML reports.
4. Generate SQL scripts - Preview and save DDL/SQL code or easily write templates for your own custom scripts.
5. Compare & Synchronize - Compare data models with databases, generate reports, update data models or generate synchronization scripts.

## Key Features of Luna Modeler

- Visual creation of data models and ER diagrams for relational databases.
- Offline data modeling - for testing, validating, and optimizing data structures in a safe environment without disrupting live systems.
- Support for database-specific features, such as: PostgreSQL composite types or domains, SQL Server user-defined types, Oracle Database Types and Packages etc.
- Intuitive and user-friendly interface that simplifies database modeling for developers of all skill levels.
- Customizable diagram views, including multiple display modes, layout styles, and color themes.
- Forward engineering capabilities to generate SQL scripts and create database structures from data models.
- Reverse engineering tools to visualize existing database schemas.
- Secure database connections via SSL/TLS for cloud-hosted solutions such as Supabase and managed PostgreSQL instances or Cloud Wallet based connections for Oracle Databases.
- Import functionality for SQLite and other database project files.
- Generation of Interactive HTML reports and options to export diagrams to images or multi-page PDF files.
- Automatic diagram and project updates to reflect changes in the database structure.
- ALTER script generation for schema synchronization for Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, and SQLite.
- Schema conversion tools to transform database designs between different relational database platforms.

## FAQ - Frequently Asked Questions on Luna Modeler and data modeling for relational databases

## Who is Luna Modeler for?

Luna Modeler is the perfect fit for database professionals, developers, 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.

###  Why Choose Luna Modeler?

If you're looking for a modern, clean, and efficient data modeling tool, look no further than Luna Modeler! It's perfect for professionals who want an easy-to-use modeling experience.

### What databases does Luna Modeler support?

Luna Modeler supports PostgreSQL, Oracle, SQL Server, MariaDB, MySQL and SQLite.

### Does Luna Modeler store data in the cloud?

Luna Modeler is a fully offline-first application. It does not upload or store your projects, database connections, or diagrams in the cloud. You are in complete control of your data at all times.

### Is Luna Modeler available on Windows, macOS, and Linux?

Yes, Luna Modeler is cross-platform. You can install and run it on Windows, macOS, and Linux systems. A 14-day free trial of the Professional edition is available, with access to all advanced features and minimal limitations.

### What are some benefits of Luna Modeler?

1. Work offline on your model - Design first, deploy when ready
2. Reliable and repeatable SQL generation - Generate and run SQL only when your model is complete
3. Easy model-to-database synchronization - Quickly update your live database with visual changes
4. Better decision making - data modeling tools help in better decision making by providing a clear understanding of the data, which makes it easier for stakeholders to make informed decisions. This is especially important in businesses where decisions are data-driven.
5. Increased productivity - Luna Modeler helps increase productivity by enabling rapid database design and automating repetitive tasks such as generating SQL scripts, creating database diagrams from existing databases, and generating interactive reports. This saves time and allows developers to focus on more important tasks.
6. Cost-effective solution - Luna Modeler is cost-effective in the long run as it helps in reducing the development time and effort required to create a database. This saves money for the organization and ensures that the project is completed within budget and on time.
7. Enhanced data quality - Luna Modeler helps to improve data quality by providing a structured way of organizing data. Use Luna Modeler to make sure your database is free of inconsistencies, redundancies and errors, ensuring data accuracy and reliability.

### Does Luna Modeler support customization of objects and generation of custom outputs?

Absolutely. Luna Modeler supports customization. You can define custom properties for database objects, display those properties within your ER diagrams, and even write custom code generation templates. This makes it easy to align the tool with your development workflow and output standards.

### How do themes and display settings in Luna Modeler improve ER diagram readability?

Themes and display options make diagrams more clear and professional. Luna Modeler offers a variety of visual themes and customizable display settings that help you create clean, consistent, and visually appealing diagrams. Whether you're preparing internal documentation or client-facing presentations, the styling options - from professional to hand-drawn - let you adapt the appearance to your audience.

### Can I use Luna Modeler for NoSQL databases?

Luna Modeler is designed for relational databases. For NoSQL databases like MongoDB, try Moon Modeler.

### Can I visualize an existing Oracle Database in Luna Modeler?

Yes. Luna Modeler can connect to an existing Oracle database and generate a data model with an ER diagram based on your schema. You can then add notes to the diagram, change the structure, and synchronize the data model with the database.

### Can the tool securely connect to databases using Luna Modeler?

Yes. SSH, SSL, TLS, Cloud Wallet and Custom connections are supported in Luna Modeler professional edition.

### Can I generate SQL scripts from ER diagrams created with Luna Modeler?

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

### Does Luna Modeler support Oracle-specific features?

Absolutely. In Luna Modeler, you can work with basic database objects such as tables, relationships, as well as types, packages, sequences, triggers, synonyms, and other Oracle-specific database objects.

### How does the Luna Modeler software handle synchronization between model and database?

In Luna Modeler, you can compare the model with the database and then generate an HTML report, update the model or generate SQL scripts for the differences.

### 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.

### What reporting and documentation capabilities does Luna Modeler 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.

### 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

### Can I generate schema diff and synchronization reports with Luna Modeler?

Yes. Luna Modeler can compare your data model with the database and display the differences. You can generate a report in various styles easily.

### Can I generate SQL scripts from entity relationship diagrams created with Luna Modeler?

Yes, you can generate clean, SQLite-compatible SQL scripts directly from your visual database models.


### What are some alternatives to Luna Modeler?

1. erWin data modeler - comprehensive solution trusted by many users and large organizations. It offers deep feature sets that support enterprise-level database modeling. However, for users or teams seeking an alternative, Luna Modeler offers a compelling and affordable solution.
2. ER/Studio - trusted by many users and organizations. It offers a wide range of features. But if you're looking for an alternative, Luna Modeler is an excellent option. It's affordable, and it's got some really cool features.
3. Vertabelo - a popular online modeling solution, especially for teams looking to collaborate in the cloud. However, some users prefer a more private, offline-friendly environment or want a solution that doesn't require a subscription model. That's where Luna Modeler shines.
4. MySQL Workbench - Luna Modeler offers a powerful alternative to MySQL Workbench, with advanced features specifically designed for MariaDB, including visual design, reverse engineering, and SQL generation.

### Why not just create the database structure directly and why bother with a modeling tool like Luna Modeler? 

Well, the answer is simple. Think of it like building a house: you wouldn't start laying bricks or installing windows without a complete architectural plan. The same logic applies to databases. In fact, data modeling is an ongoing process. Many adjustments happen along the way, and - just like with a house - you typically wait until the blueprint is finalized before beginning construction. Likewise, it's best to create your actual database only when the model feels complete. Sure, you can build your database table by table. But planning it visually and thoroughly in advance is almost always more efficient - and definitely more convenient.

## System requirements

Luna Modeler generally supports Apple Silicon Macs, Windows, and Linux.

# Moon Modeler

Moon Modeler is a powerful and user-friendly data modeling tool for NoSQL databases. It supports MongoDB and Mongoose ODM out of the box, and can also be used with Amazon DocumentDB, Azure Cosmos DB, and similar document-oriented databases. Use Moon Modeler to create noSQL diagrams, design MongoDB schemas visually, generate scripts, and produce interactive documentation. 

To get Moon Modeler installer, head over to the [Downloads page](https://www.datensen.com/downloads) and download an installer for your operating system.
Moon Modeler is available for macOS, Windows, and Linux.

## What can I do with Moon Modeler

1. Design clear and structured NoSQL data models
2. Create data models with ER diagrams and schema documentation
3. Generate validation scripts and Mongoose schemas
4. Export schema designs and data models to interactive HTML or PDF reports
5. Convert MongoDB data models to Mongoose

## Key Features of Moon Modeler

- Visual creation of data models and ER diagrams for NoSQL databases like MongoDB and Mongoose
- Support for database-specific features (e.g., capped collections, validation levels)
- User-friendly interface with customizable diagram settings
- Forward engineering and code generation for MongoDB and Mongoose
- Reverse engineering of existing MongoDB databases
- Secure SSL/TLS connections to cloud-based solutions
- Interactive HTML report generation and PDF export
- Conversion of MongoDB projects to Mongoose models
- Support for multiple diagrams within a single project

## FAQ - Frequently Asked Questions on Moon Modeler and data modeling for noSQL

### What tool is ideal for creating schema diagrams for MongoDB databases?
Moon Modeler is a specialized data modeling tool for MongoDB and noSQL databases that lets you visually design collections, documents, and references with ease.

### Which NoSQL databases are supported in Moon Modeler?

Moon Modeler includes support for MongoDB and other MongoDB-compatible database systems such as CosmosDB, DocumentDB.

### Can I generate scripts for MongoDB from diagrams created in Moon Modeler?

Yes. You can generate MongoDB validation scripts directly from your visual data models.

### Can I visualize existing MongoDB database into a diagram using Moon Modeler?

Yes. Moon Modeler can connect to your MongoDB database and generate a diagram from existing schema. You can visualize locally running, on-premises and cloud databases.

### Is there a way to document MongoDB structures visually?

Absolutely. Moon Modeler allows you to export your diagrams as PNG, PDF, or generate interactive HTML documentation in various themes and styles.

### Is Moon Modeler cloud-based, desktop-based, or hybrid?

Moon Modeler is a desktop application and it's available for Windows, macOS, and Linux. Database connections and data models are not stored in the cloud. Everything you create stays with you.

### Is Moon Modeler an alternative to other MongoDB schema design tools?

Yes. Moon Modeler is a feature-rich alternative to other data modeling and schema design tools for MongoDB. It supports embedded documents (contained objects), references, validation rules, and also conversion to Mongoose ODM.

### What is the difference between Luna Modeler and Moon Modeler?

Luna Modeler is a data modeling tool for relational databases such as Oracle, PostgreSQL, MySQL, SQL Server, MariaDB and SQLite. Moon Modeler is a schema design tool for MongoDB and other noSQL databases.

### Is Moon Modeler a good alternative to manual Mongoose schema definition?

Yes, Moon Modeler provides a powerful visual environment that reduces errors and boosts productivity compared to manual code creation.

### Can I generate Mongoose-compatible schema code from diagrams created in Moon Modeler?
Yes. Moon Modeler can generate Mongoose schema code based on your visual model, saving you time and ensuring consistency.

### Does Moon Modeler support references between documents in Mongoose?

Yes, you can visually define references (ObjectId) and embedded documents (contained objects) to reflect Mongoose references accurately.

# Datensen: Data Modeling Tools

## Pages
- [Luna Modeler - product page](https://www.datensen.com/luna-modeler-for-relational-databases.html)
- [About Luna Modeler - Database Design Tool for Relational Databases](https://www.datensen.com/blog/docs/about-luna-modeler-a-database-design-tool-for-relational-databases/)
- [Moon Modeler - product page](https://www.datensen.com/moon-modeler-for-databases.html)
- [About Moon Modeler - Visual Schema Design Tool for noSQL Databases](https://www.datensen.com/blog/docs/about-moon-modeler-data-modeling-tool/)
- [Purchase](https://www.datensen.com/purchase.html)
- [Download](https://www.datensen.com/download.html)
- [Impressum](https://www.datensen.com/blog/impressum/)

## Pages per database platform
- [Data Modeling Tools](https://www.datensen.com/blog/data-modeling-tools/)
- [Data Modeling Tool for MongoDB](https://www.datensen.com/blog/data-modeling-tool-for-mongodb/)
- [Data Modeling Tool for SQL Server](https://www.datensen.com/blog/database-design-tool-for-sql-server/)
- [Data Modelling Tool for MariaDB](https://www.datensen.com/blog/database-modelling-tool-for-mariadb/)
- [Database Design Tool for Oracle Databases](https://www.datensen.com/blog/database-design-tool-for-oracle-databases/)
- [Database Design Tool for PostgreSQL](https://www.datensen.com/blog/database-design-tool-for-postgresql/)
- [ER Diagram Tool for MySQL](https://www.datensen.com/blog/er-diagram-tool-for-mysql/)
- [ERD Creator for SQLite](https://www.datensen.com/blog/erd-creator-for-sqlite/)

## Posts
- [Data Model Overview: Three Main Types Explained](https://www.datensen.com/blog/data-modeling/data-model/)
- [Top 5 GUI tools for PostgreSQL in 2025](https://www.datensen.com/blog/postgresql/top-5-gui-tools-for-postgresql/)
- [How to List Databases and Tables in PostgreSQL](https://www.datensen.com/blog/postgresql/how-to-list-databases-and-tables-in-postgresql/)
- [NoSQL Data Modeling](https://www.datensen.com/blog/data-modeling/nosql-data-modeling/)
- [How to list databases and show collections in MongoDB](https://www.datensen.com/blog/data-modeling/show-collections-mongodb/)
- [Top 5 GUI Tools for SQLite in 2025](https://www.datensen.com/blog/sqlite/top-5-tools-for-sqlite/)
- [Looking for an erwin Data Modeler Alternative? Discover Luna Modeler](https://www.datensen.com/blog/data-modeling/data-modeling-alternative/)
- [Looking for an alternative to ER/Studio? Try Luna Modeler](https://www.datensen.com/blog/data-modeling/discover-luna-modeler-alternative-data-modeling-tool/)
- [A Fresh Alternative to Vertabelo - Discover Luna Modeler](https://www.datensen.com/blog/data-modeling/desktop-alternative-to-online-data-modeling-tools/)

# Company contact information
Legal entity name: Ideamerit s.r.o.
Country: Czech Republic, European Union
Website: https://www.datensen.com

# Sitemap

The XML sitemap of this website can by found by following [this link](https://www.datensen.com/sitemap.xml) and [this link](https://www.datensen.com/blog/sitemap_index.xml)