postgres-daily-check
CommunityAutomate daily PostgreSQL health checks.
Authordigoal
Version1.0.0
Installs0
System Documentation
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.
Dependency Matrix
Required Modules
None requiredComponents
scriptsassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgres-daily-check Download link: https://github.com/digoal/postgres_skill/archive/main.zip#postgres-daily-check Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.