🎯

postgres-patterns

🎯Skill

from affaan-m/everything-claude-code

What it does

Provides reusable SQL query patterns, database design strategies, and performance optimization techniques for PostgreSQL development

Overview

Postgres Patterns is a skill from the affaan-m/everything-claude-code collection that provides reusable SQL query patterns, database design strategies, and performance optimization techniques for PostgreSQL. It helps AI agents generate efficient, well-structured database code.

Key Features

Reusable PostgreSQL SQL query patterns and templates
Database schema design strategies and normalization guidance
Query performance optimization techniques
Best practices for PostgreSQL development

Who is this for?

This skill is for developers working with PostgreSQL who want AI-generated SQL and schema designs that follow best practices. It is useful for backend developers, database administrators, and anyone building data-intensive applications with PostgreSQL.

📦

Same repository

affaan-m/everything-claude-code(89 items)

postgres-patterns

Installation

Vibe Index InstallInstalls to .claude/skills/ - auto-recognized by Claude Code

npx vibeindex add affaan-m/everything-claude-code --skill postgres-patterns

skills.sh Install⚠ Installs to .agents/skills/ - may not be auto-recognized by Claude Code

npx skills add affaan-m/everything-claude-code --skill postgres-patterns

Manual InstallCopy SKILL.md content and save to the path below

~/.claude/skills/postgres-patterns/SKILL.md

SKILL.md

1,537Installs

38,892

AddedJan 31, 2026

View on GitHub Back to Skills

More from this repository10

🏪

affaan-m-everything-claude-code🏪Marketplace

Battle-tested Claude Code configurations from an Anthropic hackathon winner

🎯

backend-patterns🎯Skill

Implements robust backend design patterns like repository, factory, singleton, and dependency injection for scalable and maintainable server-side architectures.

🎯

coding-standards🎯Skill

Validates and enforces consistent code quality, style guidelines, and best practices across programming languages and project structures.

🎯

golang-patterns🎯Skill

Provides reusable design patterns and idiomatic Go solutions for efficient, scalable, and maintainable software architecture.

🎯

frontend-patterns🎯Skill

Provides reusable React component patterns like composition, compound components, and render props to enhance code modularity and flexibility.

🎯

security-review🎯Skill

Validates and secures code by providing comprehensive security checks for authentication, input handling, secrets management, and sensitive feature implementation.

🎯

golang-testing🎯Skill

Streamlines Go testing with comprehensive unit, integration, and benchmark strategies, mocking frameworks, and test coverage analysis.

🎯

tdd-workflow🎯Skill

Enforces test-driven development by guiding developers to write comprehensive tests first, ensuring 80%+ code coverage across unit, integration, and E2E testing.

🎯

continuous-learning-v2🎯Skill

Dynamically updates and refines AI model knowledge through iterative feedback, adaptive learning techniques, and intelligent knowledge integration.

🎯

springboot-patterns🎯Skill

Spring Boot development patterns skill covering REST API design, layered service architecture, data access, caching, async processing, and logging for production-grade Java services