How does this help with database reliability?

By identifying anomalies like high rollback rates or blocking transactions early, developers can resolve performance issues before they cause system downtime.

Can I set custom thresholds for alerts?

Yes, the skill is designed to allow threshold configuration for long-running transactions and lock waits to minimize false positives.

What databases are supported by this skill?

This skill functions with any database integrated with the database-transaction-monitor plugin, typically covering common SQL environments.

How does this skill detect database locks?

It executes the /txn-monitor command to analyze lock wait times and identify specific patterns that indicate deadlock or heavy contention.

Database Transaction Monitor

Name: Database Transaction Monitor
Author: BbgnsurfTech

byBbgnsurfTech

•

Analíticas y Monitorización

Monitors database health by identifying long-running transactions, lock contention, and transaction anomalies in real-time.

The Database Transaction Monitor skill equips Claude with the ability to proactively observe database performance, detecting critical bottlenecks before they impact production. By leveraging specialized commands, it identifies long-running queries that may block other operations, tracks lock wait times to prevent deadlocks, and monitors rollback rates for error trend analysis. This skill is essential for DBAs and developers who need real-time insights into database health and automated alerting for transaction-related performance degradation.

Características Principales

01Real-time transaction monitoring via the /txn-monitor command

02Detection and identification of long-running transactions

03Rollback rate tracking for error analysis

04Proactive alerting based on predefined performance thresholds

053 GitHub stars

06Lock contention and deadlock pattern analysis

Casos de Uso

01Troubleshooting database performance issues related to lock waits

02Terminating long-running transactions that are blocking production resources

03Investigating sudden spikes in transaction rollback rates to find errors

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection database-transaction-monitor

For use in Claude.ai and ChatGPT

Características Principales

01Real-time transaction monitoring via the /txn-monitor command

02Detection and identification of long-running transactions

03Rollback rate tracking for error analysis

04Proactive alerting based on predefined performance thresholds

053 GitHub stars

06Lock contention and deadlock pattern analysis

Casos de Uso

01Troubleshooting database performance issues related to lock waits

02Terminating long-running transactions that are blocking production resources

03Investigating sudden spikes in transaction rollback rates to find errors

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection database-transaction-monitor

For use in Claude.ai and ChatGPT