Does it support advanced SQL operations?

Yes, it includes patterns for complex operations such as 'FOR UPDATE SKIP LOCKED' for job queues and O(1) cursor-based pagination.

Is this skill only for Supabase users?

No. While it leverages Supabase's high-performance best practices, the SQL patterns and optimization strategies are applicable to any standard PostgreSQL database.

How does this skill improve PostgreSQL performance?

It provides Claude with specialized knowledge on when to use specific index types (like GIN for JSONB or BRIN for time-series) and how to detect common anti-patterns like unindexed foreign keys.

Can this skill help with database security?

Yes, it includes optimized templates for Row Level Security (RLS) and security-focused configuration defaults like revoking public schema access.

PostgreSQL Patterns & Best Practices

Name: PostgreSQL Patterns & Best Practices
Author: xu-xiang

byxu-xiang

•

323

•

Database Management

Optimizes PostgreSQL databases with production-ready patterns for indexing, schema design, and security based on Supabase best practices.

This skill provides Claude with a comprehensive reference for PostgreSQL development, covering everything from performance-oriented indexing strategies and data type selection to advanced Row Level Security (RLS) policies and anti-pattern detection. Based on Supabase's proven architectural standards, it helps developers write more efficient SQL, design scalable schemas, and implement secure data access layers. It is particularly useful when performing database migrations, troubleshooting slow queries, or architecting backend services within the Claude Code environment.

Key Features

01323 GitHub stars

02Optimized SQL patterns for Upserts, Cursor Pagination, and Job Queues

03Production-grade configuration templates for connection limits and timeouts

04Comprehensive indexing guide covering B-tree, GIN, BRIN, and composite indexes

05Performance-tuned Row Level Security (RLS) policy templates

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

Use Cases

01Troubleshooting and optimizing slow-running SQL queries or migrations

02Designing secure multi-tenant database schemas with optimized RLS

03Implementing high-performance indexing for JSONB and time-series data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xu-xiang/everything-claude-code-zh postgres-patterns

For use in Claude.ai and ChatGPT

Key Features

01323 GitHub stars

02Optimized SQL patterns for Upserts, Cursor Pagination, and Job Queues

03Production-grade configuration templates for connection limits and timeouts

04Comprehensive indexing guide covering B-tree, GIN, BRIN, and composite indexes

05Performance-tuned Row Level Security (RLS) policy templates

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

Use Cases

01Troubleshooting and optimizing slow-running SQL queries or migrations

02Designing secure multi-tenant database schemas with optimized RLS

03Implementing high-performance indexing for JSONB and time-series data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xu-xiang/everything-claude-code-zh postgres-patterns

For use in Claude.ai and ChatGPT