How does it handle complex data types?

It provides specific patterns for handling JSONB indexing with GIN, time-series data with BRIN, and efficient string storage.

Does this skill help with database security?

Absolutely. It provides guidance on Row Level Security (RLS) optimization and security-focused configuration defaults like revoking public schema permissions.

Can it help with database performance issues?

Yes, it includes specialized snippets for identifying slow queries, checking for table bloat, and selecting the correct index types for specific query patterns.

Is it suitable for production migrations?

Yes, the patterns cover critical production concerns such as non-blocking index creation, connection limits, and transaction timeouts.

What database is this skill optimized for?

It is specifically designed for PostgreSQL, incorporating architectural best practices often used in Supabase environments.

PostgreSQL Patterns

Name: PostgreSQL Patterns
Author: oabdelmaksoud

byoabdelmaksoud

0•

数据库管理

Optimizes PostgreSQL database design and performance using industry-proven patterns and Supabase best practices.

PostgreSQL Patterns is a specialized skill for Claude Code that provides an essential toolkit for database schema design, query optimization, and security implementation. Based on Supabase best practices, it offers instant access to optimized indexing strategies, Row Level Security (RLS) templates, and performance-tuning configurations. Whether you are building a new migration, troubleshooting slow queries, or setting up multi-tenant security policies, this skill ensures your database architecture follows professional standards for scalability and reliability.

主要功能

010 GitHub stars

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

03Data type recommendations for high-performance ID, text, and monetary storage.

04Ready-to-use configuration templates for connection pooling, timeouts, and monitoring.

05Anti-pattern detection scripts for identifying missing indexes and slow query bottlenecks.

06Optimized Row Level Security (RLS) policy templates to prevent unauthorized access.

使用场景

01Designing a scalable database schema for high-traffic applications using best-practice data types.

02Optimizing slow SQL queries through advanced indexing and cursor-based pagination.

03Implementing secure multi-tenant access control with optimized RLS policies.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add oabdelmaksoud/superclaw postgres-patterns

For use in Claude.ai and ChatGPT

主要功能

010 GitHub stars

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

03Data type recommendations for high-performance ID, text, and monetary storage.

04Ready-to-use configuration templates for connection pooling, timeouts, and monitoring.

05Anti-pattern detection scripts for identifying missing indexes and slow query bottlenecks.

06Optimized Row Level Security (RLS) policy templates to prevent unauthorized access.

使用场景

01Designing a scalable database schema for high-traffic applications using best-practice data types.

02Optimizing slow SQL queries through advanced indexing and cursor-based pagination.

03Implementing secure multi-tenant access control with optimized RLS policies.