Skills
.Work. You
Rest

analyze-performance

Community

Optimize database query performance.

Software Engineering#performance#database#optimization#sql#query analysis#hotpaths
AuthorGDSDN
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps identify and resolve performance bottlenecks in database queries, ensuring faster and more efficient data retrieval.

Core Features & Use Cases

  • Query Analysis: Provides detailed execution plans for specific SQL queries using EXPLAIN ANALYZE.
  • Hotpaths Detection: Analyzes system-wide performance metrics to pinpoint slow queries, high sequential scans, and table bloat.
  • Interactive Optimization: Guides users through a step-by-step process to analyze, suggest, and implement query optimizations.
  • Use Case: A developer notices a specific report is loading slowly. They use this Skill to analyze the underlying query, identify missing indexes, and then implement them to speed up the report.

Quick Start

Use the analyze-performance skill to analyze the performance of the query 'SELECT * FROM users;'.

Dependency Matrix

Required Modules

None required

Components

scripts

💻 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: analyze-performance
Download link: https://github.com/GDSDN/kord-aios/archive/main.zip#analyze-performance

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 223,000+ vetted skills library on demand.