Can I use this skill to find transactions blocking my queries?

Absolutely. The skill is designed to identify long-running transactions and lock contention that may be preventing other queries from executing.

How does the Database Transaction Monitor skill work?

It activates via the database-transaction-monitor plugin and uses the /txn-monitor command to analyze transaction data for performance issues and anomalies.

Does it provide alerts for high rollback rates?

Yes, the skill tracks transaction rollback rates as a key metric to help you identify application errors or database health problems.

What is the primary command for this skill?

The primary command used by this skill is /txn-monitor, which initiates the monitoring and reporting of database transaction health.

Can this skill help resolve database deadlocks?

Yes, it specifically monitors lock wait times and identifies deadlock patterns, providing the insights needed to resolve contention issues effectively.

Database Transaction Monitor

Name: Database Transaction Monitor
Author: BbgnsurfTech

byBbgnsurfTech

•

Analytics & Monitoring

Monitors database transaction health to detect long-running queries, lock contention, and anomalous rollback rates.

About

The Database Transaction Monitor skill empowers Claude to provide real-time observability into database performance and stability. By leveraging the /txn-monitor command, this skill enables Claude to proactively identify bottlenecks such as lock wait times, deadlocks, and transactions exceeding duration thresholds. It is essential for developers and DBAs who need to maintain database health, troubleshoot performance degradation, and analyze transaction anomalies or high rollback rates within their development workflow.

Key Features

3 GitHub stars
Automated tracking and analysis of rollback rates
Lock contention and deadlock pattern detection
Real-time transaction monitoring and performance analysis
Health alerts for transaction anomalies and system bottlenecks
Identification of long-running transactions and blocking queries

Use Cases

Analyzing transaction error patterns through rollback rate monitoring
Troubleshooting database performance issues during high-load scenarios
Detecting and managing long-running transactions that block production queries

About

Key Features

3 GitHub stars
Automated tracking and analysis of rollback rates
Lock contention and deadlock pattern detection
Real-time transaction monitoring and performance analysis
Health alerts for transaction anomalies and system bottlenecks
Identification of long-running transactions and blocking queries

Use Cases

Analyzing transaction error patterns through rollback rate monitoring
Troubleshooting database performance issues during high-load scenarios
Detecting and managing long-running transactions that block production queries