OmadaDocumentation

Overview

Build custom data repositories with flexible schemas and powerful field types.

The Database app lets you create custom databases to track any type of structured data your team needs. From asset inventories and supplier lists to custom CRM records and project check lists, you can design schemas with the exact fields you need and organize entries with powerful filtering and sorting.

To access the Database app, navigate to Database in the sidebar or go to /apps/database in your workspace.

Understanding the Interface

The Database app uses a two-panel layout:

  • Left Panel - Schema tree showing all your databases organized hierarchically
  • Right Panel - Entries table for the selected database, or empty state when no database is selected

Schema Tree

The schema tree displays all your databases with:

ElementDescription
Database IconVisual indicator for each database (customizable)
Database NameThe display name of your database
Entry CountNumber of entries in each database (shown as badge)
Nested DatabasesChild databases appear indented under parents

You can collapse the sidebar using the panel toggle button to maximize table space. The actions menu (the vertical ellipsis in the schema tree header) contains New Database and Schema Builder.

AI Schema Builder

Open Schema Builder from the schema tree's actions menu to design databases with AI. The drawer pairs a chat panel with a live entity-relationship (ERD) diagram: describe the schemas you want, and the AI proposes a structured model that streams into the diagram. When you're happy with the proposal, click Review & Apply to create or update the real databases. See Working with Databases for details.

Entries Table

When you select a database, the right panel shows a data table with:

  • Column headers with sorting controls
  • Row selection checkboxes for bulk actions
  • Inline editing for supported field types
  • Entry ID links to detail view
  • Pagination controls

Next Steps