nullRatio
nullRatioDetect sparse or mostly-null columns in any table with one scan, returning null/non-null counts and ratios sorted by sparsity to identify data-quality gaps.
Instructions
Find sparse or mostly-null fields across every column of one table in a single scan. Returns null/non-null counts and ratios sorted by sparsity; use describeTable when only declared nullability is needed.
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": {
"connection": "<connection>",
"table": "<table>"
},
"name": "nullRatio"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| schema | No | ||
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | ||
| schema | No | ||
| columns | No | Per-column null-ratio entries, sorted by descending null ratio. | |
| totalRows | Yes | Total number of rows considered for this statistic. |