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

•

分析与监控

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

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.

主要功能

013 GitHub stars

02Automated tracking and analysis of rollback rates

03Lock contention and deadlock pattern detection

04Real-time transaction monitoring and performance analysis

05Health alerts for transaction anomalies and system bottlenecks

06Identification of long-running transactions and blocking queries

使用场景

01Analyzing transaction error patterns through rollback rate monitoring

02Troubleshooting database performance issues during high-load scenarios

03Detecting and managing long-running transactions that block production queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection skill-adapter

For use in Claude.ai and ChatGPT

主要功能

013 GitHub stars

02Automated tracking and analysis of rollback rates

03Lock contention and deadlock pattern detection

04Real-time transaction monitoring and performance analysis

05Health alerts for transaction anomalies and system bottlenecks

06Identification of long-running transactions and blocking queries

使用场景

01Analyzing transaction error patterns through rollback rate monitoring

02Troubleshooting database performance issues during high-load scenarios

03Detecting and managing long-running transactions that block production queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection skill-adapter

For use in Claude.ai and ChatGPT