What PostgreSQL index types does this skill support?

It provides comprehensive patterns for B-tree, Hash, GIN (for arrays and JSONB), GiST (for spatial and full-text search), and BRIN indexes for large datasets.

How does this skill help with database performance tuning?

The skill includes guidance on query plan analysis, using EXPLAIN ANALYZE, and implementing partial or covering indexes to minimize disk I/O.

Can I use this skill to manage index bloat?

Yes, it includes specialized SQL queries to detect index bloat and duplicate indexes, along with commands to reindex concurrently.

Does it support zero-downtime database changes?

Absolutely. It prioritizes concurrent operations (CREATE INDEX CONCURRENTLY) to ensure that indexing tasks do not lock tables or interrupt production traffic.

PostgreSQL Indexing Specialist

Name: PostgreSQL Indexing Specialist
Author: bradtaylorsf

bybradtaylorsf

•

Database Management

Optimizes PostgreSQL database performance by implementing advanced indexing strategies and maintenance patterns.

The PostgreSQL Indexing Specialist skill provides Claude with a comprehensive knowledge base for designing, implementing, and maintaining high-performance PostgreSQL indexes. It covers standard B-tree indexes alongside specialized types like GIN, GiST, and BRIN, as well as optimization techniques including partial, expression, and covering indexes. This skill is essential for developers aiming to reduce query latency, manage index bloat, and ensure efficient data retrieval across complex relational and document-based datasets.

Key Features

01Optimization through partial, expression, and multi-column compound indexes

02Implementation of advanced index types including GIN, GiST, BRIN, and Hash

03Performance tuning via covering indexes and index-only scan patterns

04Automated maintenance scripts for detecting unused indexes and index bloat

05Concurrent operation patterns for zero-downtime index management

066 GitHub stars

Use Cases

01Performing routine database maintenance and index cleanup without table locking

02Optimizing slow SQL queries in large-scale production databases

03Implementing efficient full-text search and JSONB indexing for modern applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bradtaylorsf/alphaagent-team postgres-indexes

For use in Claude.ai and ChatGPT

Download Skill