Can it help with database security?

Absolutely. It includes optimized patterns for Row Level Security (RLS) and secure configuration templates to protect your data.

Does it support advanced data types like JSONB?

Yes, it includes specific indexing patterns for JSONB (GIN indexes) and full-text search optimization.

How does this skill help with PostgreSQL performance?

It provides optimized indexing templates and identifies common anti-patterns like unindexed foreign keys to ensure your database runs efficiently.

Is this skill compatible with Supabase?

Yes, the patterns are specifically curated based on Supabase best practices, making it ideal for developers using the Supabase stack.

PostgreSQL Patterns

Name: PostgreSQL Patterns
Author: saar120

bysaar120

0•

Database Management

Optimizes PostgreSQL databases with production-ready patterns for schema design, indexing, and high-performance querying.

PostgreSQL Patterns is a specialized skill for Claude Code that provides a comprehensive reference for database best practices, largely based on Supabase's proven methodologies. It equips Claude with the ability to design efficient schemas, implement advanced indexing strategies (B-tree, GIN, BRIN), and write secure Row Level Security (RLS) policies. Whether you are troubleshooting slow queries, setting up connection pooling, or building complex queue systems, this skill ensures your database architecture follows industry-standard patterns for performance and scalability.

Key Features

01Row Level Security (RLS) optimization and security best practices

020 GitHub stars

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

04Anti-pattern detection for unindexed foreign keys and table bloat

05Data type recommendations for high performance and precision

06Optimized indexing strategies for B-tree, GIN, BRIN, and composite indexes

Use Cases

01Troubleshooting and optimizing slow-running SQL queries and bottlenecks

02Designing high-performance database schemas and automated migrations

03Implementing secure, granular access control using Row Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add saar120/skillgate-registry postgres-patterns

For use in Claude.ai and ChatGPT

Key Features

01Row Level Security (RLS) optimization and security best practices

020 GitHub stars

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

04Anti-pattern detection for unindexed foreign keys and table bloat

05Data type recommendations for high performance and precision

06Optimized indexing strategies for B-tree, GIN, BRIN, and composite indexes

Use Cases

01Troubleshooting and optimizing slow-running SQL queries and bottlenecks

02Designing high-performance database schemas and automated migrations

03Implementing secure, granular access control using Row Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add saar120/skillgate-registry postgres-patterns

For use in Claude.ai and ChatGPT