🎯

postgres-pro

🎯Skill

from jeffallan/claude-skills

What it does

Senior PostgreSQL expert skill covering query optimization with EXPLAIN ANALYZE, JSONB operations, streaming and logical replication, extension usage, VACUUM tuning, and database health monitoring with pg_stat views.

Overview

Postgres Pro is a senior-level PostgreSQL skill that provides deep expertise in database administration, performance optimization, and advanced PostgreSQL features. It covers query optimization with EXPLAIN ANALYZE, JSONB operations and indexing, streaming and logical replication, extension usage (PostGIS, pgvector, pg_trgm), and database maintenance with VACUUM and autovacuum tuning.

Key Features

Query Performance Optimization - EXPLAIN ANALYZE-based query tuning, index design (B-tree, GIN, GiST, BRIN), and statistics management
JSONB Operations - Comprehensive guidance on JSONB operators, containment queries, and GIN indexing strategies for JSON data
Replication Setup - Configuration guides for both streaming replication (high availability) and logical replication with failover planning
Extension Ecosystem - Usage guidance for PostGIS, pg_trgm, pgvector, uuid-ossp, and pg_stat_statements
Database Maintenance - VACUUM tuning, autovacuum configuration, bloat tracking, and health monitoring with pg_stat views

Who is this for?

This skill is for PostgreSQL DBAs and backend developers who need expert guidance on database optimization, replication, and maintenance. It is particularly valuable for teams running production PostgreSQL databases who need to optimize query performance, set up high availability, or work with advanced features like JSONB, PostGIS, or pgvector.

📦

Same repository

jeffallan/claude-skills(66 items)

postgres-pro

Installation

Vibe Index InstallInstalls to .claude/skills/ - auto-recognized by Claude Code

npx vibeindex add jeffallan/claude-skills --skill postgres-pro

skills.sh Install⚠ Installs to .agents/skills/ - may not be auto-recognized by Claude Code

npx skills add jeffallan/claude-skills --skill postgres-pro

Manual InstallCopy SKILL.md content and save to the path below

~/.claude/skills/postgres-pro/SKILL.md

SKILL.md

2,651Installs

236

Last UpdatedJan 29, 2026

View on GitHub Back to Skills

More from this repository10

🎯

laravel-specialist🎯Skill

A collection of 65 Claude Code skills and 9 workflows with progressive disclosure, covering full-stack development including Flutter expertise, context engineering, and Atlassian integration.

🎯

golang-pro🎯Skill

A Go (Golang) expert skill from the jeffallan/claude-skills collection, providing Claude Code with context-aware Go development knowledge including concurrency patterns, idioms, and best practices across 66 specialized skills.

🎯

flutter-expert🎯Skill

A collection of 65 Claude Code skills and 9 workflows with progressive disclosure, covering full-stack development including Flutter expertise, context engineering, and Atlassian integration.

🎯

kubernetes-specialist🎯Skill

Expert guidance for Kubernetes cluster management, deployments, troubleshooting, Helm charts, and kubectl operations.

🎯

php-pro🎯Skill

A collection of 65 Claude Code skills and 9 workflows with progressive disclosure, covering full-stack development including context engineering and Atlassian integration.

🎯

spring-boot-engineer🎯Skill

Provides Spring Boot development patterns including REST APIs, dependency injection, JPA persistence, security configuration, and testing best practices

🎯

devops-engineer🎯Skill

Provides DevOps engineering guidance for CI/CD, infrastructure automation, and cloud deployment, from a collection of 65 skills and 9 workflows built for full-stack developers.

🎯

wordpress-pro🎯Skill

A collection of 65 Claude Code skills and 9 workflows with progressive disclosure, covering full-stack development including context engineering and Atlassian integration.

🎯

websocket-engineer🎯Skill

Provides WebSocket implementation patterns including real-time bidirectional communication, connection management, message handling, and error recovery

🎯

sql-pro🎯Skill

A collection of 65 Claude Code skills and 9 workflows with progressive disclosure, covering full-stack development including context engineering and Atlassian integration.