Deep health check — verifies DB connectivity.
Successful Response
Overall service status: 'ok' or 'degraded'.
Individual subsystem statuses (e.g. {'database': 'ok', 'cache': 'ok'}).