Verified:GitHub

postgres-pro

Analyze PostgreSQL query execution plans and design efficient indexes.

Updated Mar 7, 2026

Search Tags:#postgresql #replication #performance monitoring #database administration #database optimization #sql tuning

Ready to run

npx skills add https://github.com/shalevamin/The-_Ultimate_agents --skill postgres-pro-shalevamin

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/shalevamin/The-_Ultimate_agents/tree/main/.claude/skills/postgres-pro
Command: npx skills add https://github.com/shalevamin/The-_Ultimate_agents --skill postgres-pro-shalevamin

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you optimize PostgreSQL performance, configure advanced features like replication, and manage database health effectively.

Core Features & Use Cases

Query Optimization: Analyze slow queries using EXPLAIN ANALYZE and design effective indexes.
Replication & Extensions: Set up streaming/logical replication and leverage powerful extensions like PostGIS and pgvector.
Database Maintenance: Tune VACUUM, monitor bloat, and ensure database stability.
Use Case: You have a slow-running query impacting your application. Use this Skill to analyze the query plan, identify bottlenecks, create an optimal index, and verify the performance improvement.

Quick Start

Use the postgres-pro skill to analyze the performance of the following SQL query: SELECT * FROM users WHERE created_at < NOW() - INTERVAL '30 days';

Frequently Asked Questions about postgres-pro

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I optimize slow PostgreSQL queries using execution plans?▼

PostgreSQL query optimization involves analyzing execution plans using `EXPLAIN ANALYZE` to identify bottlenecks, designing efficient indexes, and verifying the performance improvement. This targets query tuning and planning directly.

What's the best way to set up PostgreSQL streaming or logical replication?▼

Setting up PostgreSQL replication involves configuring streaming or logical replication to establish high availability. This requires understanding PostgreSQL internals and system administration best practices to ensure database stability.

Can I use PostgreSQL extensions like PostGIS and pgvector for complex data manipulation?▼

Yes, you can leverage PostgreSQL extensions like PostGIS and pgvector for complex data manipulation. These specialized tools extend database functionality, allowing you to handle advanced spatial and vector data use cases effectively.

How do I tune PostgreSQL VACUUM and monitor database bloat?▼

Tuning PostgreSQL VACUUM and monitoring bloat requires adjusting system administration settings to maintain database health. Configuring VACUUM properly manages dead tuples and ensures long-term database stability and performance monitoring.

Why does PostgreSQL query planning impact database performance monitoring?▼

PostgreSQL query planning impacts performance monitoring because the planner determines execution strategies. Understanding these internals allows you to design effective indexes, address tuning challenges, and optimize complex SQL data manipulation.