How does the Database Deadlock Detector identify issues?

The skill utilizes the /deadlock command to scan your database for current lock contention and historical transaction patterns that indicate potential or active deadlocks.

Can I use this skill on production databases?

Yes, it is specifically designed to help troubleshoot production environments, provided the plugin is configured with the necessary permissions to read database lock metadata.

How do I trigger the deadlock analysis?

Simply ask Claude to 'investigate recent deadlocks', 'monitor database locks', or 'analyze transaction contention' to activate the detector plugin.

Does it automatically fix deadlocks?

It provides a detailed analysis of the involved transactions and suggests specific resolution strategies, allowing developers to apply the safest and most effective fix.

What kind of reports does this skill generate?

It produces reports summarizing detected deadlocks, the specific transactions involved, their SQL statements, and recommended changes to schema or logic to prevent recurrence.

Database Deadlock Detector

Name: Database Deadlock Detector
Author: jeremylongshore

byjeremylongshore

•

883

データベース管理

Identifies, analyzes, and resolves database lock contention and transaction deadlocks to maintain system stability.

概要

The Database Deadlock Detector skill equips Claude with the ability to monitor database environments for transaction conflicts and locking issues. By executing the specialized /deadlock command, it analyzes transaction patterns, identifies root causes of resource contention, and suggests proactive optimization strategies. This tool is essential for database administrators and backend developers looking to troubleshoot performance bottlenecks, investigate recurring production outages, and implement automated monitoring to prevent future deadlock scenarios.

主な機能

Root cause identification for lock contention
Comprehensive deadlock reporting and alerting
Automated deadlock detection and analysis
Proactive resolution and optimization strategies
Real-time transaction pattern monitoring
883 GitHub stars

ユースケース

Investigating recurring deadlock issues in production databases
Analyzing complex transaction patterns causing resource conflicts
Implementing proactive lock contention monitoring and alerts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-deadlock-detector

For use in Claude.ai and ChatGPT

Download Skill

GitHub

概要