monitoring-database-transactions

Overview

This skill empowers Claude to proactively monitor database transactions, identify performance bottlenecks like long-running queries and lock contention, and alert on anomalies such as high rollback rates. It provides insights into database health and helps prevent performance degradation.

How It Works

1. Activation: The user's request triggers the database-transaction-monitor plugin.
2. Transaction Monitoring: The plugin executes the /txn-monitor command to initiate transaction monitoring.
3. Alerting: The plugin analyzes transaction data and generates alerts based on predefined thresholds for long-running transactions, lock wait times, and rollback rates.

When to Use This Skill

This skill activates when you need to:

• Detect and kill long-running transactions blocking other queries.
• Monitor lock wait times and identify deadlock patterns.
• Track transaction rollback rates for error analysis.

Examples