postgres-optimization
PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling
Profile →npx skills add rohitg00/awesome-claude-code-toolkit --skill postgres-optimization --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# PostgreSQL Optimization ## Index Strategies ```sql -- B-tree index for equality and range queries (default) CREATE INDEX idx_orders_customer_id ON orders (customer_id); -- Composite index (column order matters: equality columns first, range last) CREATE INDEX idx_orders_status_created ON orders (status, created_at DESC); -- Partial index (smaller, faster for filtered queries) CREATE INDEX idx_orders_pending ON orders (created_at) WHERE status = 'pending'; -- Covering index (avoids table lookup entirely) CREATE INDEX idx_users_email_name ON users (email) INCLUDE (name, avatar_url); -- GIN index for JSONB containment queries CREATE INDEX idx_products_metadata ON products USING GIN (metadata); -- GiST index for full-text search CREATE INDEX idx_articles_search ON articles USING GiST ( to_tsvector('english', title || ' ' || body) ); -- Concurrent index creation (no table lock) CREATE INDEX CONCURRENTLY idx_large_table_col ON large_table (col); ``` ## Reading Query Plans ```sql EXPLAIN (ANALYZE, BUFFERS, FORMAT TEXT) SELECT o.id, o.total, u.name FROM orders o JOIN users u ON o.user_id = u.id WHERE o.status = 'shipped' AND o.created_at > NOW() - INTERVAL '30 days' ORDER BY o.created_at
- Index Strategies
- Reading Query Plans
- Partitioning
- JSONB Operations
- Connection Pooling
- Common Tuning Parameters
- Anti-Patterns
- Checklist
What does the postgres-optimization skill do?
PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling
How do I install it?
Run `npx skills add rohitg00/awesome-claude-code-toolkit --skill postgres-optimization --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From rohitg00/awesome-claude-code-toolkit, a repository with 2,438 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.