postgres-patterns
A comprehensive guide and SQL pattern library for PostgreSQL optimization, indexing, and best practices.
Install
npx skills add https://github.com/affaan-m/everything-claude-code --skill postgres-patternsStats
| Total installs | 2,387 |
| Weekly installs | 2.4K |
| GitHub stars | 112.5K |
| First seen | Jan 26, 2026 |
| Source | @affaan-m/everything-claude-code |
Summary
- Covers six index types with specific use cases: B-tree for equality/range queries, composite for multi-column filters, GIN for JSONB and full-text search, and BRIN for time-series data
- Includes data type guidance (bigint for IDs, text over varchar, timestamptz for timestamps, numeric for money) and anti-pattern detection queries for unindexed foreign keys and slow queries
- Provides ready-to-use SQL patterns for covering indexes, partial indexes, cursor pagination, UPSERT, queue processing, and Row Level Security policies
- Configuration template covers connection limits, timeouts, monitoring setup, and security defaults
Tags
Related skills
| Skill | Installs | vs postgres-patterns |
|---|---|---|
| prisma-cli | 2,717 | +330 |
| clerk-webhooks | 2,725 | +338 |
| agents-sdk | 2,494 | +107 |
| langgraph-persistence | 2,629 | +242 |
| fastapi | 1,967 | -420 |
FAQ
- How many installs does postgres-patterns have?
- postgres-patterns has 2,387 total installs and 2.4K installs this week.
- Where is postgres-patterns hosted?
- postgres-patterns is published by @affaan-m/everything-claude-code at https://github.com/affaan-m/everything-claude-code.
- How many GitHub stars does postgres-patterns have?
- postgres-patterns has 112.5K GitHub stars.
- When was postgres-patterns first indexed?
- OrangeBot.AI first indexed postgres-patterns on Jan 26, 2026.
- How do I install postgres-patterns?
- Run: npx skills add https://github.com/affaan-m/everything-claude-code --skill postgres-patterns