Can it help me identify database anti-patterns?

Yes, the skill includes specific SQL snippets to detect unindexed foreign keys, table bloat, and inefficient transaction settings.

Is this skill compatible with Supabase?

Yes, the patterns are specifically optimized for Supabase-style environments, particularly regarding Row Level Security (RLS) and PostgreSQL configuration.

What is the postgres-patterns skill for Claude Code?

It is a specialized capability that provides Claude with expert knowledge on PostgreSQL schema design, query optimization, and security best practices based on industry standards.

How does this skill improve database performance?

It offers guidance on choosing the correct index types (like GIN or BRIN), provides diagnostic queries for slow performance, and includes patterns for efficient data retrieval.

Does it provide security recommendations?

Yes, it includes best practices for RLS policies, secure schema defaults, and Revoke/Grant permission patterns.

PostgreSQL Patterns & Optimization

Name: PostgreSQL Patterns & Optimization
Author: oabdelmaksoud

byoabdelmaksoud

0•

Database Management

Optimizes PostgreSQL development with high-performance schema designs, indexing strategies, and production-ready security patterns.

The PostgreSQL Patterns skill equips Claude with specialized knowledge for architecting and maintaining robust database systems based on Supabase best practices. It provides instant access to optimized indexing strategies, data type recommendations, and Row Level Security (RLS) implementation patterns. By integrating this skill, developers can efficiently troubleshoot slow queries, prevent common anti-patterns like unindexed foreign keys or table bloat, and implement advanced features such as cursor-based pagination and SKIP LOCKED queue processing. It is an essential tool for ensuring database performance, security, and scalability during schema design and migration workflows.

Key Features

01Comprehensive indexing guide covering B-tree, GIN, BRIN, and covering indexes

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

030 GitHub stars

04Optimized SQL patterns for UPSERT, pagination, and queue handling

05Production-grade Row Level Security (RLS) policy templates

06Standardized configuration templates for performance and monitoring

Use Cases

01Designing and auditing database schemas for performance and scalability

02Troubleshooting slow SQL queries and implementing efficient indexing

03Implementing secure multi-tenant architectures using RLS

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add oabdelmaksoud/superclaw postgres-patterns

For use in Claude.ai and ChatGPT

Key Features

01Comprehensive indexing guide covering B-tree, GIN, BRIN, and covering indexes

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

030 GitHub stars

04Optimized SQL patterns for UPSERT, pagination, and queue handling

05Production-grade Row Level Security (RLS) policy templates

06Standardized configuration templates for performance and monitoring

Use Cases

01Designing and auditing database schemas for performance and scalability

02Troubleshooting slow SQL queries and implementing efficient indexing

03Implementing secure multi-tenant architectures using RLS