What diagnostic tools are included?

The skill includes SQL snippets for identifying unindexed foreign keys, monitoring slow queries via pg_stat_statements, and checking for table bloat.

Is this skill useful for migration planning?

Yes, it offers guidance on correct data types and index placement which is critical when writing SQL migrations.

Can I use these patterns for Supabase projects?

Yes, these patterns are specifically based on Supabase best practices and are highly compatible with Supabase and standard PostgreSQL environments.

Does it support Row-Level Security (RLS)?

Absolutely, it includes optimized patterns for creating secure RLS policies to handle multi-tenancy and data access control.

How does this skill help with PostgreSQL performance?

It provides optimized indexing strategies, anti-pattern detection scripts, and configuration templates to reduce query latency and table bloat.

PostgreSQL Design Patterns

Name: PostgreSQL Design Patterns
Author: Infopibe

byInfopibe

•

데이터베이스 관리

Optimizes PostgreSQL database schemas, queries, and performance using industry-standard best practices and Supabase-inspired patterns.

This skill provides a comprehensive set of PostgreSQL patterns and best practices directly within Claude Code to help developers design robust, high-performance databases. It offers immediate guidance on indexing strategies, optimal data types, Row-Level Security (RLS) implementation, and advanced query patterns like UPSERT or cursor pagination. By incorporating diagnostic tools for anti-pattern detection and performance tuning, it ensures your database remains efficient, secure, and scalable from the initial schema design through production maintenance.

주요 기능

01Anti-pattern detection scripts to find unindexed foreign keys, slow queries, and table bloat.

021 GitHub stars

03Performance tuning templates for connection limits, timeouts, and security defaults.

04Detailed indexing cheat sheet covering B-tree, GIN, BRIN, and composite index strategies.

05Best practice recommendations for PostgreSQL data types to optimize storage and performance.

06Advanced query patterns for UPSERT, cursor-based pagination, and efficient queue processing.

사용 사례

01Troubleshooting and refactoring slow-performing SQL queries and migrations.

02Designing a new database schema with optimized indexing and appropriate data types.

03Implementing Row-Level Security (RLS) policies for secure multi-tenant applications.

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

주요 기능

01Anti-pattern detection scripts to find unindexed foreign keys, slow queries, and table bloat.

021 GitHub stars

03Performance tuning templates for connection limits, timeouts, and security defaults.

04Detailed indexing cheat sheet covering B-tree, GIN, BRIN, and composite index strategies.

05Best practice recommendations for PostgreSQL data types to optimize storage and performance.

06Advanced query patterns for UPSERT, cursor-based pagination, and efficient queue processing.

사용 사례

01Troubleshooting and refactoring slow-performing SQL queries and migrations.

02Designing a new database schema with optimized indexing and appropriate data types.

03Implementing Row-Level Security (RLS) policies for secure multi-tenant applications.