monitoring-database-transactions

Detect long-running database transactions and lock contention issues.

Updated Aug 23, 2026

Search Tags:#performance #monitoring #SQL #rollback #database #transactions #locks

One-click install

npx skills add https://github.com/GaloSerranoA/GALOGPT --skill monitoring-database-transactions-galoserranoa

Or copy as Structured Prompt for Agent▼

Please help me install this Agent Skill.
Skill: monitoring-database-transactions
Source: https://github.com/GaloSerranoA/GALOGPT/tree/main/AI_Brain/skills/available_skills/claude-code-plugins-plus/plugins/database/database-transaction-monitor/skills/database-transaction-monitor
Command: npx skills add https://github.com/GaloSerranoA/GALOGPT --skill monitoring-database-transactions-galoserranoa

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This skill automates the detection of database performance bottlenecks like long-running transactions and lock contention, preventing system slowdowns and ensuring database stability. It eliminates the need for manual, reactive monitoring, saving critical time in identifying and resolving performance issues.

Core Features & Use Cases

Real-time Transaction Monitoring: Continuously track database transactions for performance and lock issues.
Anomaly Detection: Identify long-running queries, lock contention, and high rollback rates.
Database Health Insights: Provides alerts and insights into potential database health degradation.
Use Case: Automatically detect a transaction that has been running for over 5 minutes, immediately alerting you to a potential bottleneck that could impact application responsiveness.

Quick Start

Ask Claude to "Find any long-running database transactions" to trigger the skill and identify transactions exceeding predefined duration thresholds.