How does the skill detect database deadlocks?

The skill utilizes the /deadlock command to scan the database's internal lock tables and transaction logs, identifying blocked processes and circular dependencies.

Is this skill safe to use on production databases?

Yes, it is designed to analyze existing database metadata and logs; however, users should ensure the plugin has the appropriate read-only or diagnostic permissions.

Does it support proactive monitoring?

Yes, the skill can be used to configure proactive monitoring runs to identify potential locking bottlenecks before they lead to actual system deadlocks.

Can this skill automatically fix deadlock issues?

While it doesn't modify code or database schemas directly, it provides specific, actionable resolution strategies and code optimization suggestions to resolve the root causes.

Which database types are supported?

It is compatible with most major relational database systems (RDBMS) that provide access to lock contention and transaction metadata through the plugin's interface.

Database Deadlock Detector

Name: Database Deadlock Detector
Author: BbgnsurfTech

byBbgnsurfTech

•

データベース管理

Identifies and resolves database lock contention and transaction deadlocks to improve system stability and performance.

This skill empowers Claude to proactively detect and analyze complex database deadlock issues by monitoring lock contention and transaction patterns. By leveraging the /deadlock command, it provides developers with in-depth reports on root causes and suggests actionable resolution strategies, making it an essential tool for stabilizing production environments experiencing recurring performance bottlenecks and transaction failures.

主な機能

013 GitHub stars

02Automated deadlock detection via the /deadlock command

03Real-time monitoring of production database lock status

04Actionable resolution and optimization strategy generation

05Detailed analysis of transaction patterns causing contention

06Comprehensive reporting on recent deadlock events and root causes

ユースケース

01Setting up proactive monitoring and alerting for database lock contention

02Investigating and resolving recurring deadlock events in high-traffic production databases

03Auditing complex transaction logic to identify and refactor inefficient locking patterns

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection database-deadlock-detector

For use in Claude.ai and ChatGPT

Download Skill