postgres-pro
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features.
Source: Jeffallan
At a glance
- Best for
- Analyzing and optimizing slow queries with EXPLAIN
- Works with
- Claude Code
- Outcome
- Implementing JSONB storage and indexing strategies
- Source
- Jeffallan/claude-skills
01 / Understand the skill
About postgres-pro
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
02 / Confirm the fit
Use postgres-pro when you need to
- 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 pg_stat views
- Designing indexes for optimal performance
Check before installing
Compatible platforms
Claude Code
Best fit
Analyzing and optimizing slow queries with EXPLAIN
Review the source instructions if the required output differs from the formats described above.
Install and use
Compatible with Claude Code · Published by Jeffallan
Ready to add postgres-pro?
Use the published instructions below, then provide the required input and describe the result you need.
General instructions · Claude Code
npx -y skills add Jeffallan/claude-skills --skill postgres-pro --agent claude-code
Review the source repository and license before installing third-party skills.
Continue exploring
Similar skills
Writes and runs KQL against Azure Data Explorer (Kusto/ADX) for log, telemetry, and time-series analysis, with schema discovery and az CLI fallback.
Guides Azure Storage operations and decisions across Blob, Files, Queue, Table, and Data Lake, including access tiers, redundancy, lifecycle, and SDK usage.
Optimizes Snowflake query performance using query ID from history.
Optimizes SQL queries, designs database schemas, and troubleshoots performance issues.