---
title: "Create Prompt Sql Nl Generation"
method: POST
path: "/api/prompts/sql-generations/nl-generations"
tags: ["Generation"]
---

# Create Prompt Sql Nl Generation

`POST /api/prompts/sql-generations/nl-generations`

## Request body

- PromptSQLNLGenerationRequest
  - `max_rows` integer
  - `metadata` object
  - `sql_generation` PromptSQLGenerationRequest, required
    - `finetuning_id` string
    - `evaluate` boolean
    - `sql` string
    - `metadata` object
    - `prompt` PromptRequest, required
      - `text` string, required
      - `db_connection_id` string, required
      - `metadata` object

## Response `200`

Successful Response

- NLGenerationResponse
  - `id` string
  - `text` string
  - `sql_generation_id` string
  - `metadata` NLGenerationMetadata
    - `dh_internal` DHNLGenerationMetadata
      - `organization_id` string
  - `created_at` string, date-time

## Other responses

- `404` — Not found
- `422` — Validation Error

---

[API](https://skmtc.net/dataherald/apis/fastapi.md) · [All operations](https://skmtc.net/dataherald/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/dataherald/fastapi/versions/e168e98625a8/schema)