db-performance-watchlist

Monitor slow queries, connections, resource usage, and index efficiency in production databases.

Updated Jan 21, 2026
One-click install
npx skills add https://github.com/vecear/Nipponverb --skill db-performance-watchlist-vecear
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-performance-watchlist
Source: https://github.com/vecear/Nipponverb/tree/main/.claude/skills/db-performance-watchlist
Command: npx skills add https://github.com/vecear/Nipponverb --skill db-performance-watchlist-vecear

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires node-cron, and includes scripts (resource) components.

What problem does it solve?

Defines a database performance monitoring strategy with slow query detection, resource usage alerts, and automated thresholds to prevent regressions.

Core Features & Use Cases

  • Slow query detection with configurable thresholds to surface long-running queries before they impact users.
  • Connection pool and resource usage monitoring to track CPU, memory, and I/O pressure.
  • Automated alerts and periodic reports to support proactive DB administration and capacity planning.

Quick Start

Run the monitor-db.ts script to start ongoing DB performance monitoring.

Frequently Asked Questions about db-performance-watchlist

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

FAQPage Schema
How do I monitor slow queries and database performance in PostgreSQL?

Database performance monitoring works by scheduling periodic checks using node-cron to evaluate slow queries, connection pools, and resource usage against configurable thresholds, generating automated alerts and dashboards to prevent regressions.

Can I set automated thresholds for database performance alerts?

Yes, automated thresholds are supported for database performance alerts. You can configure limits for slow query detection, CPU, memory, and I/O pressure to receive proactive notifications when resource usage or latency exceeds acceptable bounds.

Does this database monitoring approach work with MySQL as well as PostgreSQL?

Database monitoring applies to production database environments like PostgreSQL and MySQL. It tracks connection pools, resource usage, and index efficiency across these platforms using modular scripts designed for periodic performance checks.

What is the best way to track connection pool usage and index efficiency?

The best way to track connection pool usage and index efficiency is through a modular monitoring script that schedules periodic checks, evaluates resource pressure, and generates periodic reports to support capacity planning and proactive DB administration.

Do I need node-cron to schedule periodic database performance reports?

Yes, node-cron is required to schedule periodic database performance reports. It drives the monitoring routines that execute threshold checks and generate dashboards for ongoing DB administration and capacity planning.