How does this skill improve database performance?

It provides optimized indexing strategies for different query patterns and identifies common anti-patterns like unindexed foreign keys and table bloat that cause latency.

Is this skill specific to Supabase users?

While it incorporates Supabase best practices, the patterns and SQL techniques provided are compatible with any standard PostgreSQL environment.

Can it help with database security?

Yes, it includes optimized Row Level Security (RLS) templates and security default configurations to help you harden your database against unauthorized access.

Does it support advanced SQL features?

Absolutely, it covers complex patterns including UPSERT, cursor pagination, and high-concurrency job queues using SKIP LOCKED.

PostgreSQL Database Patterns

Name: PostgreSQL Database Patterns
Author: saar120

bysaar120

0•

データベース管理

Optimizes PostgreSQL performance and security using standardized schema designs, indexing strategies, and Row Level Security best practices.

This skill equips Claude with specialized knowledge for PostgreSQL database management, focusing on high-performance query patterns and robust security configurations. Based on industry-leading Supabase best practices, it provides immediate access to indexing cheat sheets, optimized data type recommendations, and advanced SQL patterns like cursor pagination and SKIP LOCKED queues. It is particularly useful for developers looking to identify database anti-patterns, implement secure multi-tenant access via RLS, or tune configuration settings for production-grade reliability.

主な機能

01Comprehensive indexing strategies including B-tree, GIN, BRIN, and Partial indexes

02Optimized Row Level Security (RLS) policy templates for secure data access

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

04Advanced SQL implementation patterns for Upserts, Pagination, and Queues

05Performance-tuned configuration templates for connection limits and monitoring

060 GitHub stars

ユースケース

01Designing scalable database schemas and selecting optimal data types

02Troubleshooting and refactoring slow-performing SQL queries

03Implementing secure data access layers using Row Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add saar120/skillgate-registry postgres-patterns

For use in Claude.ai and ChatGPT

主な機能

01Comprehensive indexing strategies including B-tree, GIN, BRIN, and Partial indexes

02Optimized Row Level Security (RLS) policy templates for secure data access

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

04Advanced SQL implementation patterns for Upserts, Pagination, and Queues

05Performance-tuned configuration templates for connection limits and monitoring

060 GitHub stars

ユースケース

01Designing scalable database schemas and selecting optimal data types

02Troubleshooting and refactoring slow-performing SQL queries

03Implementing secure data access layers using Row Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add saar120/skillgate-registry postgres-patterns

For use in Claude.ai and ChatGPT