Skip to content
TrustedSkillsbeta
Back to all skills

Detecting Database Deadlocks

Listed
jeremylongshore·vlatest·database·MIT

Identifies and resolves database deadlocks proactively, minimizing application downtime and improving performance.

Repository

Install on your platform

Showing Claude Code. One command installs this skill into any of the agents below.

  1. 1

    Run this in your project

    terminal
    $ npx skills add jeremylongshore/tons-of-skills-marketplace --skill detecting-database-deadlocks -a claude-code

  2. Uses the open-source skills CLI and needs Node.js. Add -g to install it for your user instead of this project.

What we know about this skill

Publisher

jeremylongshore

Taken from the source listing. We haven't verified who controls this account.

Install target

Live repository

Not pinned. Installing fetches whatever the repository holds at the time you run the command.

Nobody has reviewed this code. TrustedSkills indexes and links skills; it does not audit, run or scan them. A skill runs with whatever access you give your agent — read the source before you install it.

Automated safety checks

scanned

We could not read this skill's source, so none of the checks below were run.

Not scanned. none of the 396 skills in the repository match this slug — it was most likely renamed or removed upstream after the registry indexed it Source recorded as jeremylongshore/claude-code-plugins-plus-skills.
This is a static scan, not a review. It reads the skill's files; it does not run them, and it cannot tell you whether the skill is any good or whether the code does what its description says. A skill runs with whatever access you give your agent.
What each check looks for →

About this skill

What it does

This skill identifies database deadlocks, analyzes the involved transactions and resources, and suggests potential resolutions. It can pinpoint the specific SQL queries causing the deadlock and offer recommendations for optimizing transaction order or resource locking strategies to prevent future occurrences. The skill aims to reduce application downtime and improve overall database performance.

When to use it

  • When a production database reports deadlocks and you need to quickly understand the root cause.
  • During performance testing to proactively identify and address potential deadlock scenarios before deployment.
  • To analyze slow query performance that might be related to resource contention and deadlocks.
  • After making changes to application code or database schema that could introduce new locking conflicts.

Key capabilities

  • Deadlock detection
  • Transaction analysis
  • Resource identification
  • SQL query identification
  • Resolution suggestions

Example prompts

  • "Analyze the recent database deadlock and tell me which queries were involved."
  • "I'm seeing high lock contention; can you identify any potential deadlocks?"
  • "What resources are being blocked in this transaction, and why?"

Tips & gotchas

This skill requires access to database logs or monitoring data containing deadlock information. The accuracy of the analysis depends on the completeness and quality of the provided data.