Can it help identify existing performance bottlenecks?

Yes, it includes specialized scripts to detect unindexed foreign keys, analyze slow queries via pg_stat_statements, and monitor table bloat.

Are the patterns compatible with Supabase?

Yes, these patterns and best practices are specifically derived from Supabase engineering standards for PostgreSQL development.

What are the best practices for PostgreSQL indexing included here?

The skill covers B-tree, GIN, BRIN, composite, covering, and partial indices, providing specific code examples and use cases for each to ensure maximum query efficiency.

How does this skill help with database security?

It provides optimized patterns for Row Level Security (RLS) policies and security-focused configuration templates to harden your database access controls.

PostgreSQL Patterns & Optimization

Name: PostgreSQL Patterns & Optimization
Author: ysyecust

byysyecust

•

Database Management

Implements high-performance PostgreSQL database designs using industry-standard indexing, schema patterns, and security best practices.

This skill equips Claude with specialized knowledge for architecting and optimizing PostgreSQL databases based on Supabase best practices. It provides rapid access to efficient query patterns, index selection strategies (including B-tree, GIN, and BRIN), and security configurations like Row Level Security (RLS). Whether you are migrating schemas, troubleshooting slow queries, or setting up connection pooling, this skill ensures your database layer is scalable, secure, and performant while avoiding common anti-patterns like unindexed foreign keys and table bloat.

Key Features

01Optimized pagination and queue processing implementation patterns

02Secure Row Level Security (RLS) and UPSERT pattern implementation

03Comprehensive index strategy guide covering B-tree, GIN, BRIN, and Partial indices

04Automated anti-pattern detection for slow queries and unindexed keys

052 GitHub stars

06Performance-focused schema design and data type recommendations

Use Cases

01Optimizing slow SQL queries and identifying missing database indices

02Designing scalable database schemas and migrations for production applications

03Implementing secure multi-tenant access control via Row Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ysyecust/everything-claude-code postgres-patterns

For use in Claude.ai and ChatGPT

Download Skill