Execute database statement
db_executeExecute non-SELECT SQL statements (CREATE, INSERT, UPDATE, DELETE, ALTER, DROP) on a SQLite database, creating the database file if missing. Requires confirm='EXECUTE' and logs each statement to log_path.
Instructions
Runs a single SQL statement that isn't SELECT — CREATE TABLE, INSERT, UPDATE, DELETE, ALTER, DROP. Requires confirm='EXECUTE'. Creates the database file (and its parent folder) if it doesn't exist yet — this is how you create a new database: CREATE TABLE against a path that doesn't exist yet. One statement per call. params: a list for '?' positional placeholders, or a dict for ':name' named placeholders — write a whole row with one call by pairing a for_each step (item_arg='params') over a list of row-dicts with an INSERT using ':name' placeholders matching the dict's keys. confirm/log_path go in args, shared across every item in for_each — one 'EXECUTE' in the step still gates the whole series. Logs every statement to log_path.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| params | No | ||
| confirm | Yes | ||
| db_path | Yes | ||
| log_path | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||