ClickHouse icon

ClickHouse

Query, insert, update, delete, and manage ClickHouse tables. Supports AI agent tool use with schema discovery, auto-pagination for large results, and parameterized queries.

Actions11

Delete Rows

AI-generated

Summary

Delete rows from a ClickHouse table using a WHERE clause.

Inputs

  • table (required) — The table to delete rows from. Choose from the list, or specify an ID using an expression.
  • where (required) — The WHERE condition for the DELETE. Rows matching this condition will be deleted. Do NOT include the WHERE keyword.
  • options — Collection of optional settings for the delete operation, including database override and query settings.

Output shape

An object indicating success with table, where clause, and response message, or an error object when an exception occurs.

On success the operation returns a record containing the deleted table name, the WHERE condition, and the server response; in case of failure it may throw an error unless continueOnFail is enabled, in which case an error field is returned in the output.

Examples

Example 1: Delete inactive users

table = 'users', where = 'status = 'inactive'', options = {"mutations_sync": 1}

Example 2: Delete all expired sessions

table = 'sessions', where = 'expires_at < now()', options = {"mutations_sync": 1}

Links

Discussion