Query Houston records
houston_query_recordsQuery Houston Open Data records with filters, sorting, full-text search, column selection, and pagination; returns up to 100 rows and total match counts.
Instructions
Read rows from a queryable resource, with filters and pagination.
Returns at most 100 rows per call. Use total to count matches without
paging through them, for example with a limit of 1. There is no server-side
aggregation, so for sums or averages over many rows, page through
next_offset. Very long text values are truncated.
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": {
"resource_id": "<resource_id>"
},
"name": "houston_query_records"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | Column and direction, such as "YEAR desc". | |
| text | No | Full-text search across all columns in the table. | |
| columns | No | Columns to return. Omit to return all of them. | |
| filters | No | Exact matches by column, such as {"COUNCIL_DISTRICT": "K"}. | |
| pagination | No | ||
| resource_id | Yes | Resource `id` (UUID) from houston_get_dataset. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||