Tables
Creating and managing database tables and their schemaless JSON records.
A table is a named container of records inside your EzFlow workspace. Tables belong to your tenant and are not shared across workspaces.
Table structure
The table itself
Each table has:
| Field | Description |
|---|---|
name | A unique name within your tenant. Database nodes reference tables by this name. |
tenantId | The workspace the table belongs to (set automatically). |
createdAt | When the table was created. |
deletedAt | Set when the table is soft-deleted from the UI. Soft-deleted tables are hidden but their data is retained until permanently removed. |
Records
Each table holds zero or more records. A record is a free-form JSON object stored in the data field. There is no predefined column schema — the keys of the data JSON become the effective columns.
Example record:
{
"email": "alice@example.com",
"firstName": "Alice",
"signedUpAt": "2025-03-01T09:00:00Z",
"plan": "pro"
}A different record in the same table could have different keys. EzFlow infers the column list by scanning existing records — specifically, it collects the distinct keys found across up to 200 records.
Record fields
| Field | Description |
|---|---|
id | Unique record identifier (CUID). Used by UPDATE and REMOVE database nodes. |
data | The JSON object containing the record's key-value pairs. |
tableId | Reference to the parent table. |
tenantId | Reference to the workspace. |
createdAt | When the record was inserted. |
updatedAt | When the record was last modified. |
Managing tables in the UI
Go to Databases (/databases) to manage your tables.
Create a table
Click New table and enter a name (up to 100 characters). The table is created immediately with no records.
Rename a table
Open the table and use the rename option. Note that database nodes reference tables by name — if you rename a table, update any Workflows that reference it.
Add records manually
Open a table and click Add record to insert a row. Enter key-value pairs in the JSON editor. The record appears in the table immediately.
Delete records
Select one or more records and choose Delete. Record deletion is permanent (hard delete) — there is no soft-delete for records.
Delete a table
Use the Delete table option from the table menu. This soft-deletes the table. Soft-deleted tables are hidden from the UI and from Workflow database nodes.
Searching and filtering records
When viewing a table in the UI you can filter records by matching key-value pairs. The same filter logic is used by the SEARCH_DATABASE_RECORD node in Workflows: filters are matched against the JSONB data field with exact equality on each specified key.