PostgreSQL Skill

Expert guidance for PostgreSQL database design, optimization, and advanced features including pgvector for AI embeddings.

Triggers

Use this skill when:

• Designing PostgreSQL database schemas or normalization
• Creating indexes (B-tree, GIN, GiST, BRIN)
• Working with pgvector for AI embeddings and similarity search
• Implementing JSON/JSONB operations
• Building full-text search functionality
• Writing window functions, CTEs, or recursive queries
• Tuning PostgreSQL performance
• Implementing table partitioning
• Setting up backup and restore procedures
• Keywords: postgresql, postgres, pgvector, jsonb, full-text search, database indexing, sql optimization, partitioning, cte

Table of Contents