Skills
.Work. You
Rest

db-analyze-hotpaths

Community

Optimize database query performance.

Software Engineering#performance#query optimization#indexing#database#postgresql#sql
AuthorGDSDN
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill identifies and helps resolve performance bottlenecks in database queries, ensuring faster application response times and efficient resource utilization.

Core Features & Use Cases

  • Query Analysis: Runs EXPLAIN ANALYZE on critical queries to understand execution plans and resource usage.
  • Index Recommendations: Leverages index_advisor (Supabase) to suggest optimal indexes for performance gains.
  • Performance Reporting: Generates detailed Markdown reports summarizing findings and recommended actions.
  • Use Case: A web application is experiencing slow load times. This Skill can analyze the slowest database queries, pinpoint inefficient joins or missing indexes, and provide actionable steps to improve performance.

Quick Start

Use the db-analyze-hotpaths skill to analyze the top 20 slowest queries in your database.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

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

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.