​
Database Dashboard Overview

The Database Dashboard in CodeNull provides a comprehensive set of tools to create, manage, and optimize your application’s database without writing complex queries or database code. This intuitive interface allows you to visually design database schemas, import and manage data, and configure database relationships.

​
What You Can Do

Create Databases

Set up MongoDB, SQL, or custom databases with just a few clicks

Add Data

Import, create, and manage your database records efficiently

Design Schemas

Visually design your data models and their relationships

Migrate Data

Import from external sources and migrate between environments

​
Dashboard Interface

The Database Dashboard interface is organized into several key areas:
Database Dashboard Overview
The left sidebar provides access to your database resources:
  • Database List: All your connected databases
  • Collections/Tables: Lists of your data collections
  • Saved Queries: Frequently used database queries

​
Workspace Area

The central area changes based on your current task:
  • Schema Designer: Visual schema creation interface
  • Data Explorer: Browse and edit your data records
  • Query Builder: Create and run database queries
  • Import/Export Tools: Data migration utilities

​
Properties Panel

The right sidebar displays properties for the selected item:
  • Field Settings: Data type, validation rules, default values
  • Relationship Properties: Defines how tables or collections relate
  • Index Configuration: Performance optimization options
  • Query Parameters: Settings for saved queries

​
Supported Database Types

CodeNull supports multiple database types to meet your application needs:
Document-based NoSQL database ideal for flexible data structures and rapid development.Key features:
  • Schema-less data storage
  • JSON-like document structure
  • Horizontal scaling
  • Geo-spatial support

​
Database Dashboard Workflow

The typical workflow for using the Database Dashboard includes:
1

Create a Database

Set up your database and configure connection settings.
2

Design Your Schema

Define your data models, fields, and relationships.
3

Add Initial Data

Import or manually add records to your database.
4

Configure Optimization

Set up indexes and query optimization for performance.
5

Connect to Frontend

Link your database collections to frontend components.

​
Next Steps

Creating Your First Database

Learn how to set up and configure a new database

Adding Data

Import or create records in your database

Designing Database Schemas

Visually design your data models and relationships

Migrating Existing Data

Import from external sources and migrate between environments