Query table with filter
query_tableSelect rows from a table using one validated filter (column, operator, value) and control result count up to 200 rows.
Instructions
Select rows from a table with a single WHERE condition (column, operator, value). Column and operator are validated against the real schema. Max 200 rows.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"schema": "<schema>",
"table": "<table>",
"column": "<column>",
"operator": "<operator>",
"value": "<value>"
},
"name": "query_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Row limit (default 50, max 200) | |
| table | Yes | Table name | |
| value | Yes | Value to compare against | |
| column | Yes | Column to filter on — must exist on the table | |
| schema | Yes | Schema name, e.g. 'dbo' | |
| operator | Yes | Comparison operator |