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

•

Database Management

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.

Key Features

01Anti-pattern detection for unindexed foreign keys and table bloat

02Optimized data type recommendations for IDs, currency, and time

03Row Level Security (RLS) performance optimization templates

04Advanced SQL patterns for UPSERT, cursor pagination, and job queues

05Comprehensive indexing guide for B-tree, GIN, and BRIN types

0643,117 GitHub stars

Use Cases

01Implementing secure multi-tenant access control using Row Level Security

02Identifying and fixing slow-running SQL queries in production environments

03Designing 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