Delete documents from an Infino table
infino_delete_documentsRemove rows matching a SQL predicate, such as status = 'spam', and get the count of deleted records. Verify the selection first with a count query to avoid unintended removal.
Instructions
Delete the rows matching a SQL predicate, e.g. "status = 'spam'". Returns how many rows matched and were removed. Check the predicate first with infino_count or infino_sql. Requires durable storage (not memory://).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>",
"predicate": "<predicate>"
},
"name": "infino_delete_documents"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table to delete from. | |
| predicate | Yes | SQL predicate selecting the rows to delete, e.g. "status = 'spam'". |