Skip to main content

Database Editor

Create and manage data tables and records for your application.

Overview​

Database Editor provides a visual interface for working with your application's data. Create tables, define schemas, and manage records without writing SQL queries.

Concepts​

Datatable​

A structured data collection with defined fields and types. Similar to a database table, datatables store records with consistent schemas.

Schema​

The structure definition for a table, including field names, types, and constraints.

Record​

A single row of data in a table. Records contain values for each field defined in the schema.

View Tables​

  1. Navigate to your App in the Dashboard.
  2. Click Database in the sidebar.
  3. View all tables with:
    • Table Name: Display name
    • Records: Number of rows
    • Fields: Number of columns
    • Created: When the table was created

Create a Table​

  1. Navigate to Database in your app.
  2. Click Create Table.
  3. Fill in the table details:
    • Name: Descriptive table name
    • Slug: URL identifier (auto-generated)
    • Description: Purpose of the table
  4. Define fields:
    • Click Add Field
    • Enter field name
    • Select field type
    • Configure constraints (required, unique, etc.)
  5. Click Create.

Field Types​

TypeDescriptionExample
StringText data"John Doe"
NumberNumeric data42, 3.14
BooleanTrue/Falsetrue
DateDate and time"2025-01-13"
JSONStructured data{"key": "value"}
ReferenceLink to another tableforeign key
FileFile attachmentuploaded file
ArrayList of values["a", "b", "c"]

View Table Data​

  1. Click on a table in the list.
  2. View records in the DataGrid:
    • Columns: Table fields
    • Rows: Individual records
    • Sorting: Click column headers
    • Filtering: Use filter options

Search Records​

  1. Use the search bar above the grid.
  2. Enter search terms.
  3. Results filter automatically.

Add a Record​

  1. Navigate to a table.
  2. Click Add Record.
  3. Fill in field values.
  4. Click Save.

Inline Editing​

  1. Click on a cell in the DataGrid.
  2. Edit the value directly.
  3. Press Enter or click outside to save.

Edit a Record​

  1. Click on a record row.
  2. Click Edit or double-click the row.
  3. Modify field values in the dialog.
  4. Click Save.

Delete Records​

Single Record​

  1. Click the Delete (trash) icon on a row.
  2. Confirm deletion.

Bulk Delete​

  1. Select multiple records using checkboxes.
  2. Click Delete Selected.
  3. Confirm deletion.
warning

Deleted records cannot be recovered. Ensure you have backups before bulk deletions.

Edit Table Schema​

  1. Navigate to Database in your app.
  2. Click the Edit Schema icon on the table.
  3. Modify the schema:
    • Add new fields
    • Edit field types
    • Remove fields
  4. Click Save Schema.
warning

Changing field types or removing fields may cause data loss. Review changes carefully.

View Schema​

View the schema in different formats:

Grid View​

  1. Click Schema tab in the table view.
  2. See fields in a table format:
    • Field name
    • Type
    • Constraints

JSON View​

  1. Click JSON tab.
  2. View the raw schema definition.
  3. Copy for use in migrations or documentation.

Import Data​

Import from CSV​

  1. Navigate to a table.
  2. Click Import.
  3. Select CSV format.
  4. Choose your CSV file.
  5. Map columns to fields.
  6. Click Import.

Import from JSON​

  1. Navigate to a table.
  2. Click Import.
  3. Select JSON format.
  4. Choose your JSON file.
  5. Review field mappings.
  6. Click Import.

Export Data​

  1. Navigate to a table.
  2. Click Export.
  3. Select format (CSV or JSON).
  4. Download the file.

Table References​

Create relationships between tables:

  1. Add a Reference field to your table.
  2. Select the target table.
  3. Choose the reference type:
    • One-to-One: Single related record
    • One-to-Many: Multiple related records
  4. Save the schema.

Configuration​

Table Fields​

FieldDescriptionRequired
NameDisplay nameYes
SlugUnique identifierAuto-generated
DescriptionPurpose of tableNo

Field Constraints​

ConstraintDescription
RequiredField cannot be empty
UniqueValues must be unique
DefaultDefault value for new records
Min/MaxValue range limits

Limits​

ResourceLimit
Tables per app50
Fields per table100
Records per table100,000
Field name length64 characters
info

Need higher limits? Contact support to discuss your requirements.

Troubleshooting​

Import fails​

Problem: Data import fails with errors.

Solution:

  1. Check the file format matches (CSV/JSON).
  2. Verify column headers match field names.
  3. Ensure data types are correct.
  4. Review the error report for specific issues.

Cannot delete table​

Problem: Table deletion is blocked.

Solution:

  1. Check for references from other tables.
  2. Remove or update referencing fields first.
  3. Then delete the table.

Schema changes lost​

Problem: Schema modifications aren't saved.

Solution:

  1. Ensure you click Save Schema after changes.
  2. Check for validation errors.
  3. Refresh and try again.

Last Updated: January 2025