> detecting-database-deadlocks
This skill uses the database-deadlock-detector plugin to detect, analyze, and prevent database deadlocks. It monitors database lock contention, analyzes transaction patterns, and suggests resolution strategies. Use this skill when the user asks to "detect database deadlocks", "analyze deadlock causes", "monitor database locks", or any requests related to database deadlock prevention and resolution. This skill is particularly useful for production database systems experiencing recurring deadlock
curl "https://skillshub.wtf/jeremylongshore/claude-code-plugins-plus-skills/database-deadlock-detector?format=md"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.
> related_skills --same-repo
> agent-context-loader
PROACTIVE AUTO-LOADING: Automatically detects and loads AGENTS.md files from the current working directory when starting a session or changing directories. This skill ensures agent-specific instructions are incorporated into Claude Code's context alongside CLAUDE.md, enabling specialized agent behaviors. Triggers automatically when Claude detects it's working in a directory, when starting a new session, or when explicitly requested to "load agent context" or "check for AGENTS.md file".
> Google Cloud Agent SDK Master
Automatic activation for ALL Google Cloud Agent Development Kit (ADK) and Agent Starter Pack operations - multi-agent systems, containerized deployment, RAG agents, and production orchestration. **TRIGGER PHRASES:** - "adk", "agent development kit", "agent starter pack", "multi-agent", "build agent" - "cloud run agent", "gke deployment", "agent engine", "containerized agent" - "rag agent", "react agent", "agent orchestration", "agent templates" **AUTO-INVOKES FOR:** - Agent creation and scaffold
> Vertex AI Media Master
Automatic activation for ALL Google Vertex AI multimodal operations - video processing, audio generation, image creation, and marketing campaigns. **TRIGGER PHRASES:** - "vertex ai", "gemini multimodal", "process video", "generate audio", "create images", "marketing campaign" - "imagen", "video understanding", "multimodal", "content generation", "media assets" **AUTO-INVOKES FOR:** - Video processing and understanding (up to 6 hours) - Audio generation and transcription - Image generation with I
> yaml-master
PROACTIVE YAML INTELLIGENCE: Automatically activates when working with YAML files, configuration management, CI/CD pipelines, Kubernetes manifests, Docker Compose, or any YAML-based workflows. Provides intelligent validation, schema inference, linting, format conversion (JSON/TOML/XML), and structural transformations with deep understanding of YAML specifications and common anti-patterns.