SQLiteInstall

Summary

Selects rows from a SQLite table, with optional column selection, filters, ordering, and a row limit. Each input item runs the SELECT independently by default; transaction mode runs all items in one transaction.

Inputs

• Database File Path Override — Optional absolute database file path; takes precedence over the credential’s Database File Path and Base Directory.
• Database — Optional database file path relative to the credential’s Base Directory. Ignored when Database File Path Override is set; otherwise the credential’s Database File Path is used if configured.
• Read Only — Opens the database read-only when enabled. Defaults to false.
• Execution Mode — Controls how input items are handled: Independent runs one statement per item; Transaction runs them within one transaction and rolls back on an error. Defaults to Independent.
• Table (required) — SQLite table to query; select it from the list or enter its name.
• Output Columns — Columns to return. Leave empty to return all columns.
• Where Conditions — Optional conditions combined with AND. Supports =, !=, >, <, >=, <=, LIKE, IS NULL, and IS NOT NULL. Comparison values can use expressions for non-string types.
• Order By — Optional ordering terms, each with a column and ASC or DESC direction.
• Limit — Maximum rows to return; 0 means no limit.

Output shape

A list of n8n items, one per returned row.

Each item’s JSON contains the selected columns for that row and is paired with the input item that ran the query. With no input items, returns an empty list. If Continue On Fail is enabled, errors are returned as items with an error field.

Links

• n8n community nodes installation guide