Can this skill help with deadlocks?

Yes, it specifically identifies lock contention and deadlock patterns to help you resolve blocking issues.

What does the Database Transaction Monitor skill do?

It allows Claude to monitor database transactions for performance issues, locks, and anomalies using the /txn-monitor command.

Does it support automated alerts?

Yes, the plugin analyzes data and generates alerts based on predefined thresholds for rollback rates, lock waits, and durations.

How do I trigger this skill in Claude Code?

You can trigger it by asking Claude to 'monitor database transactions', 'identify lock contention', or 'find long-running transactions'.

Database Transaction Monitor

Name: Database Transaction Monitor
Author: jeremylongshore

byjeremylongshore

•

884

•

分析与监控

Monitors real-time database transactions to detect lock contention, identify long-running queries, and analyze rollback rates.

This skill enhances Claude with the ability to proactively manage database health by monitoring transaction performance and stability. By leveraging the /txn-monitor command, it identifies bottlenecks like long-running transactions and lock wait times before they impact system performance. It is particularly useful for database administrators and developers who need to diagnose deadlock patterns, track error-related rollback rates, and ensure optimal database throughput during high-load periods.

主要功能

01Analysis of transaction rollback rates

02884 GitHub stars

03Real-time transaction performance monitoring

04Identification of long-running database queries

05Automated lock contention and deadlock detection

06Alert generation based on predefined performance thresholds

使用场景

01Detecting and terminating blocking transactions to restore database performance.

02Analyzing lock wait times to identify and resolve systemic deadlock patterns.

03Monitoring transaction health during application deployments or migration windows.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills skill-adapter

For use in Claude.ai and ChatGPT

Download Skill