jeremylongshore

detecting-database-deadlocks

@jeremylongshore/detecting-database-deadlocks
jeremylongshore
1,004
123 forks
Updated 1/18/2026
View on GitHub

This skill uses the database-deadlock-detector plugin to detect, analyze, and prevent database deadlocks. It monitors database lock contention, analyzes transaction patterns, and suggests resolution strategies. Use this skill when the user asks to "detect database deadlocks", "analyze deadlock causes", "monitor database locks", or any requests related to database deadlock prevention and resolution. This skill is particularly useful for production database systems experiencing recurring deadlock issues. The plugin's command `/deadlock` is triggered by these requests.

Installation

$skills install @jeremylongshore/detecting-database-deadlocks
Claude Code
Cursor
Copilot
Codex
Antigravity

Details

Repositoryjeremylongshore/claude-code-plugins-plus-skills
Pathbackups/skills-migration-20251108-070147/plugins/database/database-deadlock-detector/skills/database-deadlock-detector/SKILL.md
Branchmain
Scoped Name@jeremylongshore/detecting-database-deadlocks

Usage

After installing, this skill will be available to your AI coding assistant.

Verify installation:

skills list

Skill Instructions

name: detecting-database-deadlocks description: | This skill uses the database-deadlock-detector plugin to detect, analyze, and prevent database deadlocks. It monitors database lock contention, analyzes transaction patterns, and suggests resolution strategies. Use this skill when the user asks to "detect database deadlocks", "analyze deadlock causes", "monitor database locks", or any requests related to database deadlock prevention and resolution. This skill is particularly useful for production database systems experiencing recurring deadlock issues. The plugin's command /deadlock is triggered by these requests.

Overview

This skill enables Claude to automatically detect, analyze, and prevent database deadlocks in database systems. It provides insights into transaction patterns, lock contention, and suggests optimization strategies to minimize deadlock occurrences.

How It Works

  1. Initiate Deadlock Detection: Claude recognizes the user's request related to database deadlocks and activates the database-deadlock-detector plugin.
  2. Execute Deadlock Analysis: The plugin executes the /deadlock command to analyze the database for current and potential deadlocks.
  3. Report Findings: The plugin generates a report summarizing detected deadlocks, their causes, and potential resolution strategies.

When to Use This Skill

This skill activates when you need to:

  • Investigate recurring deadlock issues in production.
  • Implement proactive deadlock detection and alerting.
  • Analyze transaction patterns causing deadlocks.

Examples

Example 1: Investigating Production Deadlocks

User request: "Investigate recent deadlocks in the production database."

The skill will:

  1. Activate the database-deadlock-detector plugin and run the /deadlock command.
  2. Generate a report detailing recent deadlock events, involved transactions, and potential root causes.

Example 2: Implementing Proactive Deadlock Monitoring

User request: "Set up deadlock monitoring for the database."

The skill will:

  1. Activate the database-deadlock-detector plugin and run the /deadlock command with monitoring configurations.
  2. Configure alerts to notify when deadlocks are detected, including details on the involved transactions.

Best Practices

  • Database Access: Ensure the plugin has the necessary database access and permissions to perform deadlock detection.
  • Configuration: Properly configure the plugin with the correct database connection details.
  • Regular Monitoring: Schedule regular deadlock detection runs to proactively identify and address potential issues.

Integration

This skill can be integrated with other monitoring and alerting tools to provide a comprehensive view of database performance and stability. It can also be used in conjunction with database optimization tools to implement recommended resolution strategies.

More by jeremylongshore

View all
rabbitmq-queue-setup
1,004

Rabbitmq Queue Setup - Auto-activating skill for Backend Development. Triggers on: rabbitmq queue setup, rabbitmq queue setup Part of the Backend Development skill category.

model-evaluation-suite
1,004

evaluating-machine-learning-models: This skill allows Claude to evaluate machine learning models using a comprehensive suite of metrics. It should be used when the user requests model performance analysis, validation, or testing. Claude can use this skill to assess model accuracy, precision, recall, F1-score, and other relevant metrics. Trigger this skill when the user mentions "evaluate model", "model performance", "testing metrics", "validation results", or requests a comprehensive "model evaluation".

neural-network-builder
1,004

building-neural-networks: This skill allows Claude to construct and configure neural network architectures using the neural-network-builder plugin. It should be used when the user requests the creation of a new neural network, modification of an existing one, or assistance with defining the layers, parameters, and training process. The skill is triggered by requests involving terms like "build a neural network," "define network architecture," "configure layers," or specific mentions of neural network types (e.g., "CNN," "RNN," "transformer").

oauth-callback-handler
1,004

Oauth Callback Handler - Auto-activating skill for API Integration. Triggers on: oauth callback handler, oauth callback handler Part of the API Integration skill category.