postgres-daily-check

Analyze PostgreSQL instances and generate a daily health report.

38|12|Updated Feb 4, 2026

Search Tags:#automation #monitoring #postgresql #health-check #daily-report #report-generation

Ready to run

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

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and assets (resource) components.

What problem does it solve?

This skill automates comprehensive daily health checks for PostgreSQL databases, reducing manual DBA effort and speeding issue detection.

Core Features & Use Cases

Availability & health monitoring: validates responsiveness, detects invalid indexes, wraparound risks, blocking locks, and deadlocks.
Performance & activity insights: tracks long-running queries, idle in transactions, hotspot activity, and IO usage.
Security & replication awareness: reports connection security status and replication/archiving health.
Daily reporting: generates a structured Markdown daily_health_report.md with actionable findings.

Quick Start

Use the postgres-daily-check skill to generate a daily health report for a local PostgreSQL instance. Run the agent from the skill directory or invoke the script to execute all checks and produce daily_health_report.md.

Frequently Asked Questions about postgres-daily-check

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

FAQPage Schema

How do I automate daily PostgreSQL health checks for availability and performance?▼

Automate daily PostgreSQL health checks by running scripted checks across availability, performance, security, replication, and maintenance domains to detect issues. The process loads metrics and generates a structured Markdown report with actionable findings for database maintenance.

What is included in a comprehensive PostgreSQL health report for daily monitoring?▼

A comprehensive PostgreSQL health report includes findings on responsiveness, invalid indexes, wraparound risks, blocking locks, deadlocks, long-running queries, idle transactions, connection security, and replication health to provide actionable insights.

How do I detect blocking locks and long-running queries in PostgreSQL automatically?▼

Detect blocking locks and long-running queries automatically by executing scripted checks that analyze database activity and IO usage. The checks return structured JSON data for each metric, which is then compiled into a daily health report.

Can I monitor PostgreSQL replication and archiving health using automated scripts?▼

Yes, you can monitor PostgreSQL replication and archiving health using automated scripts that assess connection security and replication status. These scripts return structured JSON outputs detailing replication health for daily reporting.

Does this PostgreSQL health check require external dependencies or tools?▼

This PostgreSQL health check requires no external dependencies to run. It operates using internal scripts to load metrics directly from the database instance and outputs a daily_health_report.md file without needing additional monitoring tools.

What format does the daily PostgreSQL health report generate?▼

The daily PostgreSQL health report generates a daily_health_report.md file in Markdown format. Individual checks return structured JSON data, which is aggregated into the Markdown report to present actionable findings clearly.