SQLAlchemy

Package: sqlalchemy · 10 nodes · SQL database access

Connect to SQLite, PostgreSQL, or MySQL databases. Execute queries, insert data, and create tables.

Node Reference

Node	Type	Inputs	Outputs
Connect	statement	-	Engine (sql.Engine), Connection (sql.Connection)
Transaction	statement	Connection (sql.Connection)	-
Execute	statement	Connection (sql.Connection), Query (str), Params (dict<string, any>)	Result (sql.Result)
Query	statement	Connection (sql.Connection), Query (str)	Rows (list)
Insert	statement	Connection (sql.Connection), Data (dict<string, any>)	-
Create Table	statement	Connection (sql.Connection), SQL (str)	-
Row Count	expression	Result (sql.Result)	Count (int)
Get Column	expression	Rows (list)	Values (list)
Build Query	expression	-	Query (str)
Build Params	expression	Key 0 (str), Value 0 (any), Key 1 (str), Value 1 (any)	Params (dict<string, any>)

Typical Pipeline

Connect → Create Table → Insert / Query → Get Column to extract values.