SQLite ManagerInstall

Summary

Execute a custom SQL query against a specified SQLite database file and optionally return the query results as output items.

Inputs

• Database Name (required) — Specifies the SQLite database file to run the query on. If no extension is provided, .db is appended automatically.
• SQL (required) — The SQL query to execute on the selected database.
• Return Data — Determines whether to output the resulting rows from the query as workflow items.
• Fail On Empty Result — If enabled and Return Data is true, the node throws an error when the query returns no rows.

Output shape

A list of JSON objects representing each row returned by the query if 'Return Data' is true; otherwise, a single JSON object summarizing the SQL execution result.

If 'Return Data' is enabled, the node outputs one item per returned row. If the query returns no rows and 'Fail On Empty Result' is enabled, the node fails. If 'Return Data' is disabled, the node outputs a single item with a 'result' string indicating query success or output message.