db-explain
CommunityOptimize SQL query performance
AuthorGDSDN
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps identify and resolve performance bottlenecks in SQL queries by providing detailed analysis of query execution plans.
Core Features & Use Cases
- Query Plan Analysis: Runs
EXPLAIN (ANALYZE, BUFFERS)to show how PostgreSQL executes a query. - Performance Bottleneck Identification: Pinpoints issues like sequential scans, missing indexes, high buffer reads, and poor row estimates.
- Optimization Suggestions: Provides actionable advice and examples for improving query speed.
- Use Case: A user has a slow-running report query. They use
db-explainto analyze the query plan, discover a sequential scan on a large table, and then use the Skill's suggestions to create an appropriate index, significantly speeding up the report.
Quick Start
Use the db-explain skill to analyze the performance of the SQL query 'SELECT * FROM users WHERE status = 'active''.
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: db-explain Download link: https://github.com/GDSDN/kord-aios/archive/main.zip#db-explain 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.