Postgresql Slow Query Analyzer

Quality score: 70/100 · Category: Engineering · Sub-category: databases

cloud:supabase

Queries pg_stat_statements and pg_stat_activity to surface the top slow queries by total execution time, mean latency, and call frequency. Runs EXPLAIN ANALYZE on worst offenders and suggests index additions, rewrite candidates, or vacuum triggers. Works on RDS and Supabase.

What this skill does

Postgresql Slow Query Analyzer is a production-ready Claude Code skill (quality score 70/100) in the databases sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/postgresql-slow-query-analyzer/ and loads when your prompt matches the skill's trigger.

Who uses this skill

The Postgresql Slow Query Analyzer skill is built for software engineers, backend developers, full-stack teams, and technical leads building and maintaining production systems. It is part of the open ClaudSkills registry, a community-curated catalog of 15,000+ capabilities you can install for Claude Code — the Claude CLI agent.

How to install

Free

Manual install (2 steps)

mkdir -p ~/.claude/skills/postgresql-slow-query-analyzer
curl -L https://claudskills.com/skills/postgresql-slow-query-analyzer/SKILL.md \
  -o ~/.claude/skills/postgresql-slow-query-analyzer/SKILL.md

Or just download SKILL.md directly and drop it into ~/.claude/skills/postgresql-slow-query-analyzer/. Claude Code auto-discovers it on next session.

Skills live at ~/.claude/skills/postgresql-slow-query-analyzer/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\postgresql-slow-query-analyzer\SKILL.md on Windows. See the full install guide for step-by-step instructions.

Pro

One-click install via the desktop app

The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.

More Engineering skills

Browse all Engineering skills in the ClaudSkills registry, or explore these top-rated picks from the same category:

Browse all Engineering skills → Top 100 skills

Part of ClaudSkills — the open registry for Claude Code skills. · What's New · Install guide · About · llms.txt

Part of Acreator Store — Adam Lankamer's AI tools: GifPerfect · AspectPerfect · SlomoPerfect · Ucaption · UTagger · AutoXPoster · TestYourSkills