OmadaDocumentation

Working with Databases

Create, configure, and organize databases to match your team's data needs.

Creating a Database

  1. Open the actions menu (the vertical ellipsis in the schema tree header) and select New Database, or
  2. Right-click in the schema tree and select Add Schema, or
  3. Click Create Database in the empty state panel

In the Create Database modal:

FieldDescription
NameDisplay name for your database (e.g., "Printers")
Prefix2-6 uppercase letters used in entry IDs (e.g., "PRNT" creates IDs like PRNT-001)
DescriptionOptional description of what this database stores
IconVisual icon displayed in the schema tree
FieldsDefine the columns/fields for your entries

Nested Databases

Create hierarchical database structures by nesting databases under parents:

  1. Right-click on a parent database in the schema tree
  2. Select Create Nested Schema
  3. Configure the new database

Nested databases can optionally inherit fields from their parent (see Field Inheritance section).

Editing a Database

  1. Right-click the database in the schema tree and select Edit Schema
  2. Modify settings, add/remove fields, or reorder fields
  3. Save your changes

Building Databases with AI

The Schema Builder lets you design one or more databases by describing them in plain language.

  1. Open the actions menu (the vertical ellipsis in the schema tree header) and select Schema Builder
  2. Describe the schemas you want in the chat panel — the AI proposes a structured model that streams into a live entity-relationship (ERD) diagram on the right
  3. Refine the proposal through further chat until the diagram matches what you need
  4. Click Review & Apply to review the proposed changes, then confirm to create or update the real databases

Archiving and Deleting

  • Archive - Soft-delete that hides the database but preserves data
  • Delete - Permanently removes the database and all entries

Access these options via right-click context menu on any database.