Can I use this for writing database migrations?

Absolutely. The skill provides standardized templates for tables, indexes, and constraints that are ideal for inclusion in migration scripts.

What is the postgres-patterns skill for Claude Code?

It is a specialized capability that provides Claude with expert knowledge on PostgreSQL database design, optimization, and security best practices.

Does it support modern Postgres features like JSONB?

Yes, it includes guidance on using GIN indexes for JSONB data and recommendations for efficient data typing.

Can this skill help with Supabase development?

Yes, many of the patterns are based on Supabase best practices, including specific optimizations for Row Level Security (RLS) and connection pooling.

How does it help improve database performance?

It provides specific index recommendations based on query patterns and includes diagnostic queries to find slow statements and table bloat.

PostgreSQL Best Practices & Patterns

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

byaffaan-m

•

112,913

•

Database Management

Optimizes PostgreSQL performance and security through expert schema design, advanced indexing strategies, and production-ready implementation patterns.

PostgreSQL Patterns is a specialized skill for Claude Code designed to streamline database development and management. Based on Supabase best practices, it provides developers with a quick-reference guide for creating efficient schemas, implementing robust Row Level Security (RLS), and choosing the right index types (B-tree, GIN, BRIN) for specific query patterns. Whether you are building a new application, troubleshooting slow queries using pg_stat_statements, or setting up secure multi-tenant access, this skill helps you avoid common anti-patterns and ensures your database is tuned for scalability and performance.

Key Features

01Advanced indexing guide covering B-tree, GIN, BRIN, and covering indexes

02Implementation patterns for cursor pagination, UPSERTs, and job queues

03Standardized data type recommendations for financial, temporal, and ID data

04Optimized Row Level Security (RLS) policy templates for multi-tenant security

05112,913 GitHub stars

06Performance troubleshooting queries to detect table bloat and missing indexes

Use Cases

01Optimizing slow-running SQL queries and identifying missing indexes

02Designing high-performance database schemas for new applications

03Implementing secure access control policies for Supabase or standard Postgres

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

Key Features

01Advanced indexing guide covering B-tree, GIN, BRIN, and covering indexes

02Implementation patterns for cursor pagination, UPSERTs, and job queues

03Standardized data type recommendations for financial, temporal, and ID data

04Optimized Row Level Security (RLS) policy templates for multi-tenant security

05112,913 GitHub stars

06Performance troubleshooting queries to detect table bloat and missing indexes

Use Cases

01Optimizing slow-running SQL queries and identifying missing indexes

02Designing high-performance database schemas for new applications

03Implementing secure access control policies for Supabase or standard Postgres