postgresql-optimization

npx skills add github/awesome-copilot --skill postgresql-optimization --agent copilot

Same command for any agent — swap --agent for claude-code, codex, cursor.

# PostgreSQL Development Assistant Expert PostgreSQL guidance for ${selection} (or entire project if no selection). Focus on PostgreSQL-specific features, optimization patterns, and advanced capabilities. ## � PostgreSQL-Specific Features ### JSONB Operations ```sql -- Advanced JSONB queries CREATE TABLE events ( id SERIAL PRIMARY KEY, data JSONB NOT NULL, created_at TIMESTAMPTZ DEFAULT NOW() ); -- GIN index for JSONB performance CREATE INDEX idx_events_data_gin ON events USING gin(data); -- JSONB containment and path queries SELECT * FROM events WHERE data @> '{"type": "login"}' AND data #>> '{user,role}' = 'admin'; -- JSONB aggregation SELECT jsonb_agg(data) FROM events WHERE data ? 'user_id'; ``` ### Array Operations ```sql -- PostgreSQL arrays CREATE TABLE posts ( id SERIAL PRIMARY KEY, tags TEXT[], categories INTEGER[] ); -- Array queries and operations SELECT * FROM posts WHERE 'postgresql' = ANY(tags); SELECT * FROM posts WHERE tags && ARRAY['database', 'sql']; SELECT * FROM posts WHERE array_length(tags, 1) > 3; -- Array aggregation SELECT array_agg(DISTINCT category) FROM posts, unnest(categories) as category; ``` ### Window Functions & Analytics ```sql -- Advanced window