skills.rest
digoal
digoalCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/digoal/postgres_skill --skill polardb-daily-check
Or copy as Structured Prompt for Agent▼
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:

  1. Ensure you have a running PolarDB for PostgreSQL instance with polar_monitor installed.
  2. 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.

Related Skills

Explore More Data & Analytics Skills→
dversozadversoza
2

postgres

Query PostgreSQL databases read-only via psql for schema introspection and EXPLAIN plans.

Community
Intermediate
matteocervellimatteocervelli
25

planning-doc-generator

Generate project assessment Markdown reports from structured JSON data.

Community
Intermediate
rabbicserabbicse

postgres-pro

Analyze PostgreSQL execution plans and recommend safe index and query optimizations.

Community
Advanced
OmniNode-aiOmniNode-ai
3

check-database-health

Monitor PostgreSQL database health, table statistics, connection pools, and query performance.

Official
Intermediate