scalix_db_text_to_sql
Translate a plain-language question into a candidate SQL query using pattern-matching against the live schema (no AI model — simple questions only: counts, averages, filtered selects on a named table). Returns the SQL without executing it, with a confidence score; low confidence means the table was guessed. Review the statement and tables_used, then run it with scalix_db_query. For complex questions, read scalix_db_schema and write the SQL directly.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| question | Yes | The question to answer from the database, in plain language (e.g. 'how many orders shipped last week?') |