intent-solutions-io/detecting-database-deadlocks
010-archive/backups-20251108/skills-migration-20251108-070147/plugins/database/database-deadlock-detector/skills/database-deadlock-detector/SKILL.md
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 issues. The plugin's command `/deadlock` is triggered by these requests.
$ install --global
skillsauthnpx skillsauth add intent-solutions-io/plugins-nixtla detecting-database-deadlocksInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Jul 11, 2026, 8:53 AM237.2s4 files scanned
SKILL.md
- name:
- detecting-database-deadlocks
- description:
- |
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
intent-solutions-io/running-load-tests
tools
VerifiedTrustedCommunity
This skill enables Claude to create and execute load tests for performance validation. It is designed to generate load test scripts using tools like k6, JMeter, and Artillery, based on specified test scenarios. Use this skill when the user requests to create a "load test", conduct "performance testing", validate "application performance", or needs a "stress test" to identify breaking points in the application. The skill helps define performance thresholds and provides execution instructions.
9SKILL.mdUpdated Aug 26, 2026
intent-solutions-io/collecting-infrastructure-metrics
testing
VerifiedTrustedCommunity
This skill enables Claude to collect comprehensive infrastructure performance metrics across compute, storage, network, containers, load balancers, and databases. It is triggered when the user requests "collect infrastructure metrics", "monitor server performance", "set up performance dashboards", or needs to analyze system resource utilization. The skill configures metrics collection, sets up aggregation, and helps create infrastructure dashboards for health monitoring and capacity tracking. It supports configuration for Prometheus, Datadog, and CloudWatch.
9SKILL.mdUpdated Aug 26, 2026
intent-solutions-io/monitoring-error-rates
tools
VerifiedTrustedCommunity
This skill enables Claude to monitor and analyze application error rates to improve reliability. It is used when the user needs to track and understand errors occurring in their application, including HTTP errors, application exceptions, database errors, external API errors, background job errors, and client-side errors. Use this skill when the user asks to "monitor errors", "analyze error rates", "track application errors", or requests help with "error monitoring". It sets up comprehensive error tracking and alerting based on defined thresholds.
9SKILL.mdUpdated Aug 26, 2026
intent-solutions-io/setting-up-distributed-tracing
development
VerifiedTrustedCommunity
This skill automates the setup of distributed tracing for microservices. It helps developers implement end-to-end request visibility by configuring context propagation, span creation, trace collection, and analysis. Use this skill when the user requests to set up distributed tracing, implement observability, or troubleshoot performance issues in a microservices architecture. The skill is triggered by phrases such as "setup tracing", "implement distributed tracing", "configure opentelemetry", or "add observability to microservices".
9SKILL.mdUpdated Aug 26, 2026