kintone MCP Server

Official

Overview Schema Source Related Servers Score Discussions Admin

Update Records

kintone-update-records

Update multiple kintone records by specifying record IDs and field values. Check form fields first to discover editable field codes and avoid unsupported fields.

Instructions

Update multiple records in a kintone app. Use kintone-get-form-fields tool first to discover available field codes and their required formats. Note: Some fields cannot be updated (LOOKUP copies, STATUS, CATEGORY, CALC, ASSIGNEE, auto-calculated fields).

Input Schema

TableJSON Schema

Name	Required	Description	Default
`app`	Yes	The ID of the app to update records in (numeric value as string)
`records`	Yes	Array of records to update (min 1, max 100). Each record must have an ID to identify which record to update.

Output Schema

TableJSON Schema

Name	Required	Description	Default
`records`	Yes	Array of updated record information

Schema Changelog

Changes observed during successful MCP inspections.

Changed6 schema fields changedv1.9.3Aug 26, 2026

changedInput schema / $schema

Previous value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"

removedInput schema / properties / records / items / additionalProperties
```
Removed value: -false
```

changedInput schema / properties / records / items / properties / record / additionalProperties / anyOf

Previous value: -[
-  {
-    "anyOf": [
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "description": "Text value for string fields (SINGLE_LINE_TEXT, MULTI_LINE_TEXT, RICH_TEXT, LINK)",
-            "type": [
-              "string",
-              "null"
-            ]
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "description": "Numeric value as string for NUMBER fields (e.g., '123.45'). Only half-width numbers, +/- signs, decimal point (.), and exponential notation (e/E) are allowed. Empty string, null, or undefined for empty values.",
-            "type": [
-              "string",
-              "null"
-            ]
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "description": "Date/time value for DATE, TIME, DATETIME fields (DATE: 'YYYY-MM-DD', TIME: 'HH:mm', DATETIME: 'YYYY-MM-DDTHH:mm:ssZ')",
-            "type": [
-              "string",
-              "null"
-            ]
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "description": "Selected option value for RADIO_BUTTON and DROP_DOWN fields",
-            "type": [
-              "string",
-              "null"
-            ]
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "anyOf": [
-              {
-                "items": {
-                  "type": "string"
-                },
-                "minItems": 0,
-                "type": "array"
-              },
-              {
-                "type": "null"
-              }
-            ],
-            "description": "Array of selected option values for CHECK_BOX and MULTI_SELECT fields"
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "anyOf": [
-              {
-                "items": {
-                  "additionalProperties": false,
-                  "properties": {
-                    "code": {
-                      "description": "User code/login name",
-                      "type": "string"
-                    }
-                  },
-                  "required": [
-                    "code"
-                  ],
-                  "type": "object"
-                },
-                "type": "array"
-              },
-              {
-                "type": "null"
-              }
-            ],
-            "description": "Array of selected users for USER_SELECT fields"
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "anyOf": [
-              {
-                "items": {
-                  "additionalProperties": false,
-                  "properties": {
-                    "code": {
-                      "description": "Organization code",
-                      "type": "string"
-                    }
-                  },
-                  "required": [
-                    "code"
-                  ],
-                  "type": "object"
-                },
-                "type": "array"
-              },
-              {
-                "type": "null"
-              }
-            ],
-            "description": "Array of selected organizations for ORGANIZATION_SELECT fields"
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "anyOf": [
-              {
-                "items": {
-                  "additionalProperties": false,
-                  "properties": {
-                    "code": {
-                      "description": "Group code",
-                      "type": "string"
-                    }
-                  },
-                  "required": [
-                    "code"
-                  ],
-                  "type": "object"
-                },
-                "type": "array"
-              },
-              {
-                "type": "null"
-              }
-            ],
-            "description": "Array of selected groups for GROUP_SELECT fields"
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "anyOf": [
-              {
-                "additionalProperties": false,
-                "properties": {
-                  "code": {
-                    "description": "User code/login name",
-                    "type": "string"
-                  }
-                },
-                "required": [
-                  "code"
-                ],
-                "type": "object"
-              },
-              {
-                "type": "null"
-              }
-            ],
-            "description": "User information for CREATOR and MODIFIER fields (registration format with code only)"
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "anyOf": [
-              {
-                "items": {
-                  "additionalProperties": false,
-                  "properties": {
-                    "id": {
-                      "description": "Row ID (optional for new rows)",
-                      "type": "string"
-                    },
-                    "value": {
-                      "additionalProperties": {},
-                      "description": "Field values within this subtable row",
-                      "type": "object"
-                    }
-                  },
-                  "required": [
-                    "value"
-                  ],
-                  "type": "object"
-                },
-                "type": "array"
-              },
-              {
-                "type": "null"
-              }
-            ],
-            "description": "Array of subtable rows for SUBTABLE fields"
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "description": "Lookup field value for LOOKUP fields (string for SINGLE_LINE_TEXT key, numeric string for NUMBER key)",
-            "type": [
-              "string",
-              "null"
-            ]
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      },
-      {
-        "additionalProperties": false,
-        "properties": {
-          "value": {
-            "description": "Date/time value for CREATED_TIME and UPDATED_TIME fields (ISO 8601 format, only for registration)",
-            "type": [
-              "string",
-              "null"
-            ]
-          }
-        },
-        "required": [
-          "value"
-        ],
-        "type": "object"
-      }
-    ]
-  },
-  {
-    "additionalProperties": false,
-    "properties": {
-      "value": {
-        "anyOf": [
-          {
-            "items": {
-              "additionalProperties": false,
-              "properties": {
-                "fileKey": {
-                  "description": "File key obtained from file upload API",
-                  "type": "string"
-                }
-              },
-              "required": [
-                "fileKey"
-              ],
-              "type": "object"
-            },
-            "type": "array"
-          },
-          {
-            "type": "null"
-          }
-        ],
-        "description": "Array of uploaded files for FILE fields"
-      }
-    },
-    "required": [
-      "value"
-    ],
-    "type": "object"
-  }
-]New value: +[
+  {
+    "anyOf": [
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "type": "string"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Text value for string fields (SINGLE_LINE_TEXT, MULTI_LINE_TEXT, RICH_TEXT, LINK)",
+            "type": [
+              "string",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "type": "string"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Numeric value as string for NUMBER fields (e.g., '123.45'). Only half-width numbers, +/- signs, decimal point (.), and exponential notation (e/E) are allowed. Empty string, null, or undefined for empty values.",
+            "type": [
+              "string",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "type": "string"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Date/time value for DATE, TIME, DATETIME fields (DATE: 'YYYY-MM-DD', TIME: 'HH:mm', DATETIME: 'YYYY-MM-DDTHH:mm:ssZ')",
+            "type": [
+              "string",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "type": "string"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Selected option value for RADIO_BUTTON and DROP_DOWN fields",
+            "type": [
+              "string",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "items": {
+                  "type": "string"
+                },
+                "minItems": 0,
+                "type": "array"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Array of selected option values for CHECK_BOX and MULTI_SELECT fields",
+            "type": [
+              "array",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "items": {
+                  "properties": {
+                    "code": {
+                      "description": "User code/login name",
+                      "type": "string"
+                    }
+                  },
+                  "required": [
+                    "code"
+                  ],
+                  "type": "object"
+                },
+                "type": "array"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Array of selected users for USER_SELECT fields",
+            "type": [
+              "array",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "items": {
+                  "properties": {
+                    "code": {
+                      "description": "Organization code",
+                      "type": "string"
+                    }
+                  },
+                  "required": [
+                    "code"
+                  ],
+                  "type": "object"
+                },
+                "type": "array"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Array of selected organizations for ORGANIZATION_SELECT fields",
+            "type": [
+              "array",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "items": {
+                  "properties": {
+                    "code": {
+                      "description": "Group code",
+                      "type": "string"
+                    }
+                  },
+                  "required": [
+                    "code"
+                  ],
+                  "type": "object"
+                },
+                "type": "array"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Array of selected groups for GROUP_SELECT fields",
+            "type": [
+              "array",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "properties": {
+                  "code": {
+                    "description": "User code/login name",
+                    "type": "string"
+                  }
+                },
+                "required": [
+                  "code"
+                ],
+                "type": "object"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "User information for CREATOR and MODIFIER fields (registration format with code only)",
+            "type": [
+              "object",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "items": {
+                  "properties": {
+                    "id": {
+                      "description": "Row ID (optional for new rows)",
+                      "type": "string"
+                    },
+                    "value": {
+                      "additionalProperties": {},
+                      "description": "Field values within this subtable row",
+                      "propertyNames": {
+                        "type": "string"
+                      },
+                      "type": "object"
+                    }
+                  },
+                  "required": [
+                    "value"
+                  ],
+                  "type": "object"
+                },
+                "type": "array"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Array of subtable rows for SUBTABLE fields",
+            "type": [
+              "array",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "type": "string"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Lookup field value for LOOKUP fields (string for SINGLE_LINE_TEXT key, numeric string for NUMBER key)",
+            "type": [
+              "string",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      },
+      {
+        "properties": {
+          "value": {
+            "anyOf": [
+              {
+                "type": "string"
+              },
+              {
+                "type": "null"
+              }
+            ],
+            "description": "Date/time value for CREATED_TIME and UPDATED_TIME fields (ISO 8601 format, only for registration)",
+            "type": [
+              "string",
+              "null"
+            ]
+          }
+        },
+        "required": [
+          "value"
+        ],
+        "type": "object"
+      }
+    ],
+    "type": "object"
+  },
+  {
+    "properties": {
+      "value": {
+        "anyOf": [
+          {
+            "items": {
+              "properties": {
+                "fileKey": {
+                  "description": "File key obtained from file upload API",
+                  "type": "string"
+                }
+              },
+              "required": [
+                "fileKey"
+              ],
+              "type": "object"
+            },
+            "type": "array"
+          },
+          {
+            "type": "null"
+          }
+        ],
+        "description": "Array of uploaded files for FILE fields",
+        "type": [
+          "array",
+          "null"
+        ]
+      }
+    },
+    "required": [
+      "value"
+    ],
+    "type": "object"
+  }
+]

addedInput schema / properties / records / items / properties / record / additionalProperties / type
```
Added value: +"object"
```
addedInput schema / properties / records / items / properties / record / propertyNames
```
Added value: +{
+  "type": "string"
+}
```

changedOutput schema / $schema

Previous value: -"http://json-schema.org/draft-07/schema#"New value: +"https://json-schema.org/draft/2020-12/schema"

Addedv1.9.1Jul 24, 2026
Removedv1.9.0Jul 22, 2026
First observedv1.4.0May 28, 2026

TDQS

A3.9/5.0

Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It does reveal the mutating nature of the operation and lists useful non-updatable field types, but it omits important behavioral details such as revision/optimistic-locking behavior, partial-failure semantics, and permission/auth requirements.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two compact sentences with the primary action front-loaded. Every sentence adds value: the operation, the prerequisite, and a high-value warning about non-updatable fields. There is no filler or redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The complex schema documents field formats and the output schema presumably covers return values, so those do not need repeating. However, for a write tool with no annotations, the description omits context around revision validation, partial failures, and permissions, making it adequate but not fully complete for an agent to use confidently.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema already provides 100% parameter coverage with detailed descriptions for app, records, revision, and every field value type. The description adds the non-updatable field list and the prerequisite to discover field codes, but much of this is also reflected in the schema, so it does not significantly elevate parameter understanding beyond the baseline.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('Update multiple records') and the resource ('in a kintone app'), which distinguishes it from sibling tools like add-records, delete-records, and get-records. The title alone is generic, but the description adds the object and scope.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly instructs the agent to call kintone-get-form-fields first to discover field codes and formats, which is concrete and actionable. However, it does not provide explicit when-not-to-use guidance or mention alternatives for record creation/deletion, so it is one step below a fully explicit usage guide.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.