Which databases are supported by this skill?

This skill provides specialized monitoring logic for PostgreSQL, MySQL, and MongoDB, using native tools like psql, mysql, and mongosh.

Can this skill help with database locking issues?

Yes, it includes specific queries to identify lock contention, showing which sessions are blocking others and providing steps to resolve the conflict.

What permissions are required to use this skill?

The skill requires database credentials with access to system views like pg_stat_activity (PostgreSQL), information_schema (MySQL), or currentOp (MongoDB).

How does it monitor transaction throughput?

It samples commit and rollback status variables at regular intervals to calculate transactions per second and the overall rollback ratio.

Does it support automated remediation?

Yes, it can generate scripts to automatically terminate safe-to-kill idle sessions or log long-running transactions for further analysis.

Database Transaction Monitor

Name: Database Transaction Monitor
Author: jeremylongshore

byjeremylongshore

•

1,901

•

分析与监控

Monitors and optimizes real-time database transactions to detect performance bottlenecks, lock contention, and throughput anomalies.

This skill provides comprehensive observability for multi-engine database environments, enabling developers to track active transactions across PostgreSQL, MySQL, and MongoDB. It automates the detection of long-running queries, identifies 'idle in transaction' sessions that cause lock contention, and monitors throughput metrics to maintain system health. By providing specialized query patterns and remediation scripts, it helps teams troubleshoot connection leaks, resolve deadlocks, and establish robust alerting for production database clusters.

主要功能

01Multi-database support for PostgreSQL, MySQL, and MongoDB system catalogs

02Real-time detection of long-running queries and idle-in-transaction sessions

031,901 GitHub stars

04Automated alerting thresholds for rollback ratios and transaction duration

05Advanced lock contention analysis to identify blocking and blocked PIDs

06Generation of health reports and automated session remediation scripts

使用场景

01Diagnosing connection leaks in web applications by identifying stale sessions

02Resolving database performance degradation caused by lock contention during peak traffic

03Monitoring post-deployment transaction health to detect high rollback rates

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills monitoring-database-transactions

For use in Claude.ai and ChatGPT

主要功能

01Multi-database support for PostgreSQL, MySQL, and MongoDB system catalogs

02Real-time detection of long-running queries and idle-in-transaction sessions

031,901 GitHub stars

04Automated alerting thresholds for rollback ratios and transaction duration

05Advanced lock contention analysis to identify blocking and blocked PIDs

06Generation of health reports and automated session remediation scripts

使用场景

01Diagnosing connection leaks in web applications by identifying stale sessions

02Resolving database performance degradation caused by lock contention during peak traffic

03Monitoring post-deployment transaction health to detect high rollback rates

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills monitoring-database-transactions

For use in Claude.ai and ChatGPT