Analyze PostgreSQL instances and generate a daily health report.
npx skills add https://github.com/digoal/postgres_skill --skill postgres-daily-check
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
This skill automates comprehensive daily health checks for PostgreSQL databases, reducing manual DBA effort and speeding issue detection.
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.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
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.
pwv-vcQuery production PostgreSQL databases with read-only credentials.
skytiger6724Define product performance dashboards with metrics, visualizations, and alert thresholds.
7a336e6eDiagnose PostgreSQL bottlenecks via EXPLAIN ANALYZE and optimize indexing.
BearflowerExtend PostgreSQL with TimescaleDB hypertables and continuous aggregates for time-series analytics.
