Monitoring Database Transactions

monitoring-database-transactions

This skill enables Claude to monitor database transactions for performance and lock issues using the database-transaction-monitor plugin. It is triggered when the user requests transaction monitoring, lock detection, or rollback rate analysis for databases. Use this skill when the user mentions "...

BbgnsurfTech/claude-skills-collection·0installs25stars

SKILL.md

Full skill instructions

Overview

This skill empowers Claude to proactively monitor database transactions, identify performance bottlenecks like long-running queries and lock contention, and alert on anomalies such as high rollback rates. It provides insights into database health and helps prevent performance degradation.

How It Works

Activation: The user's request triggers the database-transaction-monitor plugin.
Transaction Monitoring: The plugin executes the /txn-monitor command to initiate transaction monitoring.
Alerting: The plugin analyzes transaction data and generates alerts based on predefined thresholds for long-running transactions, lock wait times, and rollback rates.

When to Use This Skill

This skill activates when you need to:

Detect and kill long-running transactions blocking other queries.
Monitor lock wait times and identify deadlock patterns.
Track transaction rollback rates for error analysis.

Examples

Example 1: Detecting Long-Running Transactions

User request: "Find any long-running database transactions."

The skill will:

Activate the database-transaction-monitor plugin.
Execute the /txn-monitor command to identify transactions exceeding a predefined duration threshold.

Example 2: Analyzing Lock Contention

User request: "Analyze database lock contention."

The skill will:

Activate the database-transaction-monitor plugin.
Execute the /txn-monitor command to monitor lock wait times and identify deadlock patterns.

Best Practices

Threshold Configuration: Configure appropriate thresholds for long-running transactions and lock wait times to minimize false positives.
Alerting Integration: Integrate transaction alerts with existing monitoring systems for timely notification and response.
Regular Review: Regularly review transaction monitoring data to identify trends and proactively address potential performance issues.

Integration

This skill can be integrated with other monitoring and alerting tools to provide a comprehensive view of database health. It complements tools for query optimization and database schema design.

Install skill

Copy and run in your terminal

npx -y skills add https://github.com/BbgnsurfTech/claude-skills-collection --skill database-transaction-monitor

View on GitHub

plugins/claude-code-plugins-plus/backups/skill-structure-cleanup-20251108-073936/plugins/database/database-transaction-monitor/skills/database-transaction-monitor/SKILL.md

generating-api-contracts
Generate API contracts and OpenAPI specifications from code or design documents. Use when documenting API contracts and specifications. Trigger with phrases like "generate API contract", "create OpenAPI spec", or "document API contract".
0 installs
responding-to-security-incidents
Assists with security incident response, investigation, and remediation. This skill is triggered when the user requests help with incident response, mentions specific incident types (e.g., data breach, ransomware, DDoS), or uses terms like "incident response plan", "containment", "eradication", o...
0 installs
biomni
Autonomous biomedical AI agent framework for executing complex research tasks across genomics, drug discovery, molecular biology, and clinical analysis. Use this skill when conducting multi-step biomedical research including CRISPR screening design, single-cell RNA-seq analysis, ADMET prediction,...
0 installs
tracking-service-reliability
This skill enables Claude to define and track Service Level Agreements (SLAs), Service Level Indicators (SLIs), and Service Level Objectives (SLOs) for improved service reliability. It is triggered when the user needs to establish, monitor, or analyze service performance metrics. Use this skill w...
0 installs