SQLite icon

SQLite

Run SQL against a local SQLite database (node-sqlite3-wasm)

Actions6

Database → Insert

AI-generated

Summary

Insert rows into a selected SQLite table using values from incoming items. Choose specific columns or leave Columns empty to use the union of item fields; select Independent, Transaction, or Multi-Row Insert execution to control how items are written.

Inputs

  • Database File Path Override — Optional absolute path to the database file; overrides the credential database path and Base Directory settings.
  • Database — Optional database file path relative to the credential’s Base Directory. Ignored when Database File Path Override is set.
  • Read Only — Opens the database read-only. Writes are rejected by SQLite, so Insert cannot complete when enabled.
  • Execution Mode — Independent runs one INSERT per input item; Transaction runs items in one transaction and rolls back on an error; Multi-Row Insert creates one INSERT statement for all items.
  • Table (required) — The SQLite table to insert into.
  • Columns — Columns to insert. If empty, uses the union of incoming item fields in first-seen order. Fields absent from an item are bound as NULL.

Output shape

A list of items containing write results.

Independent and Transaction modes return one item per input item with changes and lastInsertRowid. Multi-Row Insert returns one item for the batch, paired with the first input item. With Continue On Fail enabled, errors are returned in an item’s error field; otherwise execution fails. Values must be supported SQLite binding types: null, booleans, strings, numbers, bigints, or byte arrays.

Links

Discussion