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

•

数据库管理

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.

主要功能

Advanced indexing strategies for diverse workloads (B-tree, GIN, GiST, BRIN)
Configuration of streaming and logical replication for high availability
7 GitHub stars
Expert query tuning and bottleneck identification using EXPLAIN ANALYZE
Implementation of high-performance JSONB storage and containment indexing
Database maintenance optimization including autovacuum tuning and bloat tracking

使用场景

Implementing vector search capabilities for AI applications using pgvector
Identifying and rewriting slow-running production queries to reduce latency
Scaling database performance through sophisticated indexing and connection pooling

关于

主要功能

Advanced indexing strategies for diverse workloads (B-tree, GIN, GiST, BRIN)
Configuration of streaming and logical replication for high availability
7 GitHub stars
Expert query tuning and bottleneck identification using EXPLAIN ANALYZE
Implementation of high-performance JSONB storage and containment indexing
Database maintenance optimization including autovacuum tuning and bloat tracking

使用场景

Implementing vector search capabilities for AI applications using pgvector
Identifying and rewriting slow-running production queries to reduce latency
Scaling database performance through sophisticated indexing and connection pooling