SQLiteInstall

Summary

Deletes rows from a SQLite table by matching configured columns against values on each input item. Choose the database and table, then set at least one Match Column; each item runs a parameterized DELETE with equality conditions joined by AND.

Inputs

• Database File Path Override — Optional absolute database file path. Overrides the credential’s database path and base directory.
• Database — Optional database file path relative to the credential’s Base Directory; it cannot resolve outside that directory. Ignored when Database File Path Override is set.
• Read Only — Opens the database read-only. Since delete is a write, the SQLite engine will reject execution when this is enabled.
• Confirm Destructive Operation — Defaults off. The guard blocks DELETE statements without a WHERE clause; deletes built by this operation include match conditions, so they are not classified as whole-table deletes.
• Execution Mode — Defaults to Independent, running one statement per input item. Transaction runs items in one transaction and rolls back on an error. Multi-Row Insert is for inserts and does not apply to this operation.
• Table (required) — SQLite table whose rows will be deleted.
• Match Columns (required) — Select one or more columns. For each input item, the operation reads those fields and deletes rows where every selected column equals its corresponding value.

Output shape

A list of items, normally one per input item.

Each successful item contains {"changes": number, "lastInsertRowid": number|string} and is paired with its input item. With Continue On Fail, an item may instead contain {"error": string}; transaction mode rolls back if an item fails.

Links

• n8n community nodes installation guide