count
Get row counts for a table with a quick planner estimate, optionally applying a WHERE filter, or execute an exact count when precise numbers are required.
Instructions
Row count, estimate-first: instant planner estimate (no scan), optionally with a WHERE clause; exact=true runs a real count(*) under the statement timeout. Prefer the estimate.
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": {
"table": "<table>"
},
"name": "count"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| exact | No | ||
| table | Yes | ||
| where | No | ||
| profile | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |