Does this skill work with any PostgreSQL version?

Yes, it focuses on standard PostgreSQL patterns applicable to most modern versions (12+), with specific optimizations for cloud platforms like Supabase.

What is the difference between this skill and a database reviewer?

This skill provides quick-reference patterns and snippets during active coding, while the associated database-reviewer agent is intended for deep-dive architectural audits.

How does it help with query performance?

It provides specific indexing recommendations for different query patterns and identifies anti-patterns like unindexed foreign keys or inefficient OFFSET pagination.

Can it help with database security?

Absolutely. It includes patterns for optimized Row Level Security (RLS) policies and configuration templates for hardening database access and permissions.

PostgreSQL Optimization & Patterns

Name: PostgreSQL Optimization & Patterns
Author: flatrick

byflatrick

0•

データベース管理

Provides production-ready PostgreSQL patterns for query optimization, schema design, and database security based on Supabase best practices.

This skill equips Claude with specialized knowledge of PostgreSQL best practices, specifically tailored for high-performance applications and modern cloud environments. It offers immediate access to optimized indexing strategies, precise data type selections, Row Level Security (RLS) implementations, and performance monitoring scripts. By integrating these patterns, developers can avoid common pitfalls like unindexed foreign keys or inefficient pagination while ensuring their database architecture remains scalable, secure, and maintainable.

主な機能

01Advanced query patterns for UPSERT, cursor pagination, and queue processing

02Optimized Row Level Security (RLS) policy implementation patterns

030 GitHub stars

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

05Pre-configured SQL templates for database hardening and performance tuning

06Comprehensive indexing cheat sheet for B-tree, GIN, and BRIN indexes

ユースケース

01Designing a scalable database schema with optimal data types and relationships

02Troubleshooting and resolving performance bottlenecks in slow-running SQL queries

03Implementing secure multi-tenant architectures using optimized Row Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add flatrick/mdt postgres-patterns

For use in Claude.ai and ChatGPT