Workflow
Access and behavior
Requires a current workspace role of Member or higher. The connection needsschema:manage scope.
- This tool changes data or starts work. Confirm the target and input before calling it.
- Keep the same
idempotencyKeywhen retrying an unchanged request; use a new key for different input. - Read the current table schema before supplying
expectedSchemaVersion. - A returned job is pending work. Use rootset_get_job to check its final result.
Arguments
| Argument | Required | Type | Details |
|---|---|---|---|
orgId | Yes | string | Workspace ID returned by rootset_get_context. |
databaseId | Yes | string | ID of the database to work with. |
tableId | Yes | string | ID of the table to work with. |
expectedSchemaVersion | Yes | integer | Current version returned by the table schema. |
fieldId | Yes | string | ID of the field to work with. |
field | Yes | object | — |
clearDefault | No | boolean | Remove the previous constant default. Do not also supply field.default. |
conversion | No | ”explicit” or “lossless” | — |
idempotencyKey | Yes | string | Stable caller-provided key across retries of this exact operation. |
Complete input schema
Complete input schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"type": "object",
"properties": {
"orgId": {
"type": "string",
"pattern": "^[0-7][0-9A-HJKMNP-TV-Z]{25}$"
},
"databaseId": {
"type": "string",
"pattern": "^[0-7][0-9A-HJKMNP-TV-Z]{25}$"
},
"tableId": {
"type": "string",
"pattern": "^[0-7][0-9A-HJKMNP-TV-Z]{25}$"
},
"expectedSchemaVersion": {
"type": "integer",
"minimum": 1,
"maximum": 2147483647
},
"fieldId": {
"type": "string",
"pattern": "^[0-7][0-9A-HJKMNP-TV-Z]{25}$"
},
"field": {
"anyOf": [
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "text"
},
"allowedValues": {
"anyOf": [
{
"minItems": 1,
"maxItems": 100,
"type": "array",
"items": {
"type": "string",
"minLength": 1,
"maxLength": 4096
},
"description": "1–100 distinct nonempty exact text choices; up to 4,096 Unicode characters per choice and 65,536 UTF-8 bytes for the whole list. Optional cells may be null; defaults must be listed.",
"uniqueItems": true,
"x-rootset-max-utf8-bytes": 65536
},
{
"type": "null"
}
]
},
"charLimit": {
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 65536
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "integer"
},
"autoIncrement": {
"description": "Generate increasing safe integers when a value is omitted on creation. Explicit IDs advance the durable counter. Cannot be combined with a constant default.",
"type": "boolean"
},
"min": {
"type": "integer",
"minimum": -9007199254740991,
"maximum": 9007199254740991
},
"max": {
"type": "integer",
"minimum": -9007199254740991,
"maximum": 9007199254740991
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "float"
},
"min": {
"type": "number"
},
"max": {
"type": "number"
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "uri"
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "url"
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "image"
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "boolean"
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "date"
},
"min": {
"type": "string",
"pattern": "^(?!0000)\\d{4}-\\d{2}-\\d{2}$",
"format": "date",
"examples": ["2024-01-01"]
},
"max": {
"type": "string",
"pattern": "^(?!0000)\\d{4}-\\d{2}-\\d{2}$",
"format": "date",
"examples": ["2024-01-01"]
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "time"
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "date-time"
},
"min": {
"type": "string",
"pattern": "^(?!0000)\\d{4}-\\d{2}-\\d{2}T(?:[01]\\d|2[0-3]):[0-5]\\d:[0-5]\\d(?:\\.\\d{1,3})?Z$",
"format": "date-time",
"description": "UTC instant with mandatory Z and at most three fractional digits.",
"examples": ["2024-01-01T12:30:00.000Z"]
},
"max": {
"type": "string",
"pattern": "^(?!0000)\\d{4}-\\d{2}-\\d{2}T(?:[01]\\d|2[0-3]):[0-5]\\d:[0-5]\\d(?:\\.\\d{1,3})?Z$",
"format": "date-time",
"description": "UTC instant with mandatory Z and at most three fractional digits.",
"examples": ["2024-01-01T12:30:00.000Z"]
}
},
"required": ["name", "type"],
"additionalProperties": false
},
{
"type": "object",
"properties": {
"name": {
"type": "string",
"minLength": 1,
"maxLength": 64,
"pattern": "^[A-Za-z_]+$"
},
"required": {
"type": "boolean"
},
"default": {
"description": "Any finite JSON value. Cell size/depth and typed numeric policies are enforced by the domain validator.",
"anyOf": [
{
"type": "null"
},
{
"type": "boolean"
},
{
"type": "number"
},
{
"type": "string"
},
{
"type": "array",
"items": {}
},
{
"type": "object",
"additionalProperties": {}
}
]
},
"order": {
"type": "integer",
"minimum": 0,
"maximum": 199
},
"type": {
"type": "string",
"const": "json"
}
},
"required": ["name", "type"],
"additionalProperties": false
}
]
},
"clearDefault": {
"description": "Remove the previous constant default. Do not also supply field.default.",
"type": "boolean"
},
"conversion": {
"type": "string",
"enum": ["explicit", "lossless"]
},
"idempotencyKey": {
"type": "string",
"minLength": 8,
"maxLength": 255,
"description": "Stable caller-provided key across retries of this exact operation."
}
},
"required": [
"orgId",
"databaseId",
"tableId",
"expectedSchemaVersion",
"fieldId",
"field",
"idempotencyKey"
],
"additionalProperties": false
}
Example call
Your client initializes the MCP connection before this call. Example identifiers and values are illustrative; use the IDs, schema version and values from your installation.{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "rootset_update_field",
"arguments": {
"orgId": "01K6J7B8000000000000000000",
"databaseId": "01K6J7B8000000000000000000",
"tableId": "01K6J7B8000000000000000000",
"expectedSchemaVersion": 1,
"fieldId": "01K6J7B8000000000000000000",
"field": {
"name": "example",
"type": "text"
},
"idempotencyKey": "example-request-0001"
}
}
}
Result
Read the structured result returned by the tool. A tool failure setsisError; do not treat an error as a completed operation. The REST operation documents the corresponding result fields and errors.
Connect an MCP client · REST conventions