Does it include security best practices?

Yes, the skill includes optimized patterns for Row Level Security (RLS) and configuration templates for secure schema management and connection limits.

Are the patterns compatible with Supabase?

Absolutely. These patterns are based on Supabase best practices, making them ideal for both Supabase users and standard PostgreSQL deployments.

Can it help me identify database bottlenecks?

Yes, it features anti-pattern detection queries that identify unindexed foreign keys, slow statements via pg_stat_statements, and table bloat issues.

Why does it recommend cursor pagination over OFFSET?

The skill promotes cursor-based pagination because it offers O(1) performance, avoiding the O(n) scaling issues and performance degradation common with large OFFSET values.

How does this skill improve PostgreSQL query performance?

It provides specific indexing strategies for different query types, such as GIN for JSONB/Full-text search and BRIN for time-series data, ensuring the most efficient access paths are used.

PostgreSQL Patterns & Optimization

Name: PostgreSQL Patterns & Optimization
Author: ysyecust

byysyecust

•

Database Management

Optimizes PostgreSQL databases through expert schema design, indexing strategies, and security best practices based on Supabase standards.

This skill provides a comprehensive set of PostgreSQL patterns designed to enhance database performance, reliability, and security within Claude Code. It offers immediate access to optimized indexing strategies, data type recommendations, and advanced query patterns such as cursor pagination and queue processing. By integrating industry-standard practices, it helps developers avoid common anti-patterns, implement robust Row Level Security (RLS), and tune system configurations for production-ready environments, ensuring your database layer is both scalable and secure.

Key Features

01Performance-optimized query patterns for pagination, UPSERTs, and task queues

02Row Level Security (RLS) optimization patterns for secure multi-tenant architectures

03Anti-pattern detection tools for unindexed foreign keys, slow queries, and table bloat

04Best practice data type recommendations for IDs, timestamps, and financial data

05Advanced indexing guide covering B-tree, GIN, BRIN, Partial, and Covering indexes

062 GitHub stars

Use Cases

01Designing scalable and secure database schemas for modern web applications

02Refactoring slow SQL queries and implementing high-performance indexing strategies

03Troubleshooting database performance issues and optimizing system configurations

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