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. 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. 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. Oracle Database Design Luna Modeler for Oracle database design. See how to visually create ER diagrams for Oracle Database and generate SQL Scripts. 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 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. 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. 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. 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. 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. 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 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. 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. 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. 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 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.
