Database Queries

Delete data from database (REST API)

Changed on Sep 19, 2026

Delete rows from your database using REST API.

Safety: Requires at least one filter to prevent accidental mass deletions

Security: Row-Level Security ensures you can only delete data you have access to

Note: If RLS blocks the delete, an empty result is returned (not an error)

post/databases/{databaseName}/query/delete

Request

Base URL: https://api.volcano.dev
URL: https://api.volcano.dev/databases/{databaseName}/query/delete
Auth: HTTP bearer

Path parameters

databaseNamestring required

Database name (unique within project, lowercase letters, numbers, and underscores only)

Request body

tablestring required

Table name

Example request

{
  "table": "posts",
  "filters": [
    {
      "column": "id",
      "operator": "eq",
      "value": "post-uuid"
    }
  ]
}

Response

Delete successful

dataobject[]

Result rows

countinteger

Number of rows returned

Changes

Sep 19, 20263a6f365f3f35 Revision changes
- ▲
  added the new path request parameter databaseName
- ▲
  added the new required request property
- ▲
  added the new required request property
- ▲
  the request's body type changed from no type to object
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ▲
  the response's body type changed from no type to object for status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the optional property to the response with the status
- ○
  added the required property to the response with the status
- ○
  added the required property to the response with the status
- ○
  added the required property to the response with the status
- ○
  added the required property to the response with the status
- ○
  added the required property to the response with the status
Aug 27, 2026bb44e98aba2e Revision changes
- ▲
  the request's body type changed from object to no type
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  the response's body type changed from object to no type for status
- ▲
  removed the required property from the response with the status
- ▲
  removed the required property from the response with the status
- ▲
  removed the required property from the response with the status
- ▲
  removed the required property from the response with the status
- ▲
  removed the required property from the response with the status
- ●
  deleted the path request parameter databaseName
- ●
  removed the request property
- ●
  removed the request property
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status
- ●
  removed the optional property from the response with the status

Operation history (3 revisions)