delete-data
Delete records from PostgreSQL tables using WHERE conditions for precise removal. Includes confirmation prompts for large deletions to ensure data safety.
Instructions
Delete records from a table. Requires WHERE conditions for safety. Includes confirmation prompt for large deletions.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| confirm_delete | No | ||
| returning | No | ||
| table | Yes | ||
| where | Yes |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"confirm_delete": {
"default": false,
"type": "boolean"
},
"returning": {
"items": {
"type": "string"
},
"type": "array"
},
"table": {
"minLength": 1,
"type": "string"
},
"where": {
"additionalProperties": {},
"type": "object"
}
},
"required": [
"table",
"where"
],
"type": "object"
}