Is this skill compatible with Supabase?

Yes, the patterns, indexing strategies, and Row Level Security (RLS) templates are specifically aligned with Supabase best practices.

What data type recommendations does it offer?

The skill provides a reference for choosing modern PostgreSQL types, such as recommending timestamptz over timestamp and text over varchar(255).

Can it help me implement secure database access?

Absolutely. It includes optimized RLS policy templates and security configuration defaults to ensure your data remains protected.

Does it support advanced data handling patterns?

Yes, it covers advanced scenarios like atomic queue processing with SKIP LOCKED, UPSERT operations, and efficient cursor pagination.

How does this skill help with slow SQL queries?

It provides a comprehensive index selection guide and diagnostic queries to identify performance bottlenecks using pg_stat_statements.

PostgreSQL Patterns & Optimization

Name: PostgreSQL Patterns & Optimization
Author: arabicapp

byarabicapp

•

Database Management

Optimizes PostgreSQL database performance and security through standardized schema design, indexing strategies, and advanced query patterns.

The PostgreSQL Patterns skill provides Claude with a comprehensive knowledge base for building scalable and secure database architectures. Based on Supabase best practices, it equips the AI with the ability to select optimal data types, implement efficient indexing—including B-tree, GIN, BRIN, and covering indexes—and enforce Row Level Security (RLS). This skill is essential for developers who need to troubleshoot slow queries, prevent common database anti-patterns, or establish production-ready configurations for connection pooling and real-time monitoring.

Key Features

01Comprehensive Indexing Guide: Strategies for B-tree, GIN, BRIN, Composite, and Partial indexes.

025 GitHub stars

03Performance Optimization: Advanced query patterns for O(1) cursor pagination and queue processing.

04Security Best Practices: Templates for optimized Row Level Security (RLS) policies and security defaults.

05Anti-Pattern Detection: Automated identification of unindexed foreign keys and table bloat.

06Schema Design Standards: Expert guidance on data types and production-grade configuration templates.

Use Cases

01Refactoring slow SQL queries and identifying performance bottlenecks in existing databases.

02Designing high-performance database schemas with optimized indexing from the start.

03Implementing granular security layers and RLS policies for multi-tenant applications.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add arabicapp/everything-claude-code postgres-patterns

For use in Claude.ai and ChatGPT

Download Skill