Database Queries

Update data in database (REST API)

Changed on Sep 19, 2026

Update existing rows in your database using REST API.

Security: Row-Level Security ensures you can only update data you have access to

Safety: Requires at least one filter to prevent accidental mass updates. A request with no filters is rejected with 400 (mirrors delete). This matters for service-key queries, which run with full access and bypass RLS.

Note: If RLS blocks the update, an empty result is returned (not an error)

post/databases/{databaseName}/query/update

Request

Base URL: https://api.volcano.dev
URL: https://api.volcano.dev/databases/{databaseName}/query/update
Auth: HTTP bearer

Path parameters

databaseNamestring required

Database name (unique within project, lowercase letters, numbers, and underscores only)

Request body

tablestring required

Table name

valuesobject required

Column values to update. JSON objects and arrays are stored as JSON, so send them to json or jsonb columns. For a Postgres array column, send an array literal string such as "{a,b}".

Example request

{
  "table": "posts",
  "values": {
    "title": "Updated Title",
    "status": "published"
  },
  "filters": [
    {
      "column": "id",
      "operator": "eq",
      "value": "post-uuid"
    }
  ]
}

Response

Update successful

dataobject[]

Result rows

countinteger

Number of rows returned

Changes

Sep 19, 20263a6f365f3f35 Revision changes
- ▲
  added the new path request parameter databaseName
- ▲
  added the new required request property
- ▲
  added the new required request property
- ▲
  added the new required request property
- ▲
  the request's body type changed from no type to object
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the required property to the response with the status
- ○
  added the required property to the response with the status
- ○
  added the required property to the response with the status
- ○
  added the required property to the response with the status
- ○
  added the required property to the response with the status
Aug 27, 2026bb44e98aba2e Revision changes
- ▲
  the request's body type changed from object to no type
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  removed the required property from the response with the status
- ▲
  removed the required property from the response with the status
- ▲
  removed the required property from the response with the status
- ▲
  removed the required property from the response with the status
- ▲
  removed the required property from the response with the status
- ●
  deleted the path request parameter databaseName
- ●
  removed the request property
- ●
  removed the request property
- ●
  removed the request property
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status

Operation history (3 revisions)