PostgreSQL best practices for indexing, schema design, query optimization, and security.
Create detailed user stories, acceptance criteria, and feature specs
Example: Generate user stories for 'password reset feature' with acceptance criteria, edge cases, and test scenarios
Reduce spec writing time by 50%, ensure comprehensive coverage
Research competitors, compare features, identify gaps
Example: Analyze 5 competitor products, create feature comparison matrix, suggest differentiation opportunities
Complete competitive research in 2 hours instead of 2 days
Evaluate features using frameworks (RICE, ICE, Kano) and create prioritized backlogs
Example: Score 20 feature ideas using RICE framework, generate prioritized roadmap with rationale
Make data-driven prioritization decisions faster
Draft PRDs, status updates, and stakeholder presentations
Example: Create executive summary of Q3 roadmap, monthly progress report, feature launch announcement
Save 3-5 hours/week on communication overhead
Submit your Claude Code skill and start earning
epx add affaan-m/everything-claude-code --skill postgres-patternsCompatible with
Supported agents
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 SQ
AI-first code editor with Composer
Before installing skills in Cursor, ensure your development environment meets these requirements:
node --versionpostgres-patternsExecute the skills CLI command in your project's root directory to begin installation:
epx add affaan-m/everything-claude-code --skill postgres-patternsFetches postgres-patterns from affaan-m/everything-claude-code and configures it for Cursor.
The CLI shows a list of agents. Use arrow keys and space to select Cursor:
Confirm successful installation by checking the skill directory location:
.cursor/skills/postgres-patterns
Restart Cursor to activate postgres-patterns. Access via /postgres-patternsin your agent's command palette.
Learn more:View source on GitHubSkills CLI docsAbout CursorWhat are agent skills?
Time estimate: 30-60 minutes to see productivity improvements
Prerequisites
Steps
Common Pitfalls
✓ Do
✗ Don't
💡 Pro Tips
✓ Use when
Use for user story writing, competitive research, roadmap prioritization, stakeholder communication, and PRD drafting. Best for reducing repetitive documentation and research work.
✗ Avoid when
Avoid for strategic product vision (requires deep customer empathy), pricing decisions (needs market and financial expertise), or when face-to-face customer discovery is more valuable than speed.
video-editing
affaan-m/everything-claude-code · Video · same repo
grill-me
mattpocock/skills · Productivity · same category
roblox-game-development
greedychipmunk/agent-skills · Productivity · same category
write-a-prd
mattpocock/skills · Productivity · same category
framer-motion
pproenca/dot-skills · Productivity · same category
pagespeed-insights
enderpuentes/ai-agent-skills · Productivity · same category
postgres-patterns has been reliable in day-to-day use. Documentation quality is above average for community skills.
I recommend postgres-patterns for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.
Keeps context tight: postgres-patterns is the kind of skill you can hand to a new teammate without a long onboarding doc.
Registry listing for postgres-patterns matched our evaluation — installs cleanly and behaves as described in the markdown.
I recommend postgres-patterns for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.
postgres-patterns reduced setup friction for our internal harness; good balance of opinion and flexibility.
postgres-patterns has been reliable in day-to-day use. Documentation quality is above average for community skills.
Keeps context tight: postgres-patterns is the kind of skill you can hand to a new teammate without a long onboarding doc.
Registry listing for postgres-patterns matched our evaluation — installs cleanly and behaves as described in the markdown.
postgres-patterns reduced setup friction for our internal harness; good balance of opinion and flexibility.
showing 1-10 of 38