How does this skill improve PostgreSQL query performance?

It provides actionable patterns for using EXPLAIN ANALYZE, selecting the right index types (B-tree, GiST, GIN), and replacing inefficient subqueries with EXISTS or batch operations.

Can this skill help with managing JSON data in Postgres?

Yes, it includes specific patterns for querying JSON columns, performing JSON aggregation, and implementing GIN indexes for fast JSON path queries.

Does it provide guidance on database maintenance?

Absolutely. The skill includes workflows for identifying slow queries via pg_stat_statements, checking for table bloat, and managing VACUUM/ANALYZE tasks.

Which database design patterns are covered?

The skill covers range partitioning for time-series data, materialized views for caching expensive computations, and advanced constraints like exclusion and domain types.

PostgreSQL Advanced Patterns

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

byorganvm-iv-taxis

•

Database Management

Optimizes PostgreSQL database performance and design through advanced indexing, complex query patterns, and concurrency management.

This Claude Code skill provides a comprehensive toolkit for developers working with PostgreSQL, offering specialized guidance on high-performance database design and complex query optimization. It enables Claude to implement sophisticated patterns such as recursive CTEs, window functions, and JSONB operations, while ensuring database health through proper indexing strategies, partitioning, and transaction isolation. It is an essential resource for scaling applications, debugging slow queries, and architecting robust, production-grade data schemas.

Key Features

01Advanced indexing strategies including GiST, GIN, and partial indexes

02Database design patterns like range partitioning and materialized views

03Fine-grained concurrency control and transaction isolation levels

04Complex query patterns using window functions and recursive CTEs

05High-performance JSONB operations and semi-structured data manipulation

062 GitHub stars

Use Cases

01Designing scalable database schemas for hierarchical or time-series data

02Implementing safe row-level locking for critical financial or inventory operations

03Optimizing slow-running analytical queries in high-traffic applications

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