Postgresql Optimization

This is for when you need PostgreSQL-specific features, not generic SQL. It covers the stuff that makes Postgres different: JSONB operations with GIN indexes, array types and operators, custom enums and composite types, range types with exclusion constraints, and full-text search with tsvector. The examples show actual query patterns for window functions, EXPLAIN ANALYZE workflows, and practical use of extensions like pg_trgm and uuid-ossp. It's focused on optimization and performance tuning rather than basic CRUD. If you're just writing simple queries, you don't need this. If you're leveraging Postgres as more than a MySQL clone, this gives you the advanced data types and indexing strategies that justify using Postgres in the first place.

Install to Claude Code

npx -y skills add syahiidkamil/software-engineer-ai-agent-atlas --skill postgresql-optimization --agent claude-code