Skills
.Work. You
Rest

debug-db-query

Community

Diagnose slow DB queries and optimize performance.

Software Engineering#performance#database#debug#mongodb#postgres#explain#query-analysis
Authorsswapnil2
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Diagnose slow or failing database queries and provide actionable debugging guidance.

Core Features & Use Cases

  • EXPLAIN (ANALYZE, BUFFERS) analysis for Postgres queries to identify slow operations and missing indexes.
  • Mongo path analysis with explain("executionStats"), looking for COLLSCAN, non-selective filters, and sort-related issues.
  • Structured fixes: recommend index changes, query rewrites, and strategies to reduce N+1 queries and lock contention.

Quick Start

Reproduce the issue in staging and run an EXPLAIN ANALYZE with realistic parameters to surface the bottlenecks.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 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: debug-db-query
Download link: https://github.com/sswapnil2/ai-config-fintech/archive/main.zip#debug-db-query

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.