update-data
Modify existing records in a PostgreSQL table using WHERE conditions for precision. Supports complex queries and returns updated data for verification.
Instructions
Update existing records in a table. Requires WHERE conditions for safety. Supports complex WHERE clauses and returns updated records.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | ||
| returning | No | ||
| table | Yes | ||
| where | Yes |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"data": {
"additionalProperties": {},
"type": "object"
},
"returning": {
"default": [
"*"
],
"items": {
"type": "string"
},
"type": "array"
},
"table": {
"minLength": 1,
"type": "string"
},
"where": {
"additionalProperties": {},
"type": "object"
}
},
"required": [
"table",
"data",
"where"
],
"type": "object"
}