skills.rest
OmniNode-ai
OmniNode-aiOFFICIAL
Explore all skills by this author →
GitHub

check-database-health

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

3|1|Updated Oct 9, 2025
Search Tags:#performance#monitoring#database#postgresql#sql#health check
One-click install
npx skills add https://github.com/OmniNode-ai/omniclaude --skill check-database-health
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: check-database-health
Source: https://github.com/OmniNode-ai/omniclaude/tree/main/plugins/onex/skills/system-status/check-database-health
Command: npx skills add https://github.com/OmniNode-ai/omniclaude --skill check-database-health

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps identify and diagnose potential performance bottlenecks or failures within the PostgreSQL database, ensuring the stability and responsiveness of the application.

Core Features & Use Cases

  • Database Health Check: Assesses the overall health of the PostgreSQL instance.
  • Performance Metrics: Provides insights into table statistics, connection pool usage, and query performance.
  • Activity Monitoring: Tracks recent activity on key tables to identify trends or anomalies.
  • Use Case: Quickly check if the database is experiencing high connection load or if specific tables are showing unusual activity patterns.

Quick Start

Check the health of the PostgreSQL database for the agent_manifest_injections and agent_routing_decisions tables.

Frequently Asked Questions about check-database-health

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

FAQPage Schema
How do I check PostgreSQL database health and performance metrics?▼

To check PostgreSQL database health, you monitor table statistics, connection pool status, and query performance. This identifies performance bottlenecks and assesses overall instance stability for proactive maintenance.

What PostgreSQL statistics should I monitor for proactive database maintenance?▼

For proactive database maintenance, monitor PostgreSQL table statistics, connection pool usage, and query performance metrics. Tracking recent activity on specific tables identifies unusual patterns and potential failures.

Can I scope a PostgreSQL health check to specific tables?▼

Yes, you can scope a PostgreSQL health check to specific tables for detailed activity analysis and size reporting. This targets monitoring efforts to identify unusual activity patterns on key tables.

How do I diagnose high connection load in a PostgreSQL database?▼

You diagnose high connection load in a PostgreSQL database by checking connection pool status and monitoring recent activity. This identifies if the database experiences excessive connection usage or query bottlenecks.

Does this database monitoring approach require external dependencies?▼

No, this database monitoring approach requires no external dependencies. It uses scripts to directly query PostgreSQL table statistics, connection pool status, and query performance metrics for health analysis.

Related Skills

Explore More Software Engineering Skills→
hgflimahgflima
1

deby

Manage PostgreSQL connections, schemas, and SQL queries via natural language.

Community
Advanced
Mentor-WizardMentor-Wizard
10

database-optimizer

Analyze slow queries and execution plans for PostgreSQL and MySQL.

Official
Advanced
HsienWHsienW
63

performance-optimization

Analyze web application performance bottlenecks using Lighthouse and web-vitals metrics.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

Community
Advanced