What metrics are tracked by the transaction monitor?

It tracks transaction duration, lock wait times, rollback frequencies, and general transaction anomalies.

When should I use the Database Transaction Monitor?

Use it when you notice database performance degradation, suspect long-running queries are blocking resources, or need to audit transaction success rates.

How does this skill detect database issues?

The skill executes the /txn-monitor command to analyze transaction data against predefined thresholds for duration, lock wait times, and rollback rates.

Can it help resolve database deadlocks?

Yes, it specifically identifies lock contention and deadlock patterns, helping you pinpoint the exact transactions causing the block.

Does it integrate with other monitoring tools?

Yes, it is designed to complement existing monitoring systems and can be integrated into broader observability workflows.

Database Transaction Monitor

Name: Database Transaction Monitor
Author: intent-solutions-io

byintent-solutions-io

データベース管理

Monitors database transactions in real-time to detect long-running queries, lock contention, and transaction anomalies.

概要

The Database Transaction Monitor skill empowers Claude to proactively manage database health and performance. By leveraging specialized plugin commands, it identifies bottlenecks such as transactions exceeding duration thresholds, high rollback rates, and lock wait times. This skill is essential for developers and DBAs who need to troubleshoot performance degradation, resolve deadlocks, and maintain high availability in production environments through automated monitoring and real-time alerts.

主な機能

Transaction rollback rate tracking and analysis
Automated detection of long-running queries
0 GitHub stars
Proactive alerting for database health anomalies
Real-time transaction performance monitoring
Lock contention and deadlock pattern identification

ユースケース

Monitoring application error rates through transaction rollback analysis
Identifying and terminating blocking transactions that impact system performance
Diagnosing the root cause of high database latency and lock wait times

概要

主な機能

Transaction rollback rate tracking and analysis
Automated detection of long-running queries
0 GitHub stars
Proactive alerting for database health anomalies
Real-time transaction performance monitoring
Lock contention and deadlock pattern identification

ユースケース

Monitoring application error rates through transaction rollback analysis
Identifying and terminating blocking transactions that impact system performance
Diagnosing the root cause of high database latency and lock wait times