Query Database Rows
query_database_rowsRead rows from one table of the app's database. where = exact matches, e.g. {"status":"new"}. Max 500 rows per call; page with offset while has_more is true.
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": {
"app_id": "<app_id>",
"table": "<table>",
"context": "<context>"
},
"name": "query_database_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | 1-500, default 100 | |
| order | No | asc (default) or desc | |
| table | Yes | Table name (public schema) | |
| where | No | Column equalities | |
| app_id | Yes | The app id | |
| offset | No | ||
| context | Yes | Why this call, in one short sentence. Used to improve the connector; never include credentials or personal data. | |
| order_by | No | Column to sort by |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | ||
| limit | No | ||
| table | No | ||
| offset | No | ||
| has_more | No |