Data Modeling Blog

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.

Learn how to show collections in MongoDB using show collections, db.getCollectionNames() or db.getCollectionInfos() — plus a visual approach with Moon Modeler.

Explore the top 5 data modeling software options that empower software development, database design, analytics, and business processes.

Learn how to seamlessly connect to Supabase and visualize your database using Luna Modeler. Simplify your data workflow with our easy guide!

Learn how to use Luna Modeler to automatically infer dependencies between views, stored procedures, and tables for better impact analysis.

The best visual database design tool for consultants. Supports Oracle, PostgreSQL, SQL Server, MySQL and more.

Explore the best tools for SQLite to generate and execute SQL scripts effortlessly. Create and manage your databases with ease!

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.

Learn about data models and their key types - conceptual, logical, and physical. Discover powerful tools for the easy creation of data models.

Find the best data flow diagram tools for easy modeling and exporting. Create effective diagrams with the right software.

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.

Discover the best FREE desktop flowchart diagram tools that run 100% offline - no SaaS, no cloud, no subscriptions.

All Datensen products support custom templates for generating SQL scripts, HTML, CSV and JavaScript outputs. Learn how to create snippets etc.

Discover how to build a professional flowchart diagram with Merit Modeler. Freeware, easy to use, and available for major operating systems

Discover how a data flow diagram can simplify your approach to software engineering and how to use the FREE Model Merit for drawing DFD

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.

Discover the importance of ER diagrams when documenting databases. This article describes various aspects of database documentation.

Discover how to generate delta scripts for database changes with our easy-to-follow guide. Enhance your database management skills today!

Discover how to effectively compare SQL database schemas using Luna Modeler. Our guide offers step-by-step instructions.

Luna Modeler - a SQL database creator that allows you to generate SQL scripts for many databases. Draw diagrams and create SQL scripts.

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 and MongoDB schema design. Draw diagrams, describe database structures and improve productivity with Moon Modeler.

Many to many relationships in entity relationship diagrams explained. Draw ER diagrams and design database structures easily.

One to many relationships explained. Draw entity relationship diagrams, define entities, attributes and relationships easily in Luna Modeler.

Learn how to set up Postgres in Docker Desktop, connect it to Luna Modeler for visual schema design, and manage your database using pgAdmin.

Learn how to set up MySQL in Docker Desktop, create a data model in Luna Modeler and run generated SQL scripts using VS Code.

Discover the easiest way on how to setup MongoDB with Docker Desktop and manage your data models visually with Moon Modeler.

Explore the data model sport tournaments with a structured PostgreSQL approach for managing teams and matches effectively.

Learn the essentials of hierarchy modeling for NoSQL databases and enhance your data structures effectively.

Learn how to connect to Amazon DocumentDB using Moon Modeler and create a diagram of your database effortlessly.

Database modeling is an essential step in the database design process. Read more information and tips for using database modelling tools.

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.

Learn how to list databases and show tables in PostgreSQL. Use a command-line tool or create an ER diagram in Luna Modeler.

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.

How to define default values for new objects in Moon Modeler - database modeling and reporting tool for various platforms.

Read how to export ER diagram to PDF easily. Visualize your database structure and export it to PDF for high-quality printing.

Learn how to connect to Heroku Postgres and how to create ER diagrams easily. Try Luna Modeler - database modeling tool.

Learn how to install Luna Modeler or Moon Modeler on Ubuntu 22. Install libfuse2, check permissions and run the downloaded AppImage file.

Learn how to configure a proxy server in Moon Modeler to activate your license and connect to MongoDB from behind a corporate firewall.

Learn how to configure a proxy server in Luna Modeler to activate your license and connect to databases from behind a corporate firewall.

Learn how to configure a proxy server in Galaxy Modeler to activate your license and connect to GraphQL endpoints from behind a corporate firewall.

Learn how to select the format of a graphical object and apply it to other selected objects in our data modeling tools.

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.

Learn how to manually repair older or corrupted Luna Modeler and Moon Modeler project files, and how to send diagnostic logs to Datensen support.

Troubleshoot license activation problems in Luna Modeler, Moon Modeler and Galaxy Modeler — steps for offline activation, proxy issues and common errors.

Our data modeling tools are customizable. Add your own custom properties and turn the tool into RAD - rapid application development tool.

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 explained. Draw entity relationship diagrams with entities, attributes, relationships and describe your databases.

Use visual tools to define OKRs, mindmaps and decision trees for your data modeling goals.

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.

Learn how to create a connection to an SQL Server Express database and how to create ERD from existing database structure using Luna Modeler

Learn how to visualize the AdventureWorks sample database and how to easily create an ER diagram with Luna Modeler.

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 you can install and use on macOS. Explore the key features and benefits of Luna Modeler - a database design tool.

Picking the right noSQL data modeling tool for noSQL databases can greatly influence the success of your project. Learn some tips and tricks.

Learn how database modeling for SQL Server database can help you manage data more effectively. Try Luna Modeler - a database modeling tool.

Learn the benefits of using multiple database systems for an e-commerce project and designing the structure in a data modeling tool.

Learn how to easily create an ER diagram for MongoDB in Moon Modeler - a database modeling and schema design tool.

Learn the top 5 benefits of database modeling tools and find out how Luna Modeler can increase your productivity and save you money.

Entity relationship diagram describes the database structure. Basic elements are entities, attributes and relationships. Read more.

Use crow's foot notation to represent relationships between entities in an entity-relational diagram. Draw ER diagrams in Luna Modeler.

Data modeling for Cosmos DB - Learn how to connect to Cosmos DB / MongoDB and how to create diagrams easily.

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. Read how to install Luna Modeler on macOS and explore the key features and benefits.

Learn how creating relationships in ER diagrams is essential for maintaining data integrity and improving data retrieval efficiency.

Try Luna Modeler - a database design tool for Linux. Read how to install Luna Modeler on Ubuntu and explore the key features and benefits.

See how to create MongoDB Atlas connection, connect to MongoDB Atlas and create data model or ER diagram from your existing MongoDB database.

Read about MongoDB vs PostgreSQL. Review differences in Luna Modeler and Moon Modeler - data modeling tools for various database platforms.

Learn how to convert a database schema from one database to another. Find out how to run the conversion successfully in Luna Modeler.

Learn what database entity is and how to design database entities with attributes and relationships in modeling tools.

Learn how to easily create a database diagram using modeling tools. Explore benefits of database diagrams and find out best practices.

Read how to set schema validation for fields in a project for MongoDB in Moon Modeler - a schema design tool for MongoDB and Mongoose.

Database normalization provides several benefits, including improved data integrity, better data consistency, reduced redundancy and more.

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.

Data modeling for Amazon DocumentDB - Learn how to connect to DocumentDB / MongoDB and how to create diagrams easily.

Browse all blog categories on Datensen.com — data modeling, ER diagrams, NoSQL, Docker, PostgreSQL, SQL Server, SQLite and more.

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.

Browse all blog tags on Datensen.com — topics include MongoDB, PostgreSQL, Oracle, ER diagrams, GraphQL, Sequelize, schema design and more.