Can it help me find database performance issues?

Yes, it includes specialized SQL queries to detect unindexed foreign keys, slow queries using pg_stat_statements, and table bloat.

Is this skill specific to Supabase?

While it is based on Supabase best practices, the patterns and SQL snippets are compatible with any standard PostgreSQL installation.

How does it help with query optimization?

It provides a quick-reference for matching query patterns to the correct index types, such as GIN for JSONB and BRIN for time-series data.

What security features are included?

It includes templates for optimized Row Level Security (RLS) policies and security configuration defaults to harden your database.

Does it support advanced concurrency patterns?

Yes, it provides implementation patterns for efficient queue processing using FOR UPDATE SKIP LOCKED and cursor-based pagination.

PostgreSQL Patterns

Name: PostgreSQL Patterns
Author: Fabio29T

byFabio29T

0•

数据库管理

Optimizes PostgreSQL database performance and security through schema design patterns, indexing strategies, and best practices.

Provides a comprehensive set of PostgreSQL patterns for query optimization, schema design, and security management. Based on Supabase best practices, this skill helps developers implement efficient indexing, select appropriate data types, detect anti-patterns like unindexed foreign keys, and configure robust Row Level Security (RLS) policies. It serves as an essential companion for building scalable applications, managing database migrations, and troubleshooting performance bottlenecks in any PostgreSQL environment.

主要功能

01Comprehensive indexing cheat sheets for B-tree, GIN, and BRIN types

02Performance-tuned configuration templates for connection and memory management

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

040 GitHub stars

05Advanced implementation patterns for UPSERT, pagination, and job queues

06Optimized data type selection guidelines for IDs, timestamps, and currency

使用场景

01Designing high-performance database schemas for new applications

02Implementing secure and optimized Row Level Security (RLS) for multi-tenant apps

03Troubleshooting and optimizing slow-running SQL queries in production

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

主要功能

01Comprehensive indexing cheat sheets for B-tree, GIN, and BRIN types

02Performance-tuned configuration templates for connection and memory management

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

040 GitHub stars

05Advanced implementation patterns for UPSERT, pagination, and job queues

06Optimized data type selection guidelines for IDs, timestamps, and currency

使用场景

01Designing high-performance database schemas for new applications

02Implementing secure and optimized Row Level Security (RLS) for multi-tenant apps

03Troubleshooting and optimizing slow-running SQL queries in production

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