TablesWriteDo not retry automatically

Create a relation between tables

create_table_relation

Link two tables. Creates the relation field here and, when `reciprocal` is given, the reverse field on the target — one operation, because a half-created relation is a column pointing at nothing. Once it exists, link rows with link_table_rows and summarise across it with a Lookup / Rollup / Count field (add_table_field).

Parameters

Parameter	Type	Required	Description
`tableId`	string	required	Table the relation is added to
`targetTableId`	string	required	Table it points at — the same table for a self-relation
`label`	string	required	Field name on this table
`cardinality`	"one" \| "many"	optional	one = a row links to at most one target row; many = several
`reciprocal`	object	optional	Create the reverse field on the target table too. Omit for a one-way relation.
`previewFieldIds`	string[]	optional	Target field ids shown beside the primary value on a chip
`description`	string	optional	Input for description.
`icon`	string	optional	Input for icon.
`expectedSchemaVersion`	integer	optional	Assert the table schema version you last read. Omit to let the call read it — the write still fails if someone changes the schema in between.

Example call

The tool call an MCP client sends (required arguments shown with placeholder values).

{
  "tool": "create_table_relation",
  "arguments": {
    "tableId": "tableId_123",
    "targetTableId": "targetTableId_123",
    "label": "value"
  }
}

Use this tool in

Claude Code Claude Desktop Claude Cowork ChatGPT Cursor Windsurf VS Code Copilot OpenClaw Gemini Hermes Agent

Related Tables tools

List tableslist_tablesList the tables in the workspace (id, name, kind — typed or custom — resource type, fields, row count, schema/revision versions).Get tableget_tableGet one table by id: its full field set (key, label, kind, display format, select options, whether the field is feed-owned and whether it can be written), the fields that form row identity, the promoted primary/date/amount bindings, row count, and its schema badge.Create tablecreate_tableCreate a table in the workspace.Update tableupdate_tableUpdate a table’s METADATA — name, icon, retention policy.

← All tools