May 27, 2026 database design 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. May 26, 2026 database design 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. April 24, 2026 database design 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. April 24, 2026 database design PostgreSQL Check Constraints Find out how to implement check constraints in PostgreSQL to ensure data quality and enhance your database design. April 24, 2026 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. April 24, 2026 database design PostGIS Core Support Unlock powerful mapping features with PostGIS Core Support in Luna Modeler and enhance your diagrams with specific data types. April 24, 2026 database design Visualization of existing SQL Server databases Connect to your SQL Server and reverse engineer your existing database structures. Visualize databases and create ER diagrams. April 2, 2026 database design 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! March 31, 2026 database design 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! March 31, 2026 database design Luna Modeler vs SAP PowerDesigner: Modern, Cross-Platform Alternative Replacing SAP PowerDesigner? Luna Modeler provides modern data modeling for PostgreSQL, MySQL & Oracle — at a fraction of the cost. Free trial. March 31, 2026 database design A Fresh Alternative to Vertabelo - Discover Luna Modeler Prefer working offline? Luna Modeler is a desktop Vertabelo alternative — no subscription, no cloud dependency, full control of your data. March 31, 2026 database design Looking for an erwin Data Modeler Alternative? Discover Luna Modeler Looking for a lightweight alternative to erwin Data Modeler? Luna Modeler is a modern, cross-platform database design tool. March 31, 2026 database design Looking for an alternative to ER/Studio? Try Luna Modeler Looking for an affordable alternative to ER/Studio? Discover Luna Modeler for intuitive data modeling for Oracle, SQL Server, PostgreSQL. March 2, 2026 database design Free Flowchart & Data Flow Diagram Tool? Simplify your workflow with Merit Modeler, the user-friendly desktop tool for free data flow diagrams and flowcharts. March 2, 2026 database design 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. March 2, 2026 database design Oracle Database Design Luna Modeler for Oracle database design. See how to visually create ER diagrams for Oracle Database and generate SQL Scripts. March 2, 2026 database design 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. March 2, 2026 database design Other objects in Oracle Database Learn how to define other objects like functions, triggers, synonyms, types and other Oracle-specific objects in Luna Modeler. March 2, 2026 database design 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. March 2, 2026 database design 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. March 2, 2026 database design Database Schema Assignment Explore the features of Schema Assignment in Luna Modeler. Assign, remove, or replace schemas effortlessly for your objects. February 20, 2026 database design 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. January 27, 2026 database design 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. January 26, 2026 database design Custom Templates & Scripts All Datensen products support custom templates for generating SQL scripts, HTML, CSV and JavaScript outputs. Learn how to create snippets etc. December 17, 2025 database design 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. October 14, 2025 database design Subject Areas in Moon Modeler Explore subject areas in Moon Modeler to enhance your data modeling with advanced features and visualizations. October 14, 2025 database design Auto Layout in Moon Modeler Learn how the auto-layout function in Moon Modeler automatically arranges MongoDB diagram items for better readability and structure. October 14, 2025 database design 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. October 2, 2025 database design 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. October 2, 2025 database design Forward engineering & SQL scripts Generate SQL CREATE scripts from your ER diagram in Luna Modeler. Supports PostgreSQL, MySQL, Oracle, SQL Server, MariaDB & SQLite. October 2, 2025 database design 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. October 2, 2025 database design 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. October 2, 2025 database design Projects & Data models Create and manage data modeling projects in Luna Modeler. Start from scratch, reverse-engineer a database or import an existing schema. October 2, 2025 database design Projects & Data models Create a new database design or schema design from scratch, by reverse engineering existing databases or by importing metadata from files. October 2, 2025 database design 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. September 26, 2025 database design Reverse engineering Connect to PostgreSQL, MySQL, Oracle or SQL Server and automatically generate ER diagrams from your live database. Luna Modeler — free trial. September 25, 2025 database design Subject Areas in data models Use subject areas in Luna Modeler to group related tables and organise complex ER diagrams into logical sections. September 25, 2025 database design 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. September 25, 2025 database design 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. September 25, 2025 database design Version Control & Explorer Track and manage different versions of your ER diagrams directly in Luna Modeler using the built-in Version Control Explorer. September 25, 2025 database design 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. September 24, 2025 database design Dependencies in Data Models Discover how to create and manage dependencies in data models with Luna Modeler for comprehensive data visualization. September 8, 2025 database design 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! September 8, 2025 database design 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. September 8, 2025 database design 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. September 8, 2025 database design How to Compare SQL Database Schemas Discover how to effectively compare SQL database schemas using Luna Modeler. Our guide offers step-by-step instructions. September 3, 2025 database design 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. September 3, 2025 database design 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. September 3, 2025 database design 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. August 13, 2025 database design Visualization of existing PostgreSQL databases Connect to a PostgreSQL database and reverse engineer your existing database structures. Visualize databases and create ER diagrams. August 12, 2025 database design 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. August 6, 2025 database design Hierarchy Modeling in NoSQL Databases Explained Learn the essentials of hierarchy modeling for NoSQL databases and enhance your data structures effectively. July 16, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design Mongoose schema design Mongoose schema design in Moon Modeler - draw diagrams for Mongoose ODM and generate Mongoose schema creation scripts or generate reports. June 18, 2025 database design PostgreSQL database design Luna Modeler for PostgreSQL database design. See how to visually create ER diagrams for PostgreSQL and generate SQL Scripts June 18, 2025 database design PostgreSQL ER diagram - graphics Use Luna Modeler and visualize PostgreSQL tables, composite types and other objects in a PostgreSQL ER diagram. June 18, 2025 database design Enumerated type - Enum - PostgreSQL How to define enumerated types (enum) for PostgreSQL in Luna Modeler - ER diagram tool for PostgreSQL and other databases. June 18, 2025 database design Domains in PostgreSQL projects Read how to specify PostgreSQL domains in Luna Modeler, a database modeling tool for PostgreSQL and other databases. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design 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 June 18, 2025 database design MariaDB indexes How to create indexes in Luna Modeler - data modeling tool for MariaDB, PostgreSQL, SQL Server and other relational databases. June 18, 2025 database design MySQL database design Luna Modeler - a data modeling tool for MySQL database design. Learn how to draw ER diagrams and generate SQL scripts easily. June 18, 2025 database design Visualization of existing MariaDB databases Connect to a MariaDB database and reverse engineer your existing database structures. Visualize databases and create ER diagrams. June 18, 2025 database design 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. June 18, 2025 database design 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 June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design 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 June 18, 2025 database design 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. June 18, 2025 database design Visualization of existing MySQL databases Connect to MySQL and reverse engineer existing database structures. Visualize databases and create ER diagrams. June 18, 2025 database design SQLite database design Luna Modeler - a tool for SQLite database design. See how to visually create database design for SQLite and generate SQL script. June 18, 2025 database design 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. June 18, 2025 database design Default values How to define default values for new objects in Moon Modeler - database modeling and reporting tool for various platforms. June 18, 2025 database design 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 June 18, 2025 database design 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. June 18, 2025 database design MongoDB ER diagram & Graphics ER Diagram tool for visualization of MongoDB database structures. See collections, fields, documents and references in MongoDB ER diagrams. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design MongoDB schema design MongoDB schema design in Moon Modeler, a tool for creation, visualization and code generation for MongoDB schema designs. June 18, 2025 database design 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. June 18, 2025 database design Updating SQLite projects Read how update your existing SQLite entity relationship diagram created in Luna Modeler - a database modeling tool for relational databases. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design Using Enum in Mongoose Learn how to define Mongoose Enum in a project created with Moon Modeler - data modeling tool for MongoDB and Mongoose. June 18, 2025 database design Enum in MongoDB Learn how to define Enum in a MongoDB project created with Moon Modeler - data modeling tool for MongoDB and Mongoose. June 18, 2025 database design Validation in MongoDB Learn how to set validation criteria for MongoDB project created with Moon Modeler - data modeling tool for MongoDB and Mongoose. June 18, 2025 database design PostgreSQL Indexes How to create PostgreSQL indexes in Luna Modeler - data modeling tool for PostgreSQL and other relational and databases. June 18, 2025 database design 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 June 18, 2025 database design Composite types & PostgreSQL ER Diagram Learn how to define composite types for PostgreSQL in Luna Modeler - ER diagram tool for PostgreSQL and other databases. June 18, 2025 database design Other database objects in PostgreSQL Learn how to define other database objects like functions, triggers, views and other PostgreSQL-specific objects in Luna Modeler. June 18, 2025 database design Datatype aliases How to define data type aliases for your projects in Luna Modeler. Add new data types as needed and generate SQL scripts. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design Visualization of existing Oracle Databases Connect to your Oracle Database, visualize the database structure and create ER diagrams automatically in Luna Modeler. June 18, 2025 database design 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. June 18, 2025 database design Indexes in Oracle Database How to create indexes in Luna Modeler - a data modeling tool for Oracle Database and other relational databases. June 18, 2025 database design 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 June 18, 2025 database design 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. June 18, 2025 database design 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. June 18, 2025 database design Oracle Synonyms How to define synonyms in projects for Oracle Database. Learn how to define and visualize synonyms in ER diagrams in Luna Modeler. June 18, 2025 database design 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. March 26, 2025 database design 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. March 26, 2025 database design 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 March 26, 2025 database design AdventureWorks Sample Database Learn how to visualize the AdventureWorks sample database and how to easily create an ER diagram with Luna Modeler. March 26, 2025 database design 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. March 26, 2025 database design 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. March 25, 2025 database design 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. March 25, 2025 database design 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. March 24, 2025 database design 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. March 22, 2025 database design What is Entity Relationship Diagram (ERD)? Entity relationship diagram describes the database structure. Basic elements are entities, attributes and relationships. Read more. February 24, 2025 database design 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. February 21, 2025 database design 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. August 8, 2023 database design 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. July 15, 2023 database design What is a Database Entity Learn what database entity is and how to design database entities with attributes and relationships in modeling tools. July 13, 2023 database design 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.