Database Query Node
Execute a parameterized SQL query against a SQLite database. Returns rows as a list of dicts, row count, and column names. Handles connection lifecycle automatically.
Node Interface
Inputs
Outputs
Tags
Source
website_examples/database_query.json
Production node definition (node_id, inputs, outputs, python_code)
Related Examples
Browse all →Prism Multi-Asset Publisher
intermediateBatch-publish multiple assets to Prism Pipeline in a single execution: iterate over an asset name list, validate each entry, create versioned Prism products, and return published vs failed counts.
Houdini SOP Chain
intermediateCreate a Houdini geo container, clear defaults, wire a Box SOP into a PolyExtrude SOP, set all parameters, and cook the network — entirely over the live JSON-RPC bridge.
LLM Text Generation
beginnerSend a prompt to a Gemini LLM endpoint with configurable system instruction, temperature, and max tokens. Returns generated text, token count, and a success flag.