> 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 "monitor database transactions," "detect long-running transactions," "identify lock contention," "track rollback rates," or asks about "transaction anomalies." The skill leverages the `/txn-monitor` comma
curl "https://skillshub.wtf/jeremylongshore/claude-code-plugins-plus-skills/database-transaction-monitor?format=md"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-monitorplugin. - Transaction Monitoring: The plugin executes the
/txn-monitorcommand 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-monitorplugin. - Execute the
/txn-monitorcommand 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-monitorplugin. - Execute the
/txn-monitorcommand 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.
> related_skills --same-repo
> agent-context-loader
PROACTIVE AUTO-LOADING: Automatically detects and loads AGENTS.md files from the current working directory when starting a session or changing directories. This skill ensures agent-specific instructions are incorporated into Claude Code's context alongside CLAUDE.md, enabling specialized agent behaviors. Triggers automatically when Claude detects it's working in a directory, when starting a new session, or when explicitly requested to "load agent context" or "check for AGENTS.md file".
> Google Cloud Agent SDK Master
Automatic activation for ALL Google Cloud Agent Development Kit (ADK) and Agent Starter Pack operations - multi-agent systems, containerized deployment, RAG agents, and production orchestration. **TRIGGER PHRASES:** - "adk", "agent development kit", "agent starter pack", "multi-agent", "build agent" - "cloud run agent", "gke deployment", "agent engine", "containerized agent" - "rag agent", "react agent", "agent orchestration", "agent templates" **AUTO-INVOKES FOR:** - Agent creation and scaffold
> Vertex AI Media Master
Automatic activation for ALL Google Vertex AI multimodal operations - video processing, audio generation, image creation, and marketing campaigns. **TRIGGER PHRASES:** - "vertex ai", "gemini multimodal", "process video", "generate audio", "create images", "marketing campaign" - "imagen", "video understanding", "multimodal", "content generation", "media assets" **AUTO-INVOKES FOR:** - Video processing and understanding (up to 6 hours) - Audio generation and transcription - Image generation with I
> yaml-master
PROACTIVE YAML INTELLIGENCE: Automatically activates when working with YAML files, configuration management, CI/CD pipelines, Kubernetes manifests, Docker Compose, or any YAML-based workflows. Provides intelligent validation, schema inference, linting, format conversion (JSON/TOML/XML), and structural transformations with deep understanding of YAML specifications and common anti-patterns.