Database and Workflows

This page is generated from the repository on every merge to main; changes made here are overwritten.

execute_read_only_sql

Execute a read-only SQL query against a named PostGIS connection or active project layers.

Parameter	Type	Required	Description
connection_name	string	no
sql_query	string	yes
geometry_column	string	no	Name of the geometry column in the query result; omit for a non-spatial result table.

load_workflow_preset

Load a saved workflow preset JSON by name.

Parameter	Type	Required	Description
preset_name	string	yes

save_workflow_preset

Save an agent plan as a re-usable JSON workflow preset. To build a recurring monitoring workflow (see run_monitoring_workflow/schedule_recurring_workflow), save workflow_json in the shape '{"steps": [{"tool": "calculate_severity_index", "args": {...}}, ...]}' -- an ordered list of read-only analysis tool calls to re-run and diff over time.

Parameter	Type	Required	Description
preset_name	string	yes
workflow_json	string	yes