> ## Documentation Index
> Fetch the complete documentation index at: https://shivamgoyal.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Dashboard Overview

> Introduction to the CodeNull Database Dashboard and its capabilities

# 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

<CardGroup cols={2}>
  <Card title="Create Databases" icon="plus-circle" href="/database-dashboard/create-db">
    Set up MongoDB, SQL, or custom databases with just a few clicks
  </Card>

  <Card title="Add Data" icon="table" href="/database-dashboard/add-data">
    Import, create, and manage your database records efficiently
  </Card>

  <Card title="Design Schemas" icon="sitemap" href="/database-dashboard/schema-design">
    Visually design your data models and their relationships
  </Card>

  <Card title="Migrate Data" icon="exchange-alt" href="/database-dashboard/data-migration">
    Import from external sources and migrate between environments
  </Card>
</CardGroup>

## Dashboard Interface

The Database Dashboard interface is organized into several key areas:

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/shivamgoyal/images/database-dashboard-overview.png" alt="Database Dashboard Overview" />
</Frame>

### Main Navigation Panel

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:

<Tabs>
  <Tab title="MongoDB">
    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
  </Tab>

  <Tab title="PostgreSQL">
    Advanced open-source relational database with robust features for complex data.

    **Key features:**

    * ACID compliance
    * Complex queries
    * Multi-version concurrency control
    * Advanced data types
  </Tab>

  <Tab title="MySQL">
    Popular relational database system known for reliability and ease of use.

    **Key features:**

    * Solid data integrity
    * Transaction support
    * Comprehensive SQL support
    * Widespread community support
  </Tab>

  <Tab title="Excel/CSV Import">
    Import existing spreadsheet data into your application database.

    **Key features:**

    * Direct import from spreadsheets
    * Automatic schema detection
    * Data type conversion
    * Bulk record creation
  </Tab>
</Tabs>

## Database Dashboard Workflow

The typical workflow for using the Database Dashboard includes:

<Steps>
  <Step title="Create a Database">
    Set up your database and configure connection settings.
  </Step>

  <Step title="Design Your Schema">
    Define your data models, fields, and relationships.
  </Step>

  <Step title="Add Initial Data">
    Import or manually add records to your database.
  </Step>

  <Step title="Configure Optimization">
    Set up indexes and query optimization for performance.
  </Step>

  <Step title="Connect to Frontend">
    Link your database collections to frontend components.
  </Step>
</Steps>

## Next Steps

<CardGroup cols={4}>
  <Card title="Creating Your First Database" icon="database" href="/database-dashboard/create-db">
    Learn how to set up and configure a new database
  </Card>

  <Card title="Adding Data" icon="table" href="/database-dashboard/add-data">
    Import or create records in your database
  </Card>

  <Card title="Designing Database Schemas" icon="sitemap" href="/database-dashboard/schema-design">
    Visually design your data models and relationships
  </Card>

  <Card title="Migrating Existing Data" icon="exchange-alt" href="/database-dashboard/data-migration">
    Import from external sources and migrate between environments
  </Card>
</CardGroup>