polardb-daily-check

Assess PolarDB for PostgreSQL health via polar_monitor and PostgreSQL queries.

38|12|Updated Feb 4, 2026

Search Tags:#monitoring #postgresql #health-check #polardb #HTAP #MPP

Ready to run

npx skills add https://github.com/digoal/postgres_skill --skill polardb-daily-check

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: polardb-daily-check
Source: https://github.com/digoal/postgres_skill/tree/main/polardb-daily-check
Command: npx skills add https://github.com/digoal/postgres_skill --skill polardb-daily-check

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psql, and includes scripts (resource) components.

What problem does it solve?

This Skill provides automated PolarDB for PostgreSQL health checks, consolidating core health, HTAP/MPP monitoring, and high-availability insights into a clear report.

Core Features & Use Cases

PolarDB Core Health checks (node type, LogIndex, PFS usage) and standard PostgreSQL health checks, enabling proactive issue detection.
HTAP/MPP awareness with worker status, parallel query performance, and storage-I/O insights for planning and tuning.
Use Case: Run the full daily health check to generate a comprehensive PolarDB health report and targeted recommendations.

Quick Start

Run the full health check script to generate polar_daily_health_report.md:

Ensure you have a running PolarDB for PostgreSQL instance with polar_monitor installed.
From the skill's scripts directory, execute: python3 polardb_agent.py or ./run_polardb_check.sh full_check

Frequently Asked Questions about polardb-daily-check

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I run daily PolarDB for PostgreSQL health checks?▼

To run daily PolarDB health checks, execute the script from the skill's scripts directory using `python3 polardb_agent.py` or `./run_polardb_check.sh full_check` to generate a comprehensive markdown report.

What metrics are included in a PolarDB HTAP and MPP health assessment?▼

A PolarDB HTAP and MPP health assessment aggregates worker status, parallel query performance, and storage-I/O metrics, alongside core health and high-availability insights to surface issues early.

Do I need the polar_monitor extension to perform PolarDB health audits?▼

Yes, you need a running PolarDB for PostgreSQL instance with the `polar_monitor` extension installed and the `psql` dependency to execute standard queries and generate structured JSON results.

Can I monitor read-only nodes and primary nodes separately in PolarDB?▼

Yes, PolarDB daily health audits are applicable across both primary and read-only nodes, aggregating node type, LogIndex, and PFS usage metrics to assess database health proactively.

What is the best way to automate PolarDB storage I/O and performance monitoring?▼

Automating PolarDB storage I/O monitoring is best achieved by running the scriptable health check, which returns structured JSON results containing performance and HTAP insights for tuning.