detecting-database-deadlocks
について
このスキルは、ロック競合とトランザクションパターンを監視することで、データベースのデッドロックを検出、分析、防止します。特に問題が繰り返し発生する本番システムにおいて、デッドロックの検出、分析、防止に関連するユーザーリクエストによって発動します。データベースデッドロック検出プラグインを通じて `/deadlock` コマンドを使用し、解決策を提供します。
クイックインストール
Claude Code
推奨/plugin add https://github.com/jeremylongshore/claude-code-plugins-plusgit clone https://github.com/jeremylongshore/claude-code-plugins-plus.git ~/.claude/skills/detecting-database-deadlocksこのコマンドをClaude Codeにコピー＆ペーストしてスキルをインストールします
ドキュメント
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 リポジトリ
関連スキル
content-collections
メタThis 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.
polymarket
メタThis skill enables developers to build applications with the Polymarket prediction markets platform, including API integration for trading and market data. It also provides real-time data streaming via WebSocket to monitor live trades and market activity. Use it for implementing trading strategies or creating tools that process live market updates.
hybrid-cloud-networking
メタThis 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.
llamaindex
メタLlamaIndex 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.