OpenClaw LaunchOpenClaw Launch
📡

Database Monitoring

Verified

by Community

Configures database monitoring covering query performance, connection counts, replication lag, lock contention, cache hit ratios, and disk usage. Supports PostgreSQL pg_stat, MySQL performance_schema, and general database health metrics.

monitoringdatabaseperformancemetricsobservability

Database Monitoring

Set up comprehensive database monitoring and alerting for proactive performance management.

Usage

Describe your database setup and this skill will configure monitoring for key performance and health metrics.

Examples

  • "Set up monitoring for PostgreSQL with Prometheus and Grafana"
  • "Alert me when replication lag exceeds 10 seconds"
  • "Monitor connection pool saturation and slow queries"

Guidelines

  • Monitor cache hit ratio and aim for above 99% for OLTP workloads
  • Track replication lag for read replicas
  • Alert on connection count approaching the maximum
  • Monitor transaction ID wraparound risk in PostgreSQL
  • Set up slow query logging with appropriate thresholds

More Database & SQL Skills

🗂️
Database Schema Designer

Design normalized database schemas for applications.

🔀
Migration Script Generator

Generate database migration scripts for schema changes.

📑
Index Advisor

Recommend database indexes for optimal query performance.

🔍
Query Explain Analyzer

Interpret database EXPLAIN output to diagnose performance.