How do I identify unindexed foreign keys?

The skill includes a specific 'Anti-Pattern Detection' query that automatically scans your schema for foreign keys that lack corresponding indexes.

Is this skill specific to Supabase?

While it is based on Supabase best practices, the patterns and SQL techniques are applicable to any standard PostgreSQL environment.

Does it support Row Level Security (RLS)?

Yes, it includes optimized patterns for implementing RLS policies, including specific performance tips like wrapping auth checks in SELECT statements.

Can I use this for database migrations?

Absolutely. The skill provides standardized patterns for table creation, data type selection, and constraint management ideal for writing robust SQL migrations.

How does this skill improve PostgreSQL performance?

It provides a quick reference for matching query patterns to the correct index types (B-tree, GIN, BRIN) and offers diagnostic queries to identify slow executions and table bloat.

PostgreSQL Patterns

Name: PostgreSQL Patterns
Author: nbossn

bynbossn

0•

数据库管理

Streamlines PostgreSQL database development with optimized schema design, indexing strategies, and security best practices.

This skill provides a comprehensive library of PostgreSQL best practices designed to optimize database performance, security, and scalability. It offers expert guidance on selecting efficient index types like B-tree and GIN, implementing secure Row Level Security (RLS) policies, and utilizing advanced query patterns such as cursor pagination and queue processing. Based on industry-leading Supabase standards, it also includes diagnostic tools to detect common anti-patterns like unindexed foreign keys and table bloat, ensuring your database remains performant as it grows.

主要功能

01Optimized Row Level Security (RLS) implementation patterns

020 GitHub stars

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

04Automated anti-pattern detection for unindexed keys and table bloat

05Production-ready SQL templates for UPSERT, pagination, and queueing

06Best practice recommendations for data types and configuration tuning

使用场景

01Implementing secure multi-tenant data access with Row Level Security

02Troubleshooting and optimizing slow queries using expert indexing strategies

03Designing high-performance database schemas and migration scripts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nbossn/claude-code-base postgres-patterns

For use in Claude.ai and ChatGPT

主要功能

01Optimized Row Level Security (RLS) implementation patterns

020 GitHub stars

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

04Automated anti-pattern detection for unindexed keys and table bloat

05Production-ready SQL templates for UPSERT, pagination, and queueing

06Best practice recommendations for data types and configuration tuning

使用场景

01Implementing secure multi-tenant data access with Row Level Security

02Troubleshooting and optimizing slow queries using expert indexing strategies

03Designing high-performance database schemas and migration scripts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nbossn/claude-code-base postgres-patterns

For use in Claude.ai and ChatGPT