Can it help with database security and multi-tenancy?

Yes, it includes optimized Row-Level Security (RLS) templates that are specifically designed for high performance and secure data isolation.

What kind of anti-patterns can this skill detect?

The skill can identify unindexed foreign keys, excessive table bloat, and slow-running queries using pg_stat_statements scripts.

How does this skill improve PostgreSQL query performance?

It provides a specific index cheat sheet and composite index patterns to ensure your SQL queries use the most efficient data paths, significantly reducing execution time.

Is this skill limited to Supabase users?

While it draws from Supabase's best practices, the patterns, indexing strategies, and SQL optimizations are applicable to any standard PostgreSQL environment.

Does it provide configuration advice?

Yes, it includes configuration templates for system parameters like work_mem, statement timeouts, and connection limits based on available RAM.

PostgreSQL Design Patterns & Optimization

Name: PostgreSQL Design Patterns & Optimization
Author: Fabio29T

byFabio29T

0•

数据库管理

Implements high-performance PostgreSQL database schemas and optimized SQL queries following industry-standard best practices.

The postgres-patterns skill provides Claude with a specialized knowledge base for architecting, optimizing, and securing PostgreSQL databases. Based on Supabase best practices, it equips the AI with advanced implementation patterns for complex indexing strategies, row-level security (RLS), and efficient query structures like cursor pagination and upserts. This skill is particularly useful for developers looking to scale their database layer, eliminate anti-patterns such as table bloat or unindexed foreign keys, and ensure production-grade security defaults and configuration.

主要功能

01Automated detection of database anti-patterns and slow query identification

020 GitHub stars

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

04Optimized Row-Level Security (RLS) policy templates for multi-tenant apps

05Performance-tuned configuration templates for connection limits and monitoring

06Advanced SQL patterns for queue processing, pagination, and data migrations

使用场景

01Implementing secure data access layers using Row-Level Security

02Auditing existing databases for performance bottlenecks and table bloat

03Optimizing slow database queries and designing efficient schema migrations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fabio29t/everything-claude postgres-patterns

For use in Claude.ai and ChatGPT

主要功能

01Automated detection of database anti-patterns and slow query identification

020 GitHub stars

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

04Optimized Row-Level Security (RLS) policy templates for multi-tenant apps

05Performance-tuned configuration templates for connection limits and monitoring

06Advanced SQL patterns for queue processing, pagination, and data migrations

使用场景

01Implementing secure data access layers using Row-Level Security

02Auditing existing databases for performance bottlenecks and table bloat

03Optimizing slow database queries and designing efficient schema migrations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add fabio29t/everything-claude postgres-patterns

For use in Claude.ai and ChatGPT