Is this skill compatible with Supabase?

Absolutely. The patterns are based on Supabase best practices, making it ideal for developers working within the Supabase ecosystem or any standard PostgreSQL environment.

How does this skill improve query performance?

It suggests the most efficient index types (B-tree, GIN, BRIN) for specific query patterns and helps identify slow queries or missing indexes on foreign keys.

Does it support Row Level Security (RLS)?

Yes, it provides optimized patterns for creating RLS policies, including techniques like wrapping auth checks in SELECT statements to improve performance.

What is the PostgreSQL Patterns skill?

It is a specialized capability for Claude Code that provides domain-specific guidance for PostgreSQL, focusing on performance, schema design, and security best practices.

Can it help with database maintenance?

Yes, it includes SQL templates for monitoring table bloat, checking connection limits, and configuring extensions like pg_stat_statements.

PostgreSQL Patterns & Optimization

Name: PostgreSQL Patterns & Optimization
Author: unju-ai

byunju-ai

0•

Database Management

Optimizes PostgreSQL database schemas, queries, and security using Supabase-inspired best practices and efficient indexing strategies.

This skill provides Claude with a specialized knowledge base of PostgreSQL best practices, focusing on high-performance schema design and query optimization. It enables Claude to assist developers in selecting the correct data types, implementing advanced indexing (B-tree, GIN, BRIN), and drafting secure Row Level Security (RLS) policies. By utilizing proven patterns from the Supabase ecosystem, the skill helps identify database anti-patterns like unindexed foreign keys or table bloat, while providing ready-to-use templates for common tasks like UPSERT operations, cursor pagination, and queue processing.

Key Features

010 GitHub stars

02Anti-pattern detection for unindexed keys, slow queries, and table bloat

03Optimized indexing cheat sheet for various query patterns (B-tree, GIN, BRIN)

04Security-focused Row Level Security (RLS) policy optimization

05Best practice data type selection (e.g., timestamptz, numeric, text)

06Advanced SQL patterns including UPSERT, Cursor Pagination, and Skip-Locked Queues

Use Cases

01Designing production-grade database schemas with optimal indexing

02Implementing secure multi-tenant access control using Row Level Security (RLS)

03Refactoring slow SQL queries and troubleshooting database performance bottlenecks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add unju-ai/ecc postgres-patterns

For use in Claude.ai and ChatGPT