Is this skill compatible with Supabase?

Yes, these patterns are specifically based on Supabase best practices, including optimized Row-Level Security (RLS) implementations.

What index types are covered in the cheat sheet?

The skill includes guidance for B-tree, GIN (for JSONB and full-text search), and BRIN (for time-series data) indices.

Does it cover security features?

Yes, it provides patterns for secure schema defaults and optimized RLS policies to ensure robust data privacy.

How does this skill help with database performance?

It provides specific indexing strategies for different query patterns and includes tools to detect slow queries and table bloat.

Can it help with data migrations?

Absolutely, it includes templates for common migration tasks like UPSERT, table configurations, and data type selection.

PostgreSQL Design Patterns

Name: PostgreSQL Design Patterns
Author: saar120

bysaar120

0•

Database Management

Provides expert-grade PostgreSQL patterns for query optimization, schema design, and database security based on Supabase best practices.

This skill equips Claude with a comprehensive reference for PostgreSQL development, covering everything from efficient indexing strategies and data type selection to advanced patterns like Row-Level Security (RLS) and queue processing. It helps developers avoid common pitfalls such as unindexed foreign keys and table bloat while providing ready-to-use SQL templates for high-performance database architectures. Whether you are troubleshooting slow queries or designing a schema from scratch, this skill ensures your database layer follows industry-standard performance and security protocols.

Key Features

01Optimized Row-Level Security (RLS) policy templates for secure data access

02Anti-pattern detection for slow queries, table bloat, and unindexed foreign keys

03High-performance patterns for UPSERT, cursor pagination, and job queues

04Standardized configuration templates for connection limits, timeouts, and monitoring

050 GitHub stars

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

Use Cases

01Troubleshooting and optimizing slow-performing SQL queries and database bottlenecks

02Designing scalable and secure database schemas for modern web applications

03Implementing fine-grained access control using optimized RLS policies

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

01Optimized Row-Level Security (RLS) policy templates for secure data access

02Anti-pattern detection for slow queries, table bloat, and unindexed foreign keys

03High-performance patterns for UPSERT, cursor pagination, and job queues

04Standardized configuration templates for connection limits, timeouts, and monitoring

050 GitHub stars

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

Use Cases

01Troubleshooting and optimizing slow-performing SQL queries and database bottlenecks

02Designing scalable and secure database schemas for modern web applications

03Implementing fine-grained access control using optimized RLS policies

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