Which indexing types are covered in this skill?

The skill provides a cheatsheet for various index types including B-tree, GIN, BRIN, composite, covering, and partial indexes.

What is the PostgreSQL Patterns skill?

It is a specialized capability for Claude Code that provides domain-specific guidance and implementation patterns for PostgreSQL database optimization and schema design.

How does it help with database performance troubleshooting?

It includes diagnostic SQL snippets to identify unindexed foreign keys, slow queries via pg_stat_statements, and table bloat issues.

Does this skill support Row Level Security (RLS)?

Yes, it includes specific patterns for implementing and optimizing RLS policies to ensure secure, high-performance data access.

PostgreSQL Patterns (zh-TW)

Name: PostgreSQL Patterns (zh-TW)
Author: Infopibe

byInfopibe

•

Database Management

Optimizes PostgreSQL database performance and security with battle-tested schema patterns and indexing strategies.

This skill provides Claude with a comprehensive reference for PostgreSQL best practices, specifically tailored for high-performance applications. It includes expert guidance on selecting the correct index types (B-tree, GIN, BRIN), optimizing data types, and implementing advanced SQL patterns like UPSERT and cursor-based pagination. Based on Supabase best practices, it also covers critical security features like Row Level Security (RLS) and provides diagnostic scripts to detect database anti-patterns such as table bloat or missing foreign key indexes.

Key Features

011 GitHub stars

02Index selection guide for B-tree, GIN, BRIN, and composite indexes

03Database anti-pattern detection for performance troubleshooting

04Standardized configuration templates for connection limits and monitoring

05Optimized SQL patterns for UPSERT, job queues, and pagination

06Row Level Security (RLS) policy optimization templates

Use Cases

01Optimizing slow SQL queries by implementing correct indexing strategies

02Designing and refactoring database schemas for better performance

03Implementing secure data access layers using Row Level Security

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

Key Features

011 GitHub stars

02Index selection guide for B-tree, GIN, BRIN, and composite indexes

03Database anti-pattern detection for performance troubleshooting

04Standardized configuration templates for connection limits and monitoring

05Optimized SQL patterns for UPSERT, job queues, and pagination

06Row Level Security (RLS) policy optimization templates

Use Cases

01Optimizing slow SQL queries by implementing correct indexing strategies

02Designing and refactoring database schemas for better performance

03Implementing secure data access layers using Row Level Security

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