Does it support advanced SQL operations like queueing?

Absolutely, it includes specialized patterns for queue processing using FOR UPDATE SKIP LOCKED and O(1) cursor-based pagination.

Can it help with Row Level Security (RLS)?

Yes, it includes optimized RLS policy patterns and security default templates to help you implement fine-grained access control effectively.

Is this skill specific to Supabase users?

While it is based on Supabase best practices, the patterns, indexing strategies, and SQL commands are applicable to any standard PostgreSQL database environment.

How does this skill improve database performance?

It provides specific indexing strategies (like GIN for JSONB and composite indexes) and detects common anti-patterns such as table bloat and unindexed foreign keys that slow down performance.

PostgreSQL Patterns

Name: PostgreSQL Patterns
Author: Nixdorfer

byNixdorfer

•

Database Management

Optimizes PostgreSQL schema design, indexing strategies, and query performance using industry-standard best practices.

This skill provides Claude with a comprehensive reference for PostgreSQL development, focusing on high-performance schema design and secure implementation patterns. It offers specific guidance on advanced indexing (B-tree, GIN, BRIN), Row Level Security (RLS) optimization, and efficient data modeling based on Supabase best practices. By integrating this skill, developers can automatically detect anti-patterns like unindexed foreign keys or table bloat and apply robust templates for complex operations like cursor pagination, queue processing, and upserts.

Key Features

01Database configuration templates for performance and monitoring

02Advanced indexing guide for B-tree, GIN, BRIN, and composite indexes

03Optimized SQL patterns for UPSERT, pagination, and queue processing

04Anti-pattern detection for slow queries and unindexed foreign keys

051 GitHub stars

06Row Level Security (RLS) implementation and security hardening

Use Cases

01Designing scalable database schemas with correct data types and relationships

02Implementing secure, multi-tenant access control using RLS

03Troubleshooting and optimizing slow-running SQL queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nixdorfer/claudecodetool postgres-patterns

For use in Claude.ai and ChatGPT

Download Skill