update_rows

Updates every row that matches the filters and returns how many changed. At least one filter is required, so a whole table can’t be updated by accident.


Scope	`mcp:write`
Annotations	`readOnlyHint: false`
Activity event	`update_rows` with `table` and `count`

Parameters

string

required

Project id from list_projects. You need write access.

string

required

Table name.

object[]

required

At least one condition. Rows must match all of them. See Filters.

object

required

Column values to set, keyed by column name. Pass null to clear a value. id and created_at can’t be updated.

Result

integer

The number of rows updated. 0 when nothing matched.

Example

Arguments

{
  "projectId": "01k7m3x9q2v8d4h6n1r5t0w2yz",
  "table": "books",
  "filters": [{ "col": "title", "op": "eq", "value": "Middlemarch" }],
  "patch": { "finished": true, "rating": 5, "finished_on": "2026-10-20T00:00:00Z" }
}

Result

{ "data": { "updated": 1 } }

Errors

Code	When
`ACCESS_DENIED`	You don’t have write access, or the connection is read-only
`VALIDATION`	No filters, an empty patch, unknown table or column, updating `id` or `created_at`, a value that doesn’t fit its type, setting a required column to `null`, or a row that would exceed 64 KB
`QUOTA_EXCEEDED`	The project’s storage is full

To update one row, filter on its id: [{ "col": "id", "op": "eq", "value": "<uuid>" }].

Overview

Read tools

Write tools

Destructive tools

Parameters

Result

Example

Errors

​Parameters

​Result

​Example

​Errors

Parameters

Result

Example

Errors