skills.rest
shalevamin
shalevaminCOMMUNITY
Explore all skills by this author →
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
One-click install
npx skills add https://github.com/shalevamin/The-_Ultimate_agents --skill postgres-pro-shalevamin
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
afonsoftafonsoft
1

sql-optimization

Optimize SQL queries and indexing across MySQL, PostgreSQL, SQL Server, and Oracle.

Community
Advanced
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced
an8079an8079
4

performance-tuning

Optimize application performance across concurrency, database, caching, and vector retrieval layers.

Community
Advanced
rnavarychrnavarych
14

role-database:newsql-distributed

Compare 12 NewSQL and distributed SQL databases for consistency and sharding.

Community
Advanced