How does this skill help with slow database queries?

It provides a framework for interpreting EXPLAIN ANALYZE results to pinpoint the exact cause of slowness, such as sequential scans or high cost nodes.

Can this skill help with multi-tenant data security?

Yes, it includes specific patterns and guidance for implementing Row Level Security (RLS) to ensure data isolation at the database layer.

What types of PostgreSQL indexes are supported?

It covers a wide range of indexing strategies including B-tree, GIN, GiST, BRIN, partial, covering, and composite indexes.

Does it include tools for connection management?

Yes, it provides references and scripts for configuring PgBouncer, diagnosing connection leaks, and managing pool sizing.

PostgreSQL Performance Deep Dive

Name: PostgreSQL Performance Deep Dive
Author: rnavarych

byrnavarych

•

データベース管理

Optimizes PostgreSQL performance through advanced indexing strategies, query plan analysis, and sophisticated connection pooling configurations.

This skill equips Claude with the expertise of a senior Database Administrator to perform deep-dive PostgreSQL optimizations. It provides systematic guidance for interpreting EXPLAIN ANALYZE results, selecting appropriate index types like GIN or BRIN, and implementing advanced features such as Row Level Security (RLS) and window functions. By integrating query anti-pattern detection and PgBouncer configuration, it helps developers resolve performance bottlenecks, manage connection scaling, and ensure secure multi-tenant data architecture.

主な機能

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

02Implementation of Row Level Security (RLS) for multi-tenant applications

03Automated slow query analysis via pg_stat_statements scripts

04Detailed EXPLAIN ANALYZE interpretation and query plan optimization

05Connection pooling setup and diagnostics using PgBouncer

069 GitHub stars

ユースケース

01Designing efficient indexing patterns for complex data access requirements

02Configuring database connection pooling for high-traffic applications

03Identifying and fixing performance bottlenecks in slow SQL queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer shared

For use in Claude.ai and ChatGPT

Download Skill