diagnose-slow-query
Diagnose database slow queries, unindexed sequential scans, lock wait contentions, and query execution plan regressions.
Skill by Swastik023
Install
Works with Claude Code, Claude apps, Codex, Cursor, Gemini CLI, GitHub Copilot, VS Code, OpenCode, Goose, Windsurf. Read the repository before you give any tool access to your data.
npx agentmarket install skill/swastik023-diagnose-slow-query
Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.
Get the weekly diff
The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.
About
Use cases: backend
Reviews
Write a reviewNo reviews yet. Installed it? Reviews come from verified installers only. How reviews work
Permissions
What this skill can do and what it asks for, from its SKILL.md. Checked Oct 25, 2026.
- Tools
- No tools found
- Secrets
- None asked for
- Install scripts
- None found
Network hosts it talks to 1
codeload.github.com· found in install command
Files it touches
~/.claude/skills/diagnose-slow-query
What's inside
- Skill name
diagnose-slow-query- Description
- Diagnose database slow queries, unindexed sequential scans, lock wait contentions, and query execution plan regressions.
- License
- unknown
- Instructions
- 19 lines in SKILL.md · view on GitHub
Files (9)
- SKILL.md
- capability.yaml
- evaluation.yaml
- inputs.yaml
- manifest.yaml
- outputs.yaml
- permissions.yaml
- provenance.yaml
- verification.yaml
The license isn't open source, so the instructions aren't shown here. Read SKILL.md on GitHub
More from Swastik023/kubernetes-sre-incident-platform
- 0.516score
diagnose-deadlock
Swastik023
Diagnose PostgreSQL table deadlocks, transaction lock contention chains, blocked backend PIDs, and conflicting lock modes.
SkillBFreshness: BClaude Code +9 - 0.516score
diagnose-replication-lag
Swastik023
Diagnose PostgreSQL physical and logical streaming replication lag, WAL sender stalls, network saturation, and replay bottlenecks on read replicas.
SkillBFreshness: BClaude Code +9 - 0.516score
diagnose-crashloop
Swastik023
Diagnose Kubernetes Pod CrashLoopBackOff incidents, identify root causes (OOMKilled, configuration error, exit code failures, liveness probe failure), and…
SkillBFreshness: BClaude Code +9 - 0.516score
diagnose-oom
Swastik023
Diagnose Kubernetes Out-Of-Memory (OOMKilled) events, evaluate container memory limits against working set spikes, and formulate evidence-backed scaling…
SkillBFreshness: BClaude Code +9 - 0.516score
diagnose-pending
Swastik023
Diagnose Kubernetes Pending Pods and Unschedulable failures caused by node CPU/memory exhaustion, taints/tolerations, affinity constraints, or…
SkillBFreshness: BClaude Code +9 - 0.516score
detect-privilege-escalation
Swastik023
Detect container privilege escalation, root UID execution, dangerous Linux capabilities (CAP_SYS_ADMIN), and host namespace mounting.
SkillBFreshness: BClaude Code +9 - 0.516score
diagnose-connection-pool
Swastik023
Diagnose database connection pool saturation, idle-in-transaction leaks, max connection breaches, and client-side pool queuing delays.
SkillBFreshness: BClaude Code +9 - 0.513score
diagnose-mtu-packet-loss
Swastik023
Diagnose Kubernetes CNI MTU mismatch, IPsec/Geneve tunnel overhead fragmentation, and silent TCP packet drop.
SkillBFreshness: BClaude Code +9 - 0.513score
diagnose-disk-pressure
Swastik023
Diagnose Kubernetes node DiskPressure condition, container rootfs volume exhaustion, and inode depletion.
SkillBFreshness: BClaude Code +9 - 0.513score
diagnose-cpu-throttling
Swastik023
Diagnose Linux cgroup CFS quota CPU throttling, micro-burst latency spikes, and CPU limit misconfigurations.
SkillBFreshness: BClaude Code +9 - 0.512score
analyze-terraform-plan
Swastik023
Analyze Terraform plan JSON for destructive resource changes, blast radius estimation, security group drift, and unexpected infrastructure mutations.
SkillBFreshness: BClaude Code +9 - 0.511score
diagnose-probe-failure
Swastik023
Diagnose Kubernetes Liveness, Readiness, and Startup probe timeouts or HTTP 5xx errors, and evaluate timeout vs application latency profiles.
SkillBFreshness: BClaude Code +9
Signals
- Stars
- 0
- Forks
- 0
- Open issues
- 0
- Last commit (this folder)
- Sep 9, 2026 (1 month ago)
From GitHub (fetched Oct 24, 2026).
Details
- License
- License unknown
- First seen
- Oct 24, 2026
- Last checked
- Oct 24, 2026
- Source
- GitHubgithub-graphql
More from Swastik023
- 0.516score
diagnose-pending
Swastik023
Diagnose Kubernetes Pending Pods and Unschedulable failures caused by node CPU/memory exhaustion, taints/tolerations, affinity constraints, or…
SkillBFreshness: BClaude Code +9 - 0.516score
diagnose-deadlock
Swastik023
Diagnose PostgreSQL table deadlocks, transaction lock contention chains, blocked backend PIDs, and conflicting lock modes.
SkillBFreshness: BClaude Code +9 - 0.516score
diagnose-crashloop
Swastik023
Diagnose Kubernetes Pod CrashLoopBackOff incidents, identify root causes (OOMKilled, configuration error, exit code failures, liveness probe failure), and…
SkillBFreshness: BClaude Code +9 - 0.516score
diagnose-replication-lag
Swastik023
Diagnose PostgreSQL physical and logical streaming replication lag, WAL sender stalls, network saturation, and replay bottlenecks on read replicas.
SkillBFreshness: BClaude Code +9 - 0.516score
diagnose-oom
Swastik023
Diagnose Kubernetes Out-Of-Memory (OOMKilled) events, evaluate container memory limits against working set spikes, and formulate evidence-backed scaling…
SkillBFreshness: BClaude Code +9 - 0.516score
detect-privilege-escalation
Swastik023
Detect container privilege escalation, root UID execution, dangerous Linux capabilities (CAP_SYS_ADMIN), and host namespace mounting.
SkillBFreshness: BClaude Code +9
Cite this page
diagnose-slow-query skill. Agent Mart. https://agentmart.dev/skills/swastik023-diagnose-slow-query (last updated 2026-10-24)