Check database health
check_database_healthRun health checks on a PostgreSQL database: connection usage, cache hit ratio, vacuum needs, and invalid indexes. Returns overall status and per-check details.
Instructions
Run database health checks: connection utilisation, buffer cache hit ratio, tables needing vacuum, and invalid indexes. Returns an object with status ('ok' / 'warning' / 'critical') and checks (a list of {name, status, detail} per check).
Example: check_database_health()
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 |
|---|---|---|---|
| checks | Yes | ||
| status | Yes |