Text-to-SQL

Create a database tool config

Provide connection parameters through POST /api/tools_config.

Enable the tool on an agent

Add the text_to_sql tool config id to the agent’s agent_tools.

Ask

The agent introspects the schema, generates SQL, executes it, and answers from the result set.

Schema introspection is cached. After a migration, clear it:

POST /api/rag/schema-cache/invalidate

A query that returns no rows surfaces as 422, not as an empty success — see Errors.