get_semantic_context
Assembles SQL-ready context for a natural language question by retrieving relevant tables, columns, foreign keys, business glossary, and example queries.
Instructions
Assemble grounded, SQL-ready context for a question.
Returns the relevant tables/columns, foreign keys, business glossary, metric definitions, value dictionaries, knowledge excerpts, and example queries as formatted text. This is the recommended first step of the lightweight path: take the result, write a read-only SELECT yourself, then call run_sql. Needs no LLM key. For a fully automated answer instead, use ask.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | Yes | Target database connection — its name or id (case-insensitive). List the available connections with list_connections. | |
| question | Yes | The natural-language question you intend to answer with SQL; used to select the most relevant schema and semantic-layer entries. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |