bkend-data

name	bkend-data
classification	capability
classification-reason	Pattern guidance may overlap with model's built-in knowledge as it improves
deprecation-risk	medium
effort	medium
description	bkend.ai database — CRUD, column types, filtering, sorting, relations, indexing. Triggers: bkend table, bkend CRUD, bkend column, bkend relation, bkend data
user-invocable	false
agent	bkit:bkend-expert
allowed-tools	["Read","Write","Edit","Glob","Grep","Bash","mcp__bkend__*"]
imports	["${PLUGIN_ROOT}/templates/shared/bkend-patterns.md"]

bkend.ai Database Guide

Column Types (7)

Type	Description	Example
String	Text	name, email
Number	Numeric	age, price
Boolean	True/false	isActive
Date	Date/time	birthDate
Array	Array	tags: ["a","b"]
Object	Nested object	address: {city, zip}
Mixed	Any type	metadata

Constraints

• required: Field must have a value
• unique: No duplicate values allowed
• default: Default value when not provided

Auto System Fields

Field	Type	Description
id	String	Auto-generated unique ID
createdBy	String	Creator user ID
createdAt	Date	Creation timestamp
updatedAt	Date	Last update timestamp

Important: bkend uses id (NOT _id) in all API responses.

MCP Table Management Tools

Tool	Purpose	Scope
backend_table_create	Create table	table:create
backend_table_list	List tables	table:read
backend_table_get	Get table detail + schema	table:read
backend_table_delete	Delete table	table:delete
backend_field_manage	Add/modify/delete fields