How does this skill help with database performance?

It offers a quick-reference for selecting the correct index types (like B-tree, GIN, or BRIN) and provides optimized SQL patterns such as cursor pagination to replace slow OFFSET queries.

Can it help me identify issues in my existing database?

Absolutely. The skill includes detection patterns for common issues like unindexed foreign keys, slow queries using pg_stat_statements, and excessive table bloat.

Does it provide security recommendations?

Yes, it includes patterns for secure default configurations, RLS policy optimization, and proper schema permission management.

What is the Postgres Patterns skill?

It is a specialized capability for Claude Code that provides domain-specific guidance on PostgreSQL database design, query optimization, and security best practices.

Is this skill compatible with Supabase?

Yes, many of the patterns and best practices included are based on Supabase's recommended standards, particularly for Row Level Security (RLS) and efficient schema design.

PostgreSQL Optimization Patterns

Name: PostgreSQL Optimization Patterns
Author: affaan-m

byaffaan-m

•

43,117

데이터베이스 관리

Optimizes PostgreSQL database schemas, queries, and security using battle-tested industry patterns and Supabase best practices.

소개

This skill provides a comprehensive toolkit for PostgreSQL database development, focusing on performance optimization, schema design, and security. It offers quick-reference guides for index selection, data type choices, and common SQL patterns like UPSERTs and cursor pagination. Designed to help developers write efficient migrations and troubleshoot slow queries, it integrates advanced strategies such as Row Level Security (RLS) optimization and anti-pattern detection to ensure robust and scalable database architecture.

주요 기능

Anti-pattern detection for unindexed foreign keys and table bloat
Optimized data type recommendations for IDs, currency, and time
Row Level Security (RLS) performance optimization templates
Advanced SQL patterns for UPSERT, cursor pagination, and job queues
Comprehensive indexing guide for B-tree, GIN, and BRIN types
43,117 GitHub stars

사용 사례

Implementing secure multi-tenant access control using Row Level Security
Identifying and fixing slow-running SQL queries in production environments
Designing a performant database schema for a new high-traffic application

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

소개