skills.rest
GDSDN
GDSDNCOMMUNITY
Explore all skills by this author →
GitHub

analyze-performance

Generate EXPLAIN ANALYZE plans and detect hotpaths in SQL queries.

3|Updated Feb 7, 2026
Search Tags:#performance#database#optimization#sql#query analysis#hotpaths
One-click install
npx skills add https://github.com/GDSDN/kord-aios --skill analyze-performance-gdsdn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: analyze-performance
Source: https://github.com/GDSDN/kord-aios/tree/main/src/features/builtin-skills/kord-aios/database/analyze-performance
Command: npx skills add https://github.com/GDSDN/kord-aios --skill analyze-performance-gdsdn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

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;'.

Frequently Asked Questions about analyze-performance

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze SQL query performance to find slow database operations?▼

You can analyze SQL query performance by generating EXPLAIN ANALYZE execution plans to identify sequential scans, table bloat, and missing indexes, receiving interactive optimization guidance to resolve slow database operations.

How do I detect database hotpaths causing high sequential scans and table bloat?▼

To detect database hotpaths, this Skill analyzes system-wide performance metrics to pinpoint slow queries, high sequential scans, and table bloat causing performance bottlenecks in your database.

Do I need psql and a Supabase DB URL to run query analysis?▼

Yes, executing query analysis requires both psql and a Supabase DB URL configured in your environment to run the EXPLAIN ANALYZE plans and system-wide performance metrics.

What is the best way to optimize database queries with missing indexes?▼

The best way to optimize database queries with missing indexes is using an interactive step-by-step process that analyzes execution plans, suggests specific indexes, and guides you through applying the query optimizations.

Can I use this Skill to find out why a specific database report is loading slowly?▼

Yes, you can use this Skill to analyze the underlying SQL query of a slow-loading report, identify missing indexes or sequential scans, and implement optimizations to speed up the data retrieval process.

Related Skills

Explore More Software Engineering Skills→
bigandslowbigandslow

Query Supabase Database

Execute PostgreSQL commands on Supabase databases using psql with 1Password credentials.

Community
Intermediate
marquesfelipmarquesfelip

database-performance

Diagnose and optimize PostgreSQL or MySQL database performance with EXPLAIN ANALYZE and indexing.

Community
Advanced
thehivegroup-aithehivegroup-ai

postgres-standards

Manage PostgreSQL schema design, migrations, and query optimization with psycopg2.

Official
Intermediate
tonone-aitonone-ai
69

flux-query

Analyze SQL execution plans and generate index recommendations and rewritten queries.

Official
Intermediate