Get data checksums status
get_data_checksums_statusCheck if PostgreSQL's data checksums can be toggled online and retrieve the current status, with fallback guidance for older versions.
Instructions
Report whether PG 19's online data_checksums toggle is usable + the current setting. Never raises — driver-level errors surface as available=false. On PG ≤ 18 reports available=false but still surfaces the current state (set at initdb time) so the agent has context, and points at the offline pg_checksums fallback. Returns an object with available (bool), server_version_num (int), server_version, enabled (bool / null), and detail (guidance string).
Example: get_data_checksums_status()
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| detail | Yes | ||
| enabled | Yes | ||
| available | Yes | ||
| server_version | Yes | ||
| server_version_num | Yes |