How does this skill improve database performance?

It provides optimized indexing patterns, query structures like cursor pagination, and troubleshooting tools to identify and fix slow queries.

Does it help with database security?

Yes, it includes patterns for implementing Row Level Security (RLS), secure schema defaults, and proper permission management.

Can it help with identifying database anti-patterns?

Yes, the skill includes specific queries to detect unindexed foreign keys, table bloat, and inefficient data type usage.

Is this skill specific to Supabase?

While based on Supabase best practices, the patterns and SQL implementations are applicable to any standard PostgreSQL environment.

PostgreSQL Patterns

Name: PostgreSQL Patterns
Author: Fabio29T

byFabio29T

0•

데이터베이스 관리

Optimizes PostgreSQL performance and security using expert schema design, indexing strategies, and Supabase best practices.

PostgreSQL Patterns is a specialized skill designed to streamline database management and optimization within Claude Code. It provides a robust reference for high-performance SQL patterns, including advanced indexing (GIN, BRIN, Partial), optimized Row Level Security (RLS) implementation, and efficient data modeling. Whether you are troubleshooting slow queries with pg_stat_statements, implementing complex UPSERT logic, or configuring connection pools, this skill ensures your database architecture follows industry-standard best practices for scalability and security.

주요 기능

01Database configuration templates for connection limits and memory management

020 GitHub stars

03Advanced indexing guide for B-tree, GIN, BRIN, and covering indexes

04Standardized SQL patterns for pagination, job queues, and UPSERT operations

05Performance monitoring patterns using pg_stat_statements and bloat detection

06Row Level Security (RLS) policy optimization and security hardening

사용 사례

01Implementing secure multi-tenant data access using optimized RLS policies

02Designing a scalable database schema with optimal data types and relationships

03Auditing and fixing slow SQL queries or unindexed foreign keys in existing projects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fabio29t/everything-claude postgres-patterns

For use in Claude.ai and ChatGPT

주요 기능

01Database configuration templates for connection limits and memory management

020 GitHub stars

03Advanced indexing guide for B-tree, GIN, BRIN, and covering indexes

04Standardized SQL patterns for pagination, job queues, and UPSERT operations

05Performance monitoring patterns using pg_stat_statements and bloat detection

06Row Level Security (RLS) policy optimization and security hardening

사용 사례

01Implementing secure multi-tenant data access using optimized RLS policies

02Designing a scalable database schema with optimal data types and relationships

03Auditing and fixing slow SQL queries or unindexed foreign keys in existing projects

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fabio29t/everything-claude postgres-patterns

For use in Claude.ai and ChatGPT