Update rows
PATCH/v1/db/{project_id}/{table}
Updates the rows that match the filter. RLS enforced — a client can only update what it can SELECT.
Query + body#
| Parameter | Type | Required | Description |
|---|---|---|---|
<column>=<op>.<value> | filter | yes | Filter in query parameter (?id=eq.$ID). On the aura-db path, a request without filter is refused with 400. Alternative: target a line by its identifier with PATCH /v1/db/{project_id}/{table}/{id}. |
body | object | yes | Columns to update. Columns not present remain unchanged. |
Protection#
Attention
The “at least one filter” safeguard is that of aura-db (MongoDB project, or Postgres without PostgREST): it responds 400. On a Postgres project served by PostgREST, this safeguard does not exist on the Aurabase side — a PATCH without filter affects every row that RLS lets through. Always filter explicitly.
Tip
Prefer: return=minimal responds 204 without body. Prefer: count=exact adds Content-Range: */{n} and Preference-Applied.
Last updated · Apr 15, 2026↗ Edit on GitHub↗ Report a problem