postgresql

When to Use

Use this skill when:

• Writing raw SQL queries for PostgreSQL
• Designing database schemas and tables
• Creating or optimizing indexes
• Working with JSONB, arrays, or composite types
• Implementing full-text search (tsvector/tsquery)
• Using PostgreSQL extensions (pg_trgm, uuid-ossp, etc.)
• Performance tuning and query optimization
• Writing stored procedures/functions
• Working with CTEs, window functions, or recursive queries
• Implementing constraints, triggers, or rules

Detailed References