How does this skill improve query performance?

It provides specific indexing strategies—including GIN for JSONB and BRIN for time-series data—and helps identify slow queries via pg_stat_statements.

Is it compatible with Supabase?

Absolutely; these patterns are specifically curated from Supabase best practices but are applicable to any standard PostgreSQL environment.

Does it support advanced SQL operations?

Yes, it includes snippets for high-performance operations like cursor-based pagination, UPSERT with conflict resolution, and atomic queue processing.

Can it help with database security?

Yes, it includes optimized patterns for Row Level Security (RLS) policies and templates for hardening default schema permissions.

Postgres Database Patterns

Name: Postgres Database Patterns
Author: Mark393295827

byMark393295827

•

Gestión de Bases de Datos

Optimizes PostgreSQL database design, query performance, and security through standardized implementation patterns and best practices.

Postgres Database Patterns provides a comprehensive toolkit for developers to build scalable and secure database architectures. Based on industry-standard Supabase best practices, this skill offers immediate guidance on selecting the right data types, implementing advanced indexing strategies like GIN and BRIN, and configuring Row Level Security (RLS) for multi-tenant applications. It excels at identifying common anti-patterns such as unindexed foreign keys and table bloat, while providing optimized SQL snippets for complex operations like cursor pagination, UPSERTs, and high-concurrency queue processing.

Características Principales

01Advanced Indexing Guide for B-tree, GIN, BRIN, and Composite indexes

02Optimized Query Snippets for pagination and queue processing

03Standardized Database Configuration and Data Type templates

04Anti-Pattern Detection for unindexed foreign keys and slow queries

051 GitHub stars

06Secure Row Level Security (RLS) implementation patterns

Casos de Uso

01Standardizing database migrations and configuration for production

02Refactoring slow SQL queries and implementing efficient indexing

03Designing secure multi-tenant database schemas with RLS

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add mark393295827/house-maint-ai postgres-patterns

For use in Claude.ai and ChatGPT

Características Principales

01Advanced Indexing Guide for B-tree, GIN, BRIN, and Composite indexes

02Optimized Query Snippets for pagination and queue processing

03Standardized Database Configuration and Data Type templates

04Anti-Pattern Detection for unindexed foreign keys and slow queries

051 GitHub stars

06Secure Row Level Security (RLS) implementation patterns

Casos de Uso

01Standardizing database migrations and configuration for production

02Refactoring slow SQL queries and implementing efficient indexing

03Designing secure multi-tenant database schemas with RLS

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add mark393295827/house-maint-ai postgres-patterns

For use in Claude.ai and ChatGPT