Can this skill help with database security?

Yes, it includes specific patterns for Row Level Security (RLS) and configuration templates to harden your database defaults.

Is this skill specific to Supabase users?

While it draws from Supabase best practices, the patterns and optimizations are applicable to any standard PostgreSQL environment.

What types of indexes does this skill cover?

It covers B-tree for standard lookups, GIN for JSONB and text search, BRIN for large time-series datasets, and partial or covering indexes for specific performance gains.

How does this skill help with database performance?

It provides optimized indexing strategies, efficient pagination techniques, and automated checks for slow queries and table bloat.

PostgreSQL Patterns

Name: PostgreSQL Patterns
Author: x-cmd

byx-cmd

•

Database Management

Optimizes PostgreSQL databases with best practices for schema design, query performance, and security.

This skill provides Claude with a specialized knowledge base for PostgreSQL development, focusing on high-performance patterns and robust security configurations based on Supabase best practices. It assists developers in selecting correct data types, implementing advanced indexing strategies like B-tree, GIN, and BRIN, and writing optimized Row Level Security (RLS) policies. Whether you are designing a new schema or troubleshooting slow queries, this skill provides the patterns needed for production-grade database management and monitoring.

Key Features

01High-performance query patterns for pagination, UPSERT, and queue processing

02Optimized Row Level Security (RLS) policy implementation patterns

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

049 GitHub stars

05Data type recommendations to optimize storage and query performance

06Advanced indexing guidance for B-tree, GIN, BRIN, and composite indexes

Use Cases

01Designing scalable database schemas with correct data types and indexing

02Troubleshooting and fixing slow database queries in high-traffic applications

03Implementing secure multi-tenant architectures using Row Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add x-cmd/skill postgres-patterns

For use in Claude.ai and ChatGPT

Download Skill