delete_query
Deletes rows from a database by executing a DELETE statement. Commits automatically and returns the number of affected rows. Requires a writable connection.
Instructions
Execute a DELETE statement. Commits automatically. Only available on writable connections (readonly=false in list_schemas). Returns the number of rows deleted.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | DELETE SQL statement. Must start with DELETE. | |
| params | No | Bind parameters as key-value pairs, e.g. {"id": 1}. | |
| connection | No | Connection name from list_schemas. Must have readonly=false. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |