TablesRead-only

Check what a field retype would cost

preview_table_field_retype

Dry-run a field type change: how many values the column holds and how many of them cannot be read as the new kind (those are CLEARED by the retype, not converted). Read this before update_table_field changes a `kind` — the conversion is a data change, and "127 of 5,204 values will be cleared" is the sentence a user needs before approving it.

Parameters

Parameter	Type	Required	Description
`tableId`	string	required	Table ID
`fieldId`	string	required	Field ID — get from get_table
`kind`	"text" \| "long_text" \| "number" \| "checkbox" \| "date" \| "datetime" \| "single_select" \| "multi_select" \| "status" \| "url" \| "email" \| "phone" \| "rating" \| "user" \| "auto_number" \| "attachment" \| "json" \| "relation" \| "formula" \| "created_time" \| "last_edited_time" \| "created_by" \| "last_edited_by"	required	The kind it would become
`config`	object	optional	Configuration the new kind would carry (select options, rating maximum …)

Example call

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

{
  "tool": "preview_table_field_retype",
  "arguments": {
    "tableId": "tableId_123",
    "fieldId": "fieldId_123",
    "kind": 0
  }
}

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