n8n-nodes-sqlite

Overview

Manage and manipulate SQLite database files within n8n workflows, enabling workflow users to integrate lightweight, file-based databases for data storage, retrieval, and modification. This package provides nodes to create, query, insert, update, and delete data in SQLite databases, ideal for users needing embedded database operations in automation.

Nodes & Operations

Sqlite

Perform CRUD operations and execute custom SQL queries on SQLite database files, facilitating direct interaction with lightweight, file-based databases within workflows.

• Default · CreateFile — Create or open an SQLite database file at the specified path to enable subsequent database operations within a workflow.
• Default · Delete — Delete rows from an SQLite database file specified by its path.
• Default · Execute Query — Execute a custom SQL query on a specified SQLite database file and return the result rows as JSON.
• Default · Insert — Insert one or more new rows into a specified table in an SQLite database file.
• Default · Update — Update rows in a specified SQLite database table by matching a key column and setting new values for specified columns.

Installation

Install as an n8n community node: in n8n, open Settings → Community nodes → Install and enter n8n-nodes-sqlite.

Links

• n8n community nodes installation guide