Does this skill support JSON data in PostgreSQL?

Yes, it includes advanced patterns for querying JSON columns, using GIN indexes for JSON performance, and performing JSON aggregations.

How does it help with database concurrency?

It provides implementation patterns for various transaction isolation levels (Serializable, Repeatable Read) and row-level locking strategies to manage high-concurrency workloads safely.

Can I use this for database architecture planning?

Absolutely. It contains patterns for table partitioning by range, creating materialized views, and implementing advanced constraints like exclusion and domain types.

What maintenance tasks are covered?

The skill includes patterns for monitoring query performance via pg_stat_statements, checking for table bloat, and performing routine maintenance like VACUUM and ANALYZE.

How does this skill help with slow queries?

It provides patterns for using EXPLAIN ANALYZE to identify bottlenecks and suggests specific indexing or query restructuring techniques like using EXISTS instead of IN for large subqueries.

PostgreSQL Advanced Patterns

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

byorganvm-iv-taxis

•

データベース管理

Implements high-performance PostgreSQL strategies including advanced indexing, complex query optimization, and scalable database design.

This skill provides specialized guidance for developers working with PostgreSQL, focusing on performance-critical applications and complex data modeling. It covers a wide range of advanced topics such as sophisticated indexing (GIN, GiST, Partial), window functions for data analysis, recursive CTEs for hierarchical data, and database-level optimization techniques like partitioning and materialized views. By integrating these patterns into your workflow, you can ensure your database remains performant under load while maintaining data integrity through advanced constraints and sophisticated transaction management.

主な機能

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

02Scalable architecture patterns like table partitioning and materialized views

03Complex data handling with JSONB operations and recursive queries

042 GitHub stars

05Concurrency management through transaction isolation levels and row-level locking

06Query optimization using EXPLAIN ANALYZE and CTEs

ユースケース

01Optimizing slow database queries in high-traffic production environments

02Implementing efficient analytical reporting using window functions and materialized views

03Designing complex data schemas for hierarchical or JSON-heavy datasets

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