---
title: "POST /api/llm/generate-sql"
method: POST
path: "/api/llm/generate-sql"
tags: ["/api/llm"]
---

# POST /api/llm/generate-sql

`POST /api/llm/generate-sql`

Generate SQL from a natural language prompt.

   Requires:
   - LLM to be configured (Anthropic API key set in admin settings)
   - At least one table reference (explicit @mention or implicit from source_sql)
   - A database_id parameter

   Returns generated SQL and the list of tables used for context.

## Request body

- object
  - `database_id` integer, required
  - `prompt` string, required
  - `referenced_entities` object[]
    - `id` integer, required
    - `model` string, required
  - `source_sql` string

## Response `2XX`

Successful response

- object
  - `referenced_entities` object[], required
    - `columns` object[], required
      - `database_type` string, nullable
      - `description` string, nullable
      - `fk_target` object
        - `field_name` string, required
        - `table_name` string, required
      - `id` integer, required
      - `name` string, required
      - `semantic_type` string, nullable
    - `description` string, nullable
    - `display_name` string, nullable
    - `id` integer, required
    - `model` string, required
    - `name` string, required
    - `schema` string, nullable
  - `sql` string, required

## Other responses

- `4XX` — Client error response
- `5XX` — Server error response

---

[API](https://skmtc.net/metabase/apis/metabase-api.md) · [All operations](https://skmtc.net/metabase/apis/metabase-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/metabase/metabase-api/revisions/08b5a2bafb4f/schema)