What kind of alerts does this skill provide?

It generates real-time alerts for transaction anomalies, including transactions exceeding time limits, high lock wait patterns, and elevated rollback rates.

Does this skill work with any database?

The skill is designed to work with any database supported by the underlying database-transaction-monitor plugin, focusing on standard transaction metrics.

How does this skill detect database issues?

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

Can this skill help stop problematic transactions?

Yes, it is designed to identify and provide the necessary insights to kill long-running transactions that are blocking other queries or causing system lag.

Database Transaction Monitor

Name: Database Transaction Monitor
Author: jeremylongshore

byjeremylongshore

•

884

•

分析与监控

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

The Database Transaction Monitor skill equips Claude with the ability to proactively manage database health by identifying bottlenecks such as lock waits and excessive rollback rates. By leveraging the /txn-monitor command, this skill enables users to detect and terminate problematic transactions, analyze deadlock patterns, and maintain optimal system performance through automated alerts and real-time observability. It is an essential tool for developers and DBAs looking to prevent performance degradation in high-concurrency environments.

主要功能

01Real-time transaction monitoring via the /txn-monitor command

02884 GitHub stars

03Automated detection of long-running queries and lock contention

04Transaction rollback rate analysis for error detection

05Lock wait time monitoring and deadlock pattern identification

06Threshold-based alerting for proactive database health management

使用场景

01Troubleshooting performance degradation caused by high database lock wait times

02Identifying and terminating transactions that are blocking production queries

03Monitoring transaction health during high-traffic events to prevent system failure

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-transaction-monitor

For use in Claude.ai and ChatGPT

Download Skill

主要功能

01Real-time transaction monitoring via the /txn-monitor command

02884 GitHub stars

03Automated detection of long-running queries and lock contention

04Transaction rollback rate analysis for error detection

05Lock wait time monitoring and deadlock pattern identification

06Threshold-based alerting for proactive database health management

使用场景

01Troubleshooting performance degradation caused by high database lock wait times

02Identifying and terminating transactions that are blocking production queries

03Monitoring transaction health during high-traffic events to prevent system failure

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-transaction-monitor

For use in Claude.ai and ChatGPT

Download Skill