delete_data
Permanently removes records from database tables using physical DELETE operations. Use with caution as this bypasses soft delete patterns and cannot be undone.
Instructions
Executes a physical DELETE operation on table records. WARNING: This database uses soft delete patterns (__deleted flag). Consider using update_data to set __deleted = 1 instead for most use cases.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tableName | Yes | Name of the table to delete from | |
| whereClause | Yes | WHERE clause to identify which records to delete. REQUIRED for safety. | |
| confirmDelete | Yes | Must be set to true to confirm physical deletion. Physical deletes are permanent and bypass the soft delete pattern. |