How do I use these PostgreSQL patterns in my workflow?

Once the skill is enabled in Claude Code, Claude will automatically reference these patterns when you ask it to write migrations, review SQL, or troubleshoot database performance issues.

Does it support advanced SQL operations like UPSERT or Pagination?

Absolutely. It provides standardized templates for efficient cursor-based pagination, conflict handling via UPSERT, and safe queue processing using FOR UPDATE SKIP LOCKED.

Is this skill specific to Supabase users?

While it incorporates Supabase's high-performance standards, the SQL patterns, data type recommendations, and optimization techniques are applicable to any standard PostgreSQL environment.

How does this skill improve PostgreSQL query performance?

It provides optimized indexing strategies—including B-tree, GIN, and BRIN—and guides Claude to identify slow query patterns and table bloat using diagnostic SQL.

Can it help with database security audits?

Yes, the skill includes patterns for implementing secure Row Level Security (RLS) and scripts to identify unindexed foreign keys which are critical for both security and performance.

PostgreSQL Best Practices & Patterns

Name: PostgreSQL Best Practices & Patterns
Author: affaan-m

byaffaan-m

•

43,117

Gestión de Bases de Datos

Optimizes PostgreSQL performance and schema design through battle-tested indexing, security, and query patterns.

Acerca de

This skill equips Claude with specialized knowledge for PostgreSQL database management, focusing on high-performance schema design and advanced query optimization. Based on industry-leading Supabase best practices, it provides instant access to indexing strategies, Row Level Security (RLS) implementation, and automated anti-pattern detection. Whether you are troubleshooting slow queries, setting up complex migrations, or configuring connection pooling, this skill ensures your database architecture follows production-ready standards and avoids common pitfalls like unindexed foreign keys or inefficient pagination.

Características Principales

High-performance SQL patterns for UPSERT, cursor pagination, and queue processing
Automated anti-pattern detection for unindexed keys and table bloat
43,117 GitHub stars
Comprehensive indexing cheat sheet for B-tree, GIN, BRIN, and Partial indexes
Performance-optimized Row Level Security (RLS) policy templates
Best-practice data type recommendations and configuration templates

Casos de Uso

Designing scalable database schemas and migration scripts for production applications
Implementing secure multi-tenant architectures using optimized Row Level Security policies
Identifying and fixing performance bottlenecks in slow SQL queries via pg_stat_statements

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code postgres-patterns

For use in Claude.ai and ChatGPT

Download Skill

GitHub