What kind of reports does the skill provide?

The skill generates a summary of detected deadlocks, details on the involved transactions, root cause analysis, and actionable resolution strategies.

Can I use this for proactive monitoring?

Yes, you can request Claude to set up monitoring configurations that track database locks and notify you when potential deadlocks are detected.

Does this skill require database access?

Yes, the plugin must be configured with the necessary database connection details and permissions to inspect lock states and transaction logs.

Which databases are supported?

The skill is designed to work with most major SQL database systems supported by the underlying deadlock-detector plugin.

How does this skill detect database deadlocks?

It utilizes the database-deadlock-detector plugin to run the /deadlock command, which monitors active database locks and analyzes transaction contention patterns.

Database Deadlock Detector

Name: Database Deadlock Detector
Author: jeremylongshore

byjeremylongshore

•

883

•

데이터베이스 관리

Identifies, analyzes, and resolves database lock contention and transaction deadlocks to maintain system stability.

The Database Deadlock Detector skill empowers Claude to proactively monitor and troubleshoot database performance issues by identifying lock contention and transaction deadlocks. By executing the /deadlock command, the skill analyzes current and historical transaction patterns to pinpoint root causes, generate detailed diagnostic reports, and suggest optimization strategies. This is an essential tool for developers and DBAs working with production systems who need to resolve recurring performance bottlenecks and ensure high availability.

주요 기능

01Proactive monitoring and alert configuration for database health

02In-depth analysis of transaction patterns and root causes

03Seamless integration with production database troubleshooting workflows

04Automated generation of deadlock resolution strategies

05Real-time detection of database deadlocks and lock contention

06883 GitHub stars

사용 사례

01Setting up proactive monitoring to alert on database lock states

02Investigating and resolving recurring deadlock issues in production

03Analyzing transaction logic to optimize database performance and concurrency

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-deadlock-detector

For use in Claude.ai and ChatGPT

Download Skill

주요 기능

01Proactive monitoring and alert configuration for database health

02In-depth analysis of transaction patterns and root causes

03Seamless integration with production database troubleshooting workflows

04Automated generation of deadlock resolution strategies

05Real-time detection of database deadlocks and lock contention

06883 GitHub stars

사용 사례

01Setting up proactive monitoring to alert on database lock states

02Investigating and resolving recurring deadlock issues in production

03Analyzing transaction logic to optimize database performance and concurrency

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills database-deadlock-detector

For use in Claude.ai and ChatGPT

Download Skill