Is this skill compatible with standard PostgreSQL environments?

Yes, while based on Supabase best practices, the patterns, indexing strategies, and security defaults are applicable to any standard PostgreSQL environment.

Does it provide guidance on Row Level Security (RLS)?

Yes, it offers optimized RLS policy templates designed to prevent common performance pitfalls and ensure secure data access.

How does this skill help with PostgreSQL query optimization?

It provides a quick reference for choosing the right index types (B-tree, GIN, BRIN) and writing efficient SQL patterns like cursor-based pagination to avoid O(n) performance hits.

Can it help detect database performance issues?

Absolutely. It includes specific SQL scripts to identify unindexed foreign keys, slow queries via pg_stat_statements, and table bloat issues.

PostgreSQL Patterns

Name: PostgreSQL Patterns
Author: saar120

bysaar120

0•

Database Management

Optimizes PostgreSQL database performance and schema design with best practices, indexing strategies, and security patterns.

The postgres-patterns skill provides Claude with high-performance PostgreSQL templates and best practices based on Supabase's industry-standard guidelines. It enables developers to implement efficient indexing (B-tree, GIN, BRIN), secure Row Level Security (RLS) policies, and advanced SQL patterns like UPSERT and cursor-based pagination. By identifying common anti-patterns such as unindexed foreign keys and table bloat, this skill ensures that database migrations and query implementations are scalable, secure, and maintainable.

Key Features

01Standardized configuration templates for connection management

02Comprehensive index cheat sheet for various query patterns

03Optimized Row Level Security (RLS) and UPSERT templates

04Best-practice data type selection for IDs, timestamps, and currency

05Anti-pattern detection for performance bottlenecks and bloat

060 GitHub stars

Use Cases

01Designing secure multi-tenant architectures using Row Level Security

02Performing database migrations and schema refactoring with best practices

03Optimizing slow SQL queries and improving database throughput

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

01Standardized configuration templates for connection management

02Comprehensive index cheat sheet for various query patterns

03Optimized Row Level Security (RLS) and UPSERT templates

04Best-practice data type selection for IDs, timestamps, and currency

05Anti-pattern detection for performance bottlenecks and bloat

060 GitHub stars

Use Cases

01Designing secure multi-tenant architectures using Row Level Security

02Performing database migrations and schema refactoring with best practices

03Optimizing slow SQL queries and improving database throughput

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