跳至正文
OpenAgentSkill
浏览已开放 · 目录记录日期 2026-11-21 · 自动更新和账户服务暂时关闭。
数据与分析

query-optimization

Workflow for identifying and fixing slow database queries. Use when a query is slow or the user asks to optimize database performance.

girijashankarj · 已有静态检查记录

安装与使用

运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。

npx skills add girijashankarj/cursor-handbook --skill query-optimization

技能说明


name: query-optimization description: Workflow for identifying and fixing slow database queries. Use when a query is slow or the user asks to optimize database performance.

Skill: Optimize Database Query

Trigger

When a query is slow or user asks to optimize database performance.

Steps

Step 1: Identify Slow Query

  • Get the query text
  • Measure current execution time
  • Check query frequency (how often it runs)

Step 2: Analyze Query Plan

  • Run EXPLAIN ANALYZE on the query
  • Identify sequential scans on large tables
  • Check for missing indexes
  • Look for unnecessary joins or subqueries
  • Check sort operations (external sorts)

Step 3: Optimize

Common optimizations:

  • Add missing indexes
  • Rewrite subqueries as JOINs
  • Add WHERE clause filters to reduce data
  • Use cursor-based pagination instead of OFFSET
  • Add partial indexes for filtered queries
  • Denormalize if read performance is critical

Step 4: Benchmark

  • Run optimized query with EXPLAIN ANALYZE
  • Compare before/after execution times
  • Test with production-like data volume
  • Verify results are identical

Step 5: Implement

  • Update query in code
  • Create migration for new indexes
  • Add monitoring for the query
  • Update any affected tests

Completion

Query optimized with measurable improvement and monitoring in place.