find_relevant_tables
Find tables matching a semantic description (e.g., 'customer orders') by ranking columns by cosine similarity. Returns scores and matched column descriptions to explain why each table surfaced.
Instructions
Use this when the user describes tables semantically (e.g. 'the table with customer orders', 'where we store payments'). Returns ranked hits with cosine scores plus the matched column and its LLM description so you see WHY each table surfaced. Use describe_table instead when the user names a specific table by qualified name. Common compositions: chain to describe_table for semantic-to-structural queries; chain to suggest_joins to discover then wire multi-table queries.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | Natural-language description of the table or data the user is asking about (e.g. 'customer orders', 'where we store payments'). Embedded with the same model used to index column descriptions, then ranked by cosine similarity against per-column descriptions. | |
| limit | No | Maximum number of ranked hits to return. Default 10. Use a small value (3-5) for narrow exploratory queries; use 10-20 when surveying an unfamiliar schema. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| status | Yes | ||
| data | No | ||
| error | No | ||
| confidence | No | ||
| provenance | No | ||
| follow_up_hints | No | ||
| degradation_reason | No | ||
| charter_version | No | 1.2 |