v12

latestOpenAPI 3.1.0AGPL-3.0raw.githubusercontent.com2026-05-286377631.6 MB
/api/llm

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.

post/api/llm/generate-sql

Request body

database_idinteger required
promptstring required
source_sqlstring

Response

Successful response

sqlstring required