Does it handle complex query patterns?

Yes, it provides templates for advanced database operations such as cursor pagination, UPSERTs, and transactional queue processing using SKIP LOCKED.

Can it help with database security?

Yes, it includes optimized patterns for Row Level Security (RLS) to ensure data privacy and secure multi-tenant access within your application.

How does this skill improve PostgreSQL performance?

It provides Claude with specific indexing strategies (like composite, partial, and covering indexes) and diagnostic queries to identify slow execution times and table bloat.

Is this skill compatible with Supabase?

Absolutely. The patterns and best practices are modeled after the Supabase ecosystem, making it ideal for developers building on modern PostgreSQL-based platforms.

PostgreSQL Design & Performance Patterns

Name: PostgreSQL Design & Performance Patterns
Author: xu-xiang

byxu-xiang

•

Database Management

Implements high-performance PostgreSQL database schemas, optimized queries, and robust security policies based on industry best practices.

The postgres-patterns skill provides Claude with a comprehensive knowledge base for designing and managing PostgreSQL databases efficiently. Drawing from Supabase best practices, it guides the creation of optimized indexes, proper data type selection, and performance-driven query patterns like cursor pagination and UPSERTs. This skill also prioritizes database security through Row Level Security (RLS) implementation and provides diagnostic tools to identify anti-patterns such as table bloat or missing foreign key indexes. It is an essential resource for developers using Claude Code to build scalable, secure, and production-ready backend infrastructures.

Key Features

01Indexing strategy optimization for B-tree, GIN, and BRIN types

0261 GitHub stars

03Performance tuning via anti-pattern detection and slow query analysis

04Advanced schema design including covering and partial indexes

05Efficiency patterns for cursor pagination and transactional queue processing

06Secure Row Level Security (RLS) policy implementation and optimization

Use Cases

01Implementing secure multi-tenant architectures using RLS policies

02Troubleshooting slow performance and managing database table bloat

03Writing high-performance database migrations and complex SQL queries

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

Download Skill