db-advisor

What problem does it solve?

This Skill helps optimize PostgreSQL database performance by providing best practices for query optimization, schema design, indexing, and security.

Core Features & Use Cases

• Index Recommendations: Suggests appropriate index types (B-tree, GIN, BRIN) based on query patterns.
• Data Type Guidance: Recommends optimal data types for various use cases (IDs, strings, timestamps, money, flags).
• Pattern Examples: Demonstrates effective SQL patterns for composite indexes, covering indexes, partial indexes, Row Level Security (RLS), UPSERT, cursor pagination, and queue processing.
• Anti-Pattern Detection: Provides SQL queries to identify unindexed foreign keys, slow queries, and table bloat.
• Configuration Template: Offers a template for essential PostgreSQL configuration settings.

Quick Start

Use the db-advisor skill to get recommendations for optimizing a slow PostgreSQL query.