Does this skill support modern AI features like vector search?

Yes, it includes deep expertise in the pgvector extension for implementing efficient similarity searches within your PostgreSQL database.

What maintenance tasks does this skill cover?

It assists with autovacuum tuning, VACUUM/ANALYZE scheduling, bloat monitoring, and general database health checks using pg_stat views.

How does PostgreSQL Pro help with slow database queries?

It analyzes execution plans via EXPLAIN ANALYZE to pinpoint bottlenecks and provides specific query rewrites or index recommendations to improve performance.

Can it help me manage semi-structured data?

Absolutely. It provides specialized patterns for JSONB operations, including containment operators and GIN indexing for high-speed document retrieval.

Is it suitable for high-availability production environments?

Yes, it provides implementation patterns for both streaming and logical replication, as well as guidance on connection pooling with tools like pgBouncer.

PostgreSQL Pro

Name: PostgreSQL Pro
Author: Jeffallan

byJeffallan

•

Database Management

Optimizes PostgreSQL performance, manages complex database administration tasks, and implements advanced indexing and replication strategies.

PostgreSQL Pro transforms Claude into a senior database administrator with over a decade of production experience. This skill provides expert-level guidance on query optimization using EXPLAIN ANALYZE, sophisticated indexing strategies (including GIN, GiST, and BRIN), and the implementation of advanced features like JSONB and pgvector. It is designed to help developers build and maintain high-performance, scalable database systems while ensuring best practices in maintenance, security, and high availability are strictly followed.

Key Features

01Advanced indexing strategies for diverse workloads (B-tree, GIN, GiST, BRIN)

02Configuration of streaming and logical replication for high availability

037 GitHub stars

04Expert query tuning and bottleneck identification using EXPLAIN ANALYZE

05Implementation of high-performance JSONB storage and containment indexing

06Database maintenance optimization including autovacuum tuning and bloat tracking

Use Cases

01Implementing vector search capabilities for AI applications using pgvector

02Identifying and rewriting slow-running production queries to reduce latency

03Scaling database performance through sophisticated indexing and connection pooling

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeffallan/claude-skills postgres-pro

For use in Claude.ai and ChatGPT

Download Skill