Visual Modeling

Visual Modeling is the core feature of Qubase. It enables you to design database schemas using an interactive ERD Canvas while keeping your visual diagram synchronized with SQL or DBML code.

Whether you are planning a new system or improving an existing database, Visual Modeling provides the tools to create, organize, and maintain database structures efficiently.

What is Visual Modeling?

Visual Modeling allows you to build database structures by working directly on the ERD Canvas instead of writing SQL manually.

With drag-and-drop interactions and real-time synchronization, you can focus on designing your database while Qubase manages the underlying structure.

Features included

Visual Modeling includes the following capabilities:

• Multiple database model types
• Interactive ERD Canvas
• Table and entity creation
• Columns and constraints
• Relationship management
• Cardinality configuration
• Canvas editing tools
• Mini Map navigation
• Real-time SQL and DBML synchronization

Supported model types

Before creating a database schema, choose the model type that matches your design stage.

Typical workflow

Most users follow this workflow when designing a database.

Choose Model Type
        ↓
Create Database Schema
        ↓
Open ERD Canvas
        ↓
Create Tables
        ↓
Add Columns
        ↓
Define Primary Keys
        ↓
Create Relationships
        ↓
Validate Design
        ↓
Generate SQL or DBML

Why use Visual Modeling?

Visual Modeling helps you:

• Design databases faster
• Reduce design errors
• Improve collaboration
• Keep diagrams and code synchronized
• Understand complex database structures more easily

[!TIP] Start with a simple database structure before adding advanced relationships and constraints.

Best practices

• Choose the correct model type before starting.
• Use meaningful table and column names.
• Create primary keys before defining relationships.
• Organize tables to improve readability.
• Validate your schema regularly.

Next steps

Continue with the following guides:

• Database Model Types
• ERD Canvas
• Create Tables
• Relationships