postgres-indexes

What problem does it solve?

This Skill helps developers and database administrators create, optimize, and maintain efficient indexes for PostgreSQL databases, leading to faster query performance and reduced resource consumption.

Core Features & Use Cases

• Index Type Guidance: Provides SQL examples for various index types (B-tree, Hash, GIN, GiST, BRIN) and their optimal use cases.
• Advanced Indexing: Demonstrates partial, expression, and covering indexes for specific query needs.
• Maintenance & Analysis: Offers SQL queries to analyze index usage, detect duplicates, identify bloat, and perform concurrent operations.
• Use Case: A developer needs to speed up slow SELECT queries on a large orders table. This Skill provides the exact SQL commands to create appropriate indexes (e.g., on user_id and created_at) and analyze the query plan to confirm the improvement.

Quick Start

Use the postgres-indexes skill to generate a B-tree index on the 'email' column of the 'users' table.