Is this skill specific to Supabase databases?

While it draws from Supabase best practices, the SQL patterns, indexing strategies, and configuration templates are applicable to any standard PostgreSQL environment.

How does this skill help with database performance?

It provides specific indexing strategies, optimized query patterns, and anti-pattern detection scripts to identify and resolve performance bottlenecks like table bloat and missing indexes.

Can this skill help with database security?

Yes, it includes patterns for correctly implementing Row Level Security (RLS) and provides security-hardened configuration templates to protect your data.

What types of PostgreSQL indexes does it cover?

The skill covers B-tree, GIN, BRIN, Composite, Covering, and Partial indexes, providing guidance on which to use for specific WHERE clause patterns.

PostgreSQL Best Practices (zh-TW)

Name: PostgreSQL Best Practices (zh-TW)
Author: Infopibe

byInfopibe

•

데이터베이스 관리

Optimizes PostgreSQL database workflows with standardized patterns for schema design, indexing strategies, and performance tuning.

This skill provides Claude with a comprehensive reference for PostgreSQL development, focusing on high-performance schema design and query optimization based on Supabase best practices. It covers critical areas such as choosing the right index types (GIN, BRIN, B-tree), selecting efficient data types, implementing secure Row Level Security (RLS) policies, and identifying common anti-patterns like unindexed foreign keys or table bloat. By integrating these patterns directly into the Claude Code workflow, developers can ensure their database migrations and queries adhere to industry-standard best practices while avoiding common performance bottlenecks and security risks.

주요 기능

01Performance-optimized SQL patterns for UPSERT, pagination, and job queues

021 GitHub stars

03Comprehensive indexing cheat sheet for B-tree, GIN, and BRIN types

04Security-hardened Row Level Security (RLS) implementation guides

05Pre-configured database settings templates for connection pooling and memory management

06Anti-pattern detection scripts for slow queries, unindexed keys, and table bloat

사용 사례

01Auditing and troubleshooting existing slow-running SQL queries

02Implementing secure multi-tenant data access using Row Level Security

03Designing a high-performance database schema for a new application

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

주요 기능

01Performance-optimized SQL patterns for UPSERT, pagination, and job queues

021 GitHub stars

03Comprehensive indexing cheat sheet for B-tree, GIN, and BRIN types

04Security-hardened Row Level Security (RLS) implementation guides

05Pre-configured database settings templates for connection pooling and memory management

06Anti-pattern detection scripts for slow queries, unindexed keys, and table bloat

사용 사례

01Auditing and troubleshooting existing slow-running SQL queries

02Implementing secure multi-tenant data access using Row Level Security

03Designing a high-performance database schema for a new application