detecting-database-deadlocks
About
This skill detects, analyzes, and helps prevent database deadlocks by monitoring lock contention and transaction patterns. It's triggered by user requests to find deadlocks, analyze their causes, or monitor database locks, making it ideal for troubleshooting recurring issues in production systems. The core functionality is executed via the plugin's `/deadlock` command.
Quick Install
Claude Code
Recommended/plugin add https://github.com/jeremylongshore/claude-code-plugins-plusgit clone https://github.com/jeremylongshore/claude-code-plugins-plus.git ~/.claude/skills/detecting-database-deadlocksCopy and paste this command in Claude Code to install this skill
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.
GitHub Repository
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.
content-collections
MetaThis skill provides a production-tested setup for Content Collections, a TypeScript-first tool that transforms Markdown/MDX files into type-safe data collections with Zod validation. Use it when building blogs, documentation sites, or content-heavy Vite + React applications to ensure type safety and automatic content validation. It covers everything from Vite plugin configuration and MDX compilation to deployment optimization and schema validation.
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.