Can it help with database security?

Absolutely. It includes optimized Row-Level Security (RLS) policy templates and security configuration defaults to harden your database.

How does this skill improve PostgreSQL performance?

It provides specific indexing strategies for different query patterns and identifies anti-patterns like missing indexes or inefficient data types.

Does it support modern features like JSONB?

Yes, it includes GIN indexing patterns specifically for JSONB and full-text search optimization.

Is this skill compatible with Supabase?

Yes, the patterns and best practices are specifically based on Supabase implementation standards, making it perfect for Supabase developers.

How do I detect slow queries using this skill?

The skill provides built-in SQL templates for querying pg_stat_statements to identify and rank the most resource-intensive queries.

PostgreSQL Optimization Patterns

Name: PostgreSQL Optimization Patterns
Author: affaan-m

byaffaan-m

•

112,917

•

数据库管理

Optimizes PostgreSQL performance and schema design using production-ready patterns and Supabase best practices.

This skill provides a comprehensive toolkit for PostgreSQL database management, focusing on high-performance schema design and query optimization. It equips Claude with specialized knowledge for selecting the right index types, implementing advanced SQL patterns like UPSERT and cursor-based pagination, and hardening security through optimized Row-Level Security (RLS) policies. By integrating industry-standard best practices from the Supabase ecosystem, it helps developers avoid common anti-patterns such as unindexed foreign keys and table bloat while providing ready-to-use configuration templates for connection pooling and monitoring.

主要功能

01112,917 GitHub stars

02Indexing cheat sheet for B-tree, GIN, BRIN, and composite indexes

03Advanced SQL patterns for UPSERT, queue processing, and cursor-based pagination

04High-performance data type recommendations for IDs, currency, and timestamps

05Optimized Row-Level Security (RLS) policy templates for enhanced data safety

06Automated anti-pattern detection for slow queries and unindexed foreign keys

使用场景

01Designing scalable database schemas with correct indexing and data types

02Troubleshooting and optimizing slow-running SQL queries in production

03Implementing secure multi-tenant architectures using Row-Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code postgres-patterns

For use in Claude.ai and ChatGPT

主要功能

01112,917 GitHub stars

02Indexing cheat sheet for B-tree, GIN, BRIN, and composite indexes

03Advanced SQL patterns for UPSERT, queue processing, and cursor-based pagination

04High-performance data type recommendations for IDs, currency, and timestamps

05Optimized Row-Level Security (RLS) policy templates for enhanced data safety

06Automated anti-pattern detection for slow queries and unindexed foreign keys

使用场景

01Designing scalable database schemas with correct indexing and data types

02Troubleshooting and optimizing slow-running SQL queries in production

03Implementing secure multi-tenant architectures using Row-Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add affaan-m/everything-claude-code postgres-patterns

For use in Claude.ai and ChatGPT