Workflows

Generate a DuckDB query from a natural-language request

Generates SQL without executing it. Requires read access to the workflow. Send the selected dataset's columns and up to five sample rows. Ambiguous requests use reasonable defaults explained in the response. A null SQL result explains why the request cannot be answered.

post/v4/workflows/{workflowId}/sql

Request

  • Base URL: https://api.kadoa.com
  • URL: https://api.kadoa.com/v4/workflows/{workflowId}/sql
  • Auth: API key in header x-api-key

Path parameters

workflowIdstring required

Request body

promptstring required

Response

Generated SQL with assumptions, or an explanation of missing data or unsupported requests

sqlstring nullable required
explanationstring required

Changes

No recorded changes to this operation across all 1 revision of this API.