Overview The Database node represents a structured collection of records with custom field definitions. It functions similar to a spreadsheet or table, with configurable columns (fields) and rows (records).
Attributes Schema z . object ({ type: z . literal ( 'database' ), name: z . string (), avatar: z . string (). nullable (). optional (), parentId: z . string (), fields: z . record ( z . string (), fieldAttributesSchema ), nameField: z . object ({ name: z . string (). nullable (). optional (), }). nullable (). optional (), index: z . string (). nullable (). optional (), })
Optional avatar URL or emoji for the database
ID of the parent node (typically a space or folder)
fields
Record<string, FieldAttributes>
required
Map of field IDs to field definitions. Each field defines a column in the database.
boolean: Checkbox/boolean valuestext: Multi-line textnumber: Numeric valuesemail: Email addressesphone: Phone numbersurl: URLsdate: Date valuesselect: Single-select dropdown with optionsmulti_select: Multi-select dropdown with optionsfile: File attachmentscollaborator: User referencesrelation: References to records in another databaserollup: Aggregated values from related recordscreated_at: Auto-populated creation timestampcreated_by: Auto-populated creatorupdated_at: Auto-populated update timestampupdated_by: Auto-populated last editor Configuration for the special “Name” field that identifies records { name : z . string (). nullable (). optional () }
Fractional index for ordering databases among siblings
Field Attributes Schema Each field in the fields map must conform to one of the following schemas:
z . discriminatedUnion ( 'type' , [ // Boolean field z . object ({ id: z . string (), type: z . literal ( 'boolean' ), name: z . string (), index: z . string (), }), // Text field z . object ({ id: z . string (), type: z . literal ( 'text' ), name: z . string (), index: z . string (), }), // Number field z . object ({ id: z . string (), type: z . literal ( 'number' ), name: z . string (), index: z . string (), }), // Select field (with options) z . object ({ id: z . string (), type: z . literal ( 'select' ), name: z . string (), index: z . string (), options: z . record ( z . string (), z . object ({ id: z . string (), name: z . string (), color: z . string (), index: z . string (), })). optional (), }), // ... and other field types ])
Source: /home/daytona/workspace/source/packages/core/src/registry/nodes/field.ts:186-204Permissions canCreate Rules:
Tree must not be empty (cannot create at root)
User must have at least 'member' role in the parent
Source: /home/daytona/workspace/source/packages/core/src/registry/nodes/database.ts:31-46canUpdateAttributes Rules:
Tree must not be empty
User must have at least 'member' role
Source: /home/daytona/workspace/source/packages/core/src/registry/nodes/database.ts:47-62canUpdateDocument Rules:
Always returns false (databases do not have documents)
canDelete Rules:
Tree must not be empty
User must have at least 'member' role
Source: /home/daytona/workspace/source/packages/core/src/registry/nodes/database.ts:66-81canReact Rules:
Always returns false (databases cannot be reacted to)
Document Schema Databases do not support documents.
{ name : attributes . name , attributes : null }
Only the database name is extracted for search/indexing.
Mentions Databases do not support mentions. Always returns [].