Databases

SQLite nodes: connect, query and edit a local database.

8 nodes. Right-click any node in the editor to read this documentation in the app.

Database

🔒 SQLite Close

id sqlite_close · Database · Python export: yes

Close a SQLite connection. Do this after the last statement that uses it.

Inputs

Port	Type	Description
connection	Connection	The connection to close.

Outputs

Port	Type	Description
closed	bool	True once the connection is closed.

🗄️ SQLite Connect

id sqlite_connect · Database · Python export: yes

Open (or create) a SQLite database file and output the connection. Wire it into the other SQLite nodes. A relative path is relative to the project folder.

Outputs

Port	Type	Description
connection	Connection	Open SQLite connection — wire into Query, Execute, Insert, …

Fields

Field	Type	Default	Choices
Database file (relative to project, or absolute)	text	data.db
Create if missing	checkbox	true

🗑️ SQLite Delete Row

id sqlite_delete_row · Database · Python export: yes

Delete the rows of a table matching a WHERE fragment (with ? placeholders). An empty WHERE deletes every row — check it first. Passes the connection through.

Inputs

Port	Type	Description
connection	Connection	Open connection from SQLite Connect.
where_params	list	Values for the WHERE ? placeholders (overrides the field). Overrides the WHERE params (JSON array) field when connected.

Outputs

Port	Type	Description
connection	Connection	The same connection, so statements can be chained.

Fields

Field	Type	Default	Choices
Table	text
WHERE (SQL fragment, use ? placeholders)	text	id = ?
WHERE params (JSON array)	text	[]

✏️ SQLite Execute

id sqlite_execute · Database · Python export: yes

Run one statement that changes data or schema (CREATE / INSERT / UPDATE / DELETE) and commit it. Passes the connection through so statements can be chained in order.

Inputs

Port	Type	Description
connection	Connection	Open connection from SQLite Connect.
params	list | dict	Values for the ? placeholders (overrides the Params field). Overrides the Params (JSON array or object) field when connected.

Outputs

Port	Type	Description
connection	Connection	The same connection, so statements can be chained.

Fields

Field	Type	Default	Choices
SQL (DDL / INSERT / UPDATE / DELETE)	code	CREATE TABLE IF NOT EXISTS users (id INTEGER PR…
Params (JSON array or object)	text	[]

➕ SQLite Insert Row

id sqlite_insert_row · Database · Python export: yes

Insert one row from a JSON object of column: value pairs. The table and column names are validated and the values are bound as parameters, so they can't inject SQL. Passes the connection through.

Inputs

Port	Type	Description
connection	Connection	Open connection from SQLite Connect.
row	dict | str	Row as an object of column: value (overrides the Row field). Overrides the Row (JSON object) field when connected.

Outputs

Port	Type	Description
connection	Connection	The same connection, so statements can be chained.

Fields

Field	Type	Default	Choices
Table	text
Row (JSON object)	code	{"column": "value"}

🔍 SQLite Query

id sqlite_query · Database · Python export: yes

Run a SELECT and return the rows as a DataFrame. Use ? placeholders in the SQL and supply their values as a JSON array (or wire a list into Params) rather than pasting values into the SQL. To change data use SQLite Execute.

Inputs

Port	Type	Description
connection	Connection	Open connection from SQLite Connect.
params	list | dict	Values for the ? placeholders (overrides the Params field). Overrides the Params (JSON array or object) field when connected.

Outputs

Port	Type	Description
result	DataFrame	The result rows, one column per selected column.

Fields

Field	Type	Default	Choices
SQL (SELECT)	code	SELECT name FROM sqlite_master WHERE type='tabl…
Params (JSON array or object)	text	[]

📋 SQLite Select Table

id sqlite_select_table · Database · Python export: yes

Read rows from one table as a DataFrame without writing SQL: choose the columns, an optional WHERE fragment with ? placeholders, and a row limit (0 = no limit).

Inputs

Port	Type	Description
connection	Connection	Open connection from SQLite Connect.
where_params	list	Values for the WHERE ? placeholders (overrides the field). Overrides the WHERE params (JSON array) field when connected.

Outputs

Port	Type	Description
result	DataFrame	The selected rows.

Fields

Field	Type	Default	Choices
Table	text
Columns (comma-separated, or *)	text	*
WHERE (SQL fragment, use ? placeholders)	text
WHERE params (JSON array)	text	[]
Limit	int	100

📝 SQLite Update Row

id sqlite_update_row · Database · Python export: yes

Update rows of a table: SET a JSON object of column: value pairs WHERE a SQL fragment matches (with ? placeholders for the WHERE values). Names are validated and values bound as parameters. Passes the connection through.

Inputs

Port	Type	Description
connection	Connection	Open connection from SQLite Connect.
set	dict | str	Columns to set, as an object (overrides the SET field). Overrides the SET (JSON object) field when connected.
where_params	list	Values for the WHERE ? placeholders (overrides the field). Overrides the WHERE params (JSON array) field when connected.

Outputs

Port	Type	Description
connection	Connection	The same connection, so statements can be chained.

Fields

Field	Type	Default	Choices
Table	text
SET (JSON object)	code	{"column": "value"}
WHERE (SQL fragment, use ? placeholders)	text	id = ?
WHERE params (JSON array)	text	[]