Run Paged Read-Only Query
ob_query_pageExecute read-only SELECT/WITH queries with server-side pagination to efficiently retrieve paginated results from OceanBase databases.
Instructions
Run a strictly read-only SELECT/WITH query with server-side pagination.
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": {
"sql": "<sql>"
},
"name": "ob_query_page"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| page | No | ||
| params | No | ||
| orderBy | No | ||
| profile | No | ||
| pageSize | No |