Can this skill assist with JSON data in Postgres?

Yes, it includes specific patterns for querying, aggregating, and indexing JSONB columns, allowing you to treat PostgreSQL as a high-performance document store.

Will this help me handle large-scale data sets?

Yes, it provides implementation patterns for range partitioning and materialized views, which are essential for maintaining performance as your data volume grows.

Does it include guidance on transaction management?

Absolutely. The skill covers transaction isolation levels (Serializable, Repeatable Read) and row-level locking patterns to ensure data consistency in high-concurrency environments.

How does this skill help with PostgreSQL performance?

It provides specific patterns for effective indexing (like GIN and GiST), query optimization techniques using EXPLAIN ANALYZE, and architectural strategies like partitioning and materialized views to reduce query latency.

PostgreSQL Advanced Patterns

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

byorganvm-iv-taxis

•

数据库管理

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

This skill provides Claude with a comprehensive toolkit for architecting and maintaining high-performance PostgreSQL databases. It covers sophisticated techniques ranging from specialized indexing (GIN, GiST, and partial indexes) to complex query structures like recursive CTEs and window functions. Designed for developers building scalable applications, it offers practical patterns for data partitioning, materialized views, and fine-tuned transaction isolation. Whether you are troubleshooting slow queries with EXPLAIN ANALYZE or implementing JSONB-based document storage, this skill ensures your database layer follows industry best practices for efficiency, security, and concurrency.

主要功能

01Complex analytical query patterns using window functions and recursive CTEs

022 GitHub stars

03Scalable database design patterns like range partitioning and materialized views

04Performance diagnostics and optimization using EXPLAIN ANALYZE and query rewriting

05Advanced indexing strategies including B-tree, GIN, GiST, and partial indexes

06Robust concurrency management with transaction isolation levels and row-level locking

使用场景

01Implementing advanced JSONB and full-text search capabilities within PostgreSQL

02Designing high-scale database schemas for multi-tenant or data-intensive applications

03Refactoring slow SQL queries to improve application latency and throughput

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