鱼皮AI导航
鱼皮AI导航
  • 主页
  • 社区
  • AI工具
  • AI知识库
  • AI提示词
  • MCP
  • Skills
  • AI学习资源
  • AI资讯
  • GitHub开源
登录/注册

skill-adapter

具备数据库死锁的自动识别与根因分析能力,可实时监控锁竞争状态、解析事务执行路径,并输出针对性优化建议,适用于生产环境高频死锁排查及预防性运维场景。

数据库
访问 GitHub
文档Skills.MD
name
Detecting Database Deadlocks
description
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.

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

  1. Initiate Deadlock Detection: Claude recognizes the user's request related to database deadlocks and activates the database-deadlock-detector plugin.
  2. Execute Deadlock Analysis: The plugin executes the /deadlock command to analyze the database for current and potential deadlocks.
  3. 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:

  1. Activate the database-deadlock-detector plugin and run the /deadlock command.
  2. 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:

  1. Activate the database-deadlock-detector plugin and run the /deadlock command with monitoring configurations.
  2. 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.

数据库

快捷安装

复制到终端去安装 Skill

npxskillsaddjeremylongshore/claude-code-plugins-plus-skills--skill"skill-adapter"
站长:程序员鱼皮 老鱼简历 商务合作 增值电信业务经营许可证
2026 鱼皮AI导航 | 沪ICP备19026706号-6
站长:程序员鱼皮 老鱼简历 商务合作 增值电信业务经营许可证
2026 鱼皮AI导航 | 沪ICP备19026706号-6
🔥热门工具
朱雀AI检测朱雀AI检测
朱雀AI检测助手朱雀AI检测助手
LovartLovart
老鱼简历老鱼简历
WritePass官网WritePass官网
面多多面多多
CursorCursor
星月写作星月写作
朱雀AI检测助手朱雀AI检测助手
零感AI零感AI
Skills 推荐
relational-database-mcp-cloudbase
面向 CloudBase 关系型数据库的自动化管理,支持安全执行只读查询、写入与结构变更操作,并可检视及调整表级安全规则,确保在无应用上下文的代理环境中精准控制数据访问与修改权限。
database-index-advisor
通过分析数据库查询负载和现有索引配置,自动识别缺失的高效索引以加速慢查询,同时发现长期未被使用的冗余索引以便清理,从而在提升读取性能的同时节省存储空间并优化写入效率。
detecting-sql-injection-vulnerabilities
自动识别和分析应用程序代码及数据库查询中的 SQL 注入风险,覆盖输入点检测、查询构造审查、参数化验证与安全模式推荐,生成结构化安全报告并提供修复建议。
database
规范 NestJS 应用的数据访问层设计,涵盖 ORM 选型、连接池与分片等可扩展架构,强制使用仓库模式隔离数据库逻辑,通过异步配置加载敏感信息,禁用生产环境自动同步,依赖迁移脚本实现零停机演进,并统一要求分页、索引声明与事务保护。
prisma-schema-helper
提供 Prisma 数据模型定义的自动化辅助能力,涵盖模式校验、关系配置、字段类型推导及迁移脚本生成,支持 Node.js 等后端技术栈的数据库层快速搭建与维护。