postgres-pro — Skills — getagentictools

What it does

Analyzing and optimizing slow queries with EXPLAIN

Implementing JSONB storage and indexing strategies

Setting up streaming or logical replication

Configuring and using PostgreSQL extensions

Tuning VACUUM, ANALYZE, and autovacuum

Monitoring database health with pgstat views

Designing indexes for optimal performance

postgres pro

Source

Repository: https://github.com/jeffallan/claude-skills

postgres-pro FAQ

What does the postgres-pro skill do?

Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring. Analyzing and optimizing slow queries with EXPLAIN Implementing JSONB storage and indexing strategies

What does postgres-pro require?

Configuration keys: EXPLAIN, ANALYZE, CREATE, SELECT.

How do I install postgres-pro?

Run: npx -y skills add https://github.com/jeffallan/claude-skills --skill postgres-pro --agent claude-code — the source lives at github.com/jeffallan/claude-skills.

Maintain postgres-pro?

Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.

[![postgres-pro on getagentictools](https://getagentictools.com/badge/skills/jeffallan-claude-skills-postgres-pro.svg)](https://getagentictools.com/skills/jeffallan-claude-skills-postgres-pro?ref=badge)

npx agentictools info skills/jeffallan-claude-skills-postgres-pro

The second line is the CLI lookup for this page — handy in READMEs and docs.