How does this skill improve database performance?

It provides Claude with specific index cheat sheets (B-tree, GIN, BRIN) and anti-pattern detection scripts to identify and fix bottlenecks such as unindexed foreign keys.

Can it help with Row Level Security (RLS)?

Absolutely. It includes optimized RLS policy patterns that ensure security boundaries are maintained without compromising query speed.

Is this skill compatible with Supabase?

Yes, the patterns are based on Supabase best practices, making it ideal for developers using the Supabase platform or standard PostgreSQL environments.

Does it cover advanced SQL operations?

Yes, it includes patterns for complex operations like UPSERTs, efficient cursor-based pagination, and 'FOR UPDATE SKIP LOCKED' for processing job queues.

PostgreSQL Best Practices

Name: PostgreSQL Best Practices
Author: Infopibe

byInfopibe

•

数据库管理

Optimizes PostgreSQL databases with production-ready patterns for schema design, indexing, and query performance.

This skill equips Claude with specialized knowledge for PostgreSQL database management, focusing on Supabase-inspired best practices. It provides instant access to optimized indexing strategies (like GIN and BRIN), correct data typing, performance-oriented Row Level Security (RLS) patterns, and advanced SQL techniques such as cursor pagination and skip-locked queue processing. It is an essential tool for developers building scalable backends who need to prevent common anti-patterns, manage table bloat, and ensure secure data access through refined RLS policies.

主要功能

01Performance-optimized Row Level Security (RLS) implementation patterns.

02Anti-pattern detection scripts for unindexed foreign keys and slow query analysis.

03Data type selection guides to ensure scalability and avoid common storage pitfalls.

04Comprehensive indexing cheat sheet for B-tree, GIN, BRIN, and composite indexes.

05Advanced SQL patterns for UPSERT, cursor pagination, and concurrent job queues.

061 GitHub stars

使用场景

01Troubleshooting and refactoring slow-running SQL queries for better execution plans.

02Implementing secure multi-tenant architecture using Row Level Security.

03Designing high-performance database schemas and migration scripts.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

主要功能

01Performance-optimized Row Level Security (RLS) implementation patterns.

02Anti-pattern detection scripts for unindexed foreign keys and slow query analysis.

03Data type selection guides to ensure scalability and avoid common storage pitfalls.

04Comprehensive indexing cheat sheet for B-tree, GIN, BRIN, and composite indexes.

05Advanced SQL patterns for UPSERT, cursor pagination, and concurrent job queues.

061 GitHub stars

使用场景

01Troubleshooting and refactoring slow-running SQL queries for better execution plans.

02Implementing secure multi-tenant architecture using Row Level Security.

03Designing high-performance database schemas and migration scripts.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT