triaging-live-sql-activity
OfficialTriages live SQL activity to fix slow clusters.
Authorcockroachlabs
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Diagnoses live cluster performance issues by identifying currently active long-running queries, busy sessions, and active transactions using SQL-only interfaces (SHOW statements and crdb_internal views) to provide immediate triage without requiring DB Console, HTTP endpoints, or Prometheus access.
Core Features & Use Cases
- Identify long-running queries, active sessions, and in-progress transactions to quickly triage performance bottlenecks.
- Drill down by application, user, or client to locate root causes and take corrective action.
- Use safe, read-only diagnostic queries by default, with optional cancellation commands for qualified operators.
Quick Start
Run the triage queries to list current statements and sessions, then identify long-running queries and in-progress transactions.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: triaging-live-sql-activity Download link: https://github.com/cockroachlabs/cockroachdb-skills/archive/main.zip#triaging-live-sql-activity Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.