Can it help with database security audits?

Yes, it includes scripts to find unindexed foreign keys and templates for secure RLS policies that prevent unauthorized data access.

What specific database features does this skill cover?

It covers indexing strategies, schema design, Row Level Security (RLS), performance tuning, and the detection of common database anti-patterns.

How does this improve AI-generated SQL code?

It provides Claude with context-specific implementation patterns that avoid common pitfalls like inefficient OFFSET pagination or improper index types for JSONB data.

Is this skill only applicable for Supabase users?

No, while it is based on Supabase best practices, the patterns provided are standard SQL and apply to any PostgreSQL instance regardless of the hosting provider.

PostgreSQL Design Patterns

Name: PostgreSQL Design Patterns
Author: unju-ai

byunju-ai

0•

Database Management

Optimizes PostgreSQL databases through expert schema design, indexing strategies, and performance patterns based on Supabase best practices.

This skill integrates advanced PostgreSQL guidance into Claude Code, offering a curated set of patterns for query optimization, schema architecture, and database security. It covers essential topics like selecting the right index types (B-tree, GIN, BRIN), implementing efficient pagination, and utilizing advanced features like 'FOR UPDATE SKIP LOCKED' for job queues. Whether you are building a new application or troubleshooting slow queries in a production environment, these patterns ensure your database remains performant, scalable, and secure using industry-standard techniques.

Key Features

01Advanced implementation logic for atomic UPSERTs and cursor-based pagination.

02SQL snippets for anti-pattern detection, table bloat checks, and slow query monitoring.

030 GitHub stars

04Performance-first data type recommendations for accuracy and storage efficiency.

05Comprehensive indexing cheat sheet for B-tree, GIN, BRIN, and covering indexes.

06Optimized Row Level Security (RLS) patterns to ensure secure multi-tenant access.

Use Cases

01Troubleshooting and resolving slow SQL queries through index optimization.

02Designing scalable and performant database schemas for new software projects.

03Hardening database security using optimized Row Level Security policies.

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