postgres-patterns

Boundary

This skill provides PostgreSQL database patterns for query optimization, schema design, indexing, and security. It focuses on PostgreSQL best practices, Supabase patterns, and performance optimization. It does NOT cover other databases (MySQL, MongoDB, etc.) or general database theory (those have dedicated skills).

When to use

Use this skill when:

• Writing SQL queries or migrations
• Designing database schemas
• Troubleshooting slow queries
• Implementing Row Level Security (RLS)
• Configuring connection pooling
• Creating indexes for performance
• Optimizing PostgreSQL queries

DO NOT use this skill for:

• Other database systems (MySQL, MongoDB, etc.) - use database-specific skills
• General database theory - use algorithm-pro or data-analysis-pro skills
• ORM-specific patterns - use those specific skills (prisma-postgres, typeorm, etc.)