Does this skill cover database maintenance?

It includes essential maintenance patterns for monitoring table bloat, index usage, and implementing regular VACUUM and ANALYZE tasks to keep statistics up to date.

How does this skill help with slow PostgreSQL queries?

It provides specific patterns for using EXPLAIN ANALYZE to identify bottlenecks and recommends targeted indexing strategies or query refactoring (like using EXISTS vs IN) to improve execution speed.

Can I use this skill for JSON data in PostgreSQL?

Yes, it includes advanced patterns for JSONB operations, JSON path queries, and GIN indexing to ensure your document-style data remains performant at scale.

What transaction management features are included?

The skill covers various transaction isolation levels (Serializable, Repeatable Read) and row-level locking strategies like 'FOR UPDATE SKIP LOCKED' for building reliable job queues and financial systems.

PostgreSQL Advanced Patterns

Name: PostgreSQL Advanced Patterns
Author: organvm-iv-taxis

byorganvm-iv-taxis

•

Database Management

Optimizes PostgreSQL performance and architecture using advanced indexing, complex query patterns, and efficient schema design.

This skill equips Claude with specialized knowledge for architecting and optimizing high-performance PostgreSQL databases. It provides implementation patterns for advanced indexing (GIN, GiST, Partial), complex query structures like recursive CTEs and window functions, and sophisticated design strategies including table partitioning and materialized views. Whether you are troubleshooting slow queries using EXPLAIN ANALYZE or building scalable data models, this skill ensures your database layer follows industry best practices for concurrency, maintainability, and sub-second response times.

Key Features

01Complex query construction using Window Functions and Recursive CTEs for hierarchical data

02Performance optimization workflows using EXPLAIN ANALYZE and query plan interpretation

03Database design patterns for range partitioning and concurrent materialized view refreshes

042 GitHub stars

05Advanced indexing strategies including B-tree, Partial, GiST, and GIN for JSONB and search

06Transaction isolation and row-level locking patterns for high-concurrency systems

Use Cases

01Implementing robust JSONB-based document storage with specialized GIN indexing

02Refactoring slow analytical queries into efficient window functions or materialized views

03Designing scalable database schemas for multi-tenant applications using table partitioning

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add organvm-iv-taxis/a-i--skills postgres-advanced-patterns

For use in Claude.ai and ChatGPT

Download Skill