postgresql-query-opt
CommunityOptimize PostgreSQL queries for speed.
Authorsraloff
Version1.0.0
Installs0
System Documentation
What problem does it solve?
PostgreSQL performance bottlenecks are common; this skill helps you analyze queries, interpret explain plans, and design effective indexes to speed up workloads.
Core Features & Use Cases
- Query plan analysis and EXPLAIN interpretation to identify bottlenecks.
- Index strategy guidance (B-Tree, GIN, partial, covering) for common patterns.
- Practical patterns for writing fast queries and avoiding anti-patterns in large schemas.
- Use Case: When a slow query against a large orders table is observed, apply this skill to implement appropriate indexing and query rewrites to reduce response time.
Quick Start
Provide a slow query sample or plan, and this skill will output optimized indexing and rewriting recommendations.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 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: postgresql-query-opt Download link: https://github.com/sraloff/gravityboots/archive/main.zip#postgresql-query-opt Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.