Which databases are supported by this skill?

The skill supports major database systems including PostgreSQL via psql, MySQL via the mysql client, and MongoDB via mongosh.

Can I use this for real-time monitoring?

While it can diagnose active issues, it is designed to help you set up permanent monitoring dashboards and runbooks for long-term observability.

What permissions are required to use this skill?

Users must have the necessary credentials and permissions to execute administrative shell commands and database queries on the target systems.

Can this skill automatically resolve deadlocks?

It provides scripts and automation tools to resolve deadlocks, but emphasizes a workflow that includes assessment and validation to ensure data integrity.

Does this skill help with preventing future deadlocks?

Yes, it includes implementation patterns, query optimization guides, and best practices to help developers refactor code and avoid lock contention altogether.

Database Deadlock Detector

Name: Database Deadlock Detector
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Detects, resolves, and prevents database deadlocks across PostgreSQL, MySQL, and MongoDB environments to ensure system stability.

The Database Deadlock Detector is a specialized skill for Claude Code designed to identify and mitigate transaction conflicts in high-concurrency database environments. It provides automated detection scripts, step-by-step resolution workflows, and implementation patterns for preventing future deadlocks. By integrating with psql, mysql, and mongosh, the skill helps developers analyze lock wait states, optimize query performance, and establish robust monitoring dashboards to maintain database health and application uptime.

Key Features

01Generation of monitoring dashboards and observability alerts

02Automated deadlock detection for PostgreSQL, MySQL, and MongoDB

03Best practice patterns for deadlock prevention and query optimization

043 GitHub stars

05Comprehensive resolution guidance for active transaction conflicts

06Real-time diagnostic integration via database shell tools

Use Cases

01Identifying and terminating stuck transactions in high-traffic production databases

02Configuring automated observability stacks to alert on lock-contention events

03Refactoring application logic to eliminate circular lock dependencies during development

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