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<any>) |
| 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<any>) | Values (list<any>) |
| 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.