detecting-database-deadlocks
About
This skill detects, analyzes, and prevents database deadlocks by monitoring lock contention and transaction patterns. It's triggered by user requests related to deadlock detection, analysis, or prevention, particularly for production systems with recurring issues. The skill uses the `/deadlock` command via the database-deadlock-detector plugin to provide resolution strategies.
Documentation
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
- Initiate Deadlock Detection: Claude recognizes the user's request related to database deadlocks and activates the database-deadlock-detector plugin.
- Execute Deadlock Analysis: The plugin executes the
/deadlockcommand to analyze the database for current and potential deadlocks. - 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:
- Activate the database-deadlock-detector plugin and run the
/deadlockcommand. - 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:
- Activate the database-deadlock-detector plugin and run the
/deadlockcommand with monitoring configurations. - 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.
Quick Install
/plugin add https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/database-deadlock-detectorCopy and paste this command in Claude Code to install this skill
GitHub 仓库
Related Skills
csv-data-summarizer
MetaThis skill automatically analyzes CSV files to generate comprehensive statistical summaries and visualizations using Python's pandas and matplotlib/seaborn. It should be triggered whenever a user uploads or references CSV data without prompting for analysis preferences. The tool provides immediate insights into data structure, quality, and patterns through automated analysis and visualization.
llamaindex
MetaLlamaIndex is a data framework for building RAG-powered LLM applications, specializing in document ingestion, indexing, and querying. It provides key features like vector indices, query engines, and agents, and supports over 300 data connectors. Use it for document Q&A, chatbots, and knowledge retrieval when building data-centric applications.
hybrid-cloud-networking
MetaThis skill configures secure hybrid cloud networking between on-premises infrastructure and cloud platforms like AWS, Azure, and GCP. Use it when connecting data centers to the cloud, building hybrid architectures, or implementing secure cross-premises connectivity. It supports key capabilities such as VPNs and dedicated connections like AWS Direct Connect for high-performance, reliable setups.
Excel Analysis
MetaThis skill enables developers to analyze Excel files and perform data operations using pandas. It can read spreadsheets, create pivot tables, generate charts, and conduct data analysis on .xlsx files and tabular data. Use it when working with Excel files, spreadsheets, or any structured tabular data within Claude Code.