Skip to content
Proud to collaborate with Microsoft for Startups

neon.query.run ​

Resolve a Neon connection URI and execute a SQL statement against a branch

Overview ​

PropertyValue
Workflow typeAtomic
LibraryApp-neon
Version1.0

Input Schema ​

FieldTypeRequiredDefaultDescription
organization_uuiduuidYes——
cloud_connection_uuiduuidYes——
neon_branch_uuiduuidYes——
role_namestringYes——
db_namestringYes——
sqlstringYes—SQL statement. Use PostgreSQL %s placeholders for bind params, e.g. SELECT * FROM users WHERE id = %s.
paramslistNo—Values for SQL %s placeholders, in order. Required when sql contains %s placeholders.
fetch_resultsbooleanNo——
timeout_secondsintegerNo——
actorstringNo——

Output Schema ​

FieldTypeRequiredDefaultDescription
organization_uuiduuidNo——
neon_branch_uuiduuidNo——
rowslistNo——
row_countintegerNo——
status_messagestringNo——
executed_atstringNo——
failure_reasonstringNo—Engine-stamped human-readable failure reason
failed_at_statestringNo—Engine-stamped state when the workflow failed
failed_stepstringNo—Engine-stamped step name (DAG path)
failed_layerintegerNo—Engine-stamped layer index (DAG path)
errorstringNo—Engine-stamped exception message
error_typestringNo—Engine-stamped exception class name
failure_typestringNo—Engine-stamped failure category (atomic path)
failed_actionstringNo—Engine-stamped action method that raised (atomic path)

States ​

StateInitialTerminalSuccessAuto-advanceDescription
initiatedYesNo—executeInputs accepted
completedNoYesYes—Query executed
failedNoYesNo—Query failed

State Diagram ​

Transitions ​

FromActionToDescription
initiatedexecutecompleted—
* (any state)failfailed—

API Usage ​

bash
POST /api/workflows/start
Content-Type: application/json

{
  "workflow_type": "neon.query.run",
  "initial_data": {
    "organization_uuid": "value",
    "cloud_connection_uuid": "value",
    "neon_branch_uuid": "value",
    "role_name": "value"
  }
}