Lookup Values
lookup_valuesRetrieve real values stored in a database column to ground literal filters before writing SQL. Use it to confirm exact names, status codes, or categories and avoid invalid query conditions.
Instructions
Real values stored in a column, to ground literal filters ('Pennsylvania', a product name, a status code) before you write them into SQL.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum values. | |
| column | Yes | 'table.column'. | |
| contains | No | Case-insensitive text to look for. Omit to list the most common values. | |
| datasource | No | Datasource name. Optional when only one datasource is registered. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||