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. How to List Databases and Show Collections in MongoDB Learn how to show collections in MongoDB using show collections, db.getCollectionNames() or db.getCollectionInfos() — plus a visual approach with Moon Modeler. Top 5 Data Modeling Software Products to Know in 2026 Explore the top 5 data modeling software options that empower software development, database design, analytics, and business processes. Easy Steps to Connect to Supabase and Visualize Your Database with Luna Modeler Learn how to seamlessly connect to Supabase and visualize your database using Luna Modeler. Simplify your data workflow with our easy guide! Visualizing Database Dependencies: A Guide to Impact Analysis and Database Auditing Learn how to use Luna Modeler to automatically infer dependencies between views, stored procedures, and tables for better impact analysis. Visual Database Design for Consultants: How Luna Modeler Saves Time on Complex Projects The best visual database design tool for consultants. Supports Oracle, PostgreSQL, SQL Server, MySQL and more. Top 6 GUI Tools for SQLite in 2026 Explore the best tools for SQLite to generate and execute SQL scripts effortlessly. Create and manage your databases with ease! Primary Key vs Unique Key What's the difference between primary keys and unique keys? Learn how to define a unique key, how to use the key for relationships and more. What is a Data Model? Three Main Types Explained Learn about data models and their key types - conceptual, logical, and physical. Discover powerful tools for the easy creation of data models. Top 5 Tools for Data Flow Diagrams Find the best data flow diagram tools for easy modeling and exporting. Create effective diagrams with the right software. Top 5 GUI tools for PostgreSQL in 2026 Awesome GUI tools to execute your SQL scripts for PostgreSQL. Pick one of the 5 top GUI tools for PostgreSQL and manage your databases easily. Top 5 FREE Flowchart Diagram Tools (Desktop, No SaaS Required) Discover the best FREE desktop flowchart diagram tools that run 100% offline - no SaaS, no cloud, no subscriptions. Custom Templates & Scripts All Datensen products support custom templates for generating SQL scripts, HTML, CSV and JavaScript outputs. Learn how to create snippets etc. How to Create a Flowchart Diagram with the Freeware Merit Modeler Discover how to build a professional flowchart diagram with Merit Modeler. Freeware, easy to use, and available for major operating systems How to Create a Data Flow Diagram Using the FREE Merit Modeler Discover how a data flow diagram can simplify your approach to software engineering and how to use the FREE Model Merit for drawing DFD How to Build a Use Case Diagram in Merit Modeler (Freeware) Find out how a use case diagram helps identify actor goals and interactions and how to draw use case diagrams in the Merit Modeler freeware. Documenting Databases Using ER Diagrams Discover the importance of ER diagrams when documenting databases. This article describes various aspects of database documentation. How to Generate Delta Scripts for Database Changes Discover how to generate delta scripts for database changes with our easy-to-follow guide. Enhance your database management skills today! How to Compare SQL Database Schemas Discover how to effectively compare SQL database schemas using Luna Modeler. Our guide offers step-by-step instructions. SQL Database Creator Luna Modeler - a SQL database creator that allows you to generate SQL scripts for many databases. Draw diagrams and create SQL scripts. How to make a diagram of your GraphQL schema Learn how to make a diagram of GraphQL schema, how to edit the diagram and create a PDF or interactive HTML report. NoSQL Data Modeling NoSQL data modeling and MongoDB schema design. Draw diagrams, describe database structures and improve productivity with Moon Modeler. Many-to-Many Relationships Many to many relationships in entity relationship diagrams explained. Draw ER diagrams and design database structures easily. One-to-Many Relationships One to many relationships explained. Draw entity relationship diagrams, define entities, attributes and relationships easily in Luna Modeler. How to Easily Set Up Postgres with Docker and Work with Your Database - Using Visual Tools Only Learn how to set up Postgres in Docker Desktop, connect it to Luna Modeler for visual schema design, and manage your database using pgAdmin. How to Quickly Set Up MySQL with Docker Desktop and Manage Your Database Structures Learn how to set up MySQL in Docker Desktop, create a data model in Luna Modeler and run generated SQL scripts using VS Code. How to Set Up MongoDB with Docker Desktop and Work with Your Database Using GUI Tools Discover the easiest way on how to setup MongoDB with Docker Desktop and manage your data models visually with Moon Modeler. Designing a Sports Tournament Data Model for PostgreSQL Explore the data model sport tournaments with a structured PostgreSQL approach for managing teams and matches effectively. Hierarchy Modeling in NoSQL Databases Explained Learn the essentials of hierarchy modeling for NoSQL databases and enhance your data structures effectively. AWS Amazon DocumentDB Learn how to connect to Amazon DocumentDB using Moon Modeler and create a diagram of your database effortlessly. What is Database Modeling? Database modeling is an essential step in the database design process. Read more information and tips for using database modelling tools. Step-by-Step Guide: Creating an ER Diagram from Azure SQL Server Database Structure Creating ER diagrams is very easy in Luna Modeler. Learn how to create a connection to an Azure SQL Server database and how to create ERD. How to List Databases and Tables in PostgreSQL Learn how to list databases and show tables in PostgreSQL. Use a command-line tool or create an ER diagram in Luna Modeler. 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. Default values How to define default values for new objects in Moon Modeler - database modeling and reporting tool for various platforms. 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. Heroku Postgres and ER diagrams Learn how to connect to Heroku Postgres and how to create ER diagrams easily. Try Luna Modeler - database modeling tool. Data Modeling Tools - How to install AppImage on Ubuntu 22 Learn how to install Luna Modeler or Moon Modeler on Ubuntu 22. Install libfuse2, check permissions and run the downloaded AppImage file. How to configure a proxy in Moon Modeler Learn how to configure a proxy server in Moon Modeler to activate your license and connect to MongoDB from behind a corporate firewall. 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. How to configure a proxy in Galaxy Modeler Learn how to configure a proxy server in Galaxy Modeler to activate your license and connect to GraphQL endpoints from behind a corporate firewall. 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. Deprecation Warning: Setting the TLS ServerName to an IP address is not permitted by RFC 6066 See how to solve the setting the TLS ServerName to an IP address is not permitted warning, modify the hosts file & make ERD from SQL Server. 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. 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. 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. One-to-One Relationships One to one relationships explained. Draw entity relationship diagrams with entities, attributes, relationships and describe your databases. Data modeling & Objectives and Key Results Use visual tools to define OKRs, mindmaps and decision trees for your data modeling goals. How to Use the CREATE TABLE Statement in PostgreSQL to Create a New Table Learn how to use the CREATE TABLE statement in PostgreSQL database to create a new table and how to generate DDL scripts using Luna Modeler. How to Visualize SQL Server Express Database Learn how to create a connection to an SQL Server Express database and how to create ERD from existing database structure using Luna Modeler AdventureWorks Sample Database Learn how to visualize the AdventureWorks sample database and how to easily create an ER diagram with Luna Modeler. ER Diagram Tool Explore the features of Luna Modeler - ER Diagram tool. Learn how to generate an ERD from your database or how to create ERD from scratch. ER Diagram tool for macOS ER diagram tool you can install and use on macOS. Explore the key features and benefits of Luna Modeler - a database design tool. How to Choose the Right noSQL Data Modeling Tool for Your Project: Tips and Tricks Picking the right noSQL data modeling tool for noSQL databases can greatly influence the success of your project. Learn some tips and tricks. Database Modeling for SQL Server Learn how database modeling for SQL Server database can help you manage data more effectively. Try Luna Modeler - a database modeling tool. Benefits of Data Modeling for Multiple Database Systems Learn the benefits of using multiple database systems for an e-commerce project and designing the structure in a data modeling tool. How to Create an ER diagram for MongoDB Learn how to easily create an ER diagram for MongoDB in Moon Modeler - a database modeling and schema design tool. Top 5 Benefits of Database Modeling Tools Learn the top 5 benefits of database modeling tools and find out how Luna Modeler can increase your productivity and save you money. What is Entity Relationship Diagram (ERD)? Entity relationship diagram describes the database structure. Basic elements are entities, attributes and relationships. Read more. Crow's foot notation in ER diagram Use crow's foot notation to represent relationships between entities in an entity-relational diagram. Draw ER diagrams in Luna Modeler. Cosmos DB & MongoDB API Data modeling for Cosmos DB - Learn how to connect to Cosmos DB / MongoDB and how to create diagrams easily. ER Diagram Samples A list of ER diagram samples made with Luna Modeler - data modeling tool for anyone who needs to create effective ER diagrams. Database Design Tool for macOS Users Database design tool for macOS users. Read how to install Luna Modeler on macOS and explore the key features and benefits. Relationships in ER Diagrams Learn how creating relationships in ER diagrams is essential for maintaining data integrity and improving data retrieval efficiency. Database Design Tool for Linux - Ubuntu Try Luna Modeler - a database design tool for Linux. Read how to install Luna Modeler on Ubuntu and explore the key features and benefits. How to Connect to MongoDB Atlas? See how to create MongoDB Atlas connection, connect to MongoDB Atlas and create data model or ER diagram from your existing MongoDB database. MongoDB vs PostgreSQL Read about MongoDB vs PostgreSQL. Review differences in Luna Modeler and Moon Modeler - data modeling tools for various database platforms. How to Convert a Database Schema Learn how to convert a database schema from one database to another. Find out how to run the conversion successfully in Luna Modeler. What is a Database Entity Learn what database entity is and how to design database entities with attributes and relationships in modeling tools. How to Create a Database Diagram? Learn how to easily create a database diagram using modeling tools. Explore benefits of database diagrams and find out best practices. How to set Schema Validation Rules for Fields in a Project for MongoDB Read how to set schema validation for fields in a project for MongoDB in Moon Modeler - a schema design tool for MongoDB and Mongoose. What is Database Normalization? Database normalization provides several benefits, including improved data integrity, better data consistency, reduced redundancy and more. Primary Key vs Foreign Key What's the difference between primary keys and foreign keys? Learn how to define a primary key, a foreign key, and how to visualize JSON. AWS Amazon DocumentDB Data modeling for Amazon DocumentDB - Learn how to connect to DocumentDB / MongoDB and how to create diagrams easily. Blog Categories Browse all blog categories on Datensen.com — data modeling, ER diagrams, NoSQL, Docker, PostgreSQL, SQL Server, SQLite and more. Data Modeling Blog Data modeling blog by Datensen.com — articles on ER diagrams, database design, NoSQL modeling, SQL tips and product tutorials for Luna, Moon and Galaxy Modeler. Tag list Browse all blog tags on Datensen.com — topics include MongoDB, PostgreSQL, Oracle, ER diagrams, GraphQL, Sequelize, schema design and more.