Database

Database is a no-code visual editor for working with data.

Overview

The Database module provides:

• Create and manage database tables
• Visually design schemas (tables, columns, relationships)
• Edit data directly through the interface
• Import data from external sources

Database Management

Accessing Database

1. Select Database from the main menu
2. The Tables tab opens

Viewing Tables

The Tables tab displays all tables in the database:

• Table name: Name of the table
• Description: Brief description of the table's purpose
• Record count: Number of rows in the table
• Created date: When the table was created

Creating a Table

Option 1: Via Database page

1. Click New Table or +
2. Enter the table name
3. Add a description (optional)
4. Click Create

Option 2: Via Schema Editor

1. Open Schema Editor
2. Create the table visually (see Schema Editor section)

Editing a Table

1. Find the table in the list
2. Click the edit icon (pencil)
3. Change the name or description
4. Save changes

Deleting a Table

1. Find the table in the list
2. Click the delete icon (trash)
3. Confirm deletion

Importing Data

1. Click the Import button on the Database page
2. Select the data source:
   • CSV file
   • JSON file
   • SQL dump
3. Configure import parameters:
   • Target table (new or existing)
   • Column mapping
   • Duplicate handling
4. Click Import

Schema Editor

Schema Editor is a visual tool for designing database structure.

Accessing Schema Editor

1. Select Schema Editor from the Database menu
2. The visual editor opens with a canvas

Interface

Canvas:

• Central area for working with the schema
• Tables appear as nodes
• Relationships appear as lines between nodes

Toolbar:

• Tools for adding tables
• Display controls
• Export/import schema

Creating a Table

1. Click Add Table or + on the toolbar
2. Click on the canvas where you want to place the table
3. Enter the table name
4. The table appears on the canvas

Adding Columns

1. Select a table on the canvas
2. The table editor opens in the right panel
3. Click Add Column or +
4. Configure the column:
   • Name: Column name
   • Type: Data type (String, Number, Boolean, Date, etc.)
   • Constraints: Restrictions (NOT NULL, UNIQUE, PRIMARY KEY)
   • Default Value: Default value

Data types:

• String / Text: Text data
• Number / Integer: Numeric data
• Boolean: true/false
• Date / DateTime: Dates and times
• JSON: JSON objects
• UUID: Unique identifiers

Constraints:

• Primary Key: Unique row identifier
• Not Null: Field cannot be empty
• Unique: Value must be unique
• Foreign Key: Reference to another table

Creating Relationships

Relationship types:

• One-to-One (1:1): One record links to one record
• One-to-Many (1:N): One record links to many
• Many-to-Many (N:M): Many records link to many

How to create:

1. Select a column in the first table
2. Drag a connection to a column in the second table
3. Configure the relationship type
4. Specify delete actions (CASCADE, SET NULL, RESTRICT)

Canvas Navigation

• Zoom: Mouse wheel or +/- buttons
• Pan: Hold spacebar and drag
• Select: Click on a table
• Reset view: "Fit View" button to center

Exporting Schema

1. Click Export on the toolbar
2. Choose format:
   • SQL (CREATE TABLE statements)
   • JSON (schema definition)
   • GraphQL (types)
3. Copy or save the file

Data Editor

Data Editor allows viewing and editing table data directly.

Accessing Data Editor

1. Click on a table in the Database list
2. Data Editor opens for that table

Interface

Left panel:

• Table list for quick switching

Center area:

• Data grid view
• Columns match table fields
• Rows match records

Top panel:

• Action buttons (Add, Delete, Import)
• Search and filters
• Pagination

Viewing Data

• Scroll: Navigate through records
• Sort: Click column header to sort
• Resize columns: Drag the border between headers

Adding a Record

1. Click Add Row or +
2. Fill in the fields:
   • Required fields are marked with an asterisk (*)
   • For Foreign Key fields, select from the list
3. Click Save

Editing a Record

Option 1: Inline editing

1. Double-click on a cell
2. Change the value
3. Press Enter to save

Option 2: Edit form

1. Select the row
2. Click Edit or double-click the row
3. Modify data in the form
4. Click Save

Deleting a Record

1. Select the row(s)
2. Click Delete or press Delete key
3. Confirm deletion

Search and Filtering

Search:

1. Enter a query in the search field
2. Search runs across all text fields
3. Results display dynamically

Filtering:

1. Click the filter icon in the column header
2. Configure the filter condition:
   • Equals / Not equals
   • Contains / Does not contain
   • Greater than / Less than (for numbers and dates)
3. Apply the filter

Multiple filters can be applied simultaneously (combined with AND logic).

Best Practices

Schema Design

• Use Primary Keys: Every table should have a unique identifier
• Normalize data: Avoid duplication, use relationships
• Clear naming: Use descriptive names for tables and columns
• Correct types: Choose appropriate data types for columns

Data Management

• Backups: Export data regularly
• Validation: Use constraints to ensure integrity
• Batch operations: Use import for large volumes instead of manual entry
• Careful with CASCADE: Use CASCADE DELETE only when certain

Performance

• Pagination: Use pagination for large tables
• Filtering: Filter data instead of loading everything