Does this skill support Supabase best practices?

Yes, the patterns and recommendations provided by this skill are specifically aligned with Supabase best practices for PostgreSQL management and Row Level Security.

What are PostgreSQL Patterns for Claude Code?

It is a specialized skill that provides Claude with a library of optimized SQL patterns, indexing strategies, and security best practices to improve database performance and developer efficiency.

How does this skill help with query optimization?

It provides a comprehensive index cheat sheet, examples of covering indexes, and tools to detect slow queries and missing indexes on foreign keys.

Can it assist with database security?

Yes, it includes patterns for implementing Row Level Security (RLS) correctly and provides configuration templates for hardening database defaults.

Is it useful for large-scale data handling?

Absolutely. It features patterns for O(1) cursor pagination, BRIN indexes for time-series data, and SKIP LOCKED strategies for high-concurrency queue processing.

PostgreSQL Patterns

Name: PostgreSQL Patterns
Author: LuciferDono

byLuciferDono

•

データベース管理

Optimizes PostgreSQL database performance, schema design, and security using industry-standard best practices and Supabase-inspired patterns.

The PostgreSQL Patterns skill equips Claude with a robust reference for building and maintaining high-performance databases. It provides immediate access to expert guidance on complex indexing strategies (like GIN and BRIN), Row Level Security (RLS) optimization, and anti-pattern detection for common issues like table bloat or unindexed foreign keys. Whether you are designing a new schema, writing efficient migrations, or troubleshooting slow queries, this skill ensures your database architecture follows modern production-grade standards for scalability and reliability.

主な機能

01Anti-pattern detection for unindexed keys and database bloat

02Implementation patterns for UPSERT, cursor pagination, and queue processing

031 GitHub stars

04Advanced indexing guide for B-tree, GIN, BRIN, and Partial indexes

05Production-ready configuration templates for connection limits and timeouts

06Performance-optimized Row Level Security (RLS) policy templates

ユースケース

01Refactoring slow SQL queries and optimizing database throughput

02Troubleshooting performance bottlenecks using pg_stat_statements

03Designing secure multi-tenant database schemas with RLS

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add luciferdono/labs postgres-patterns

For use in Claude.ai and ChatGPT