postgres-pro

Provide PostgreSQL guidance for query optimization, replication, and advanced features.

Updated Feb 4, 2026

Search Tags:#query optimization #postgresql #replication #extensions #postgres #vacuum #explain analyze

Ready to run

npx skills add https://github.com/junaid-ali-ruk/auto-linkedin --skill postgres-pro-junaid-ali-ruk

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/junaid-ali-ruk/auto-linkedin/tree/main/.gemini/skills/postgres-pro
Command: npx skills add https://github.com/junaid-ali-ruk/auto-linkedin --skill postgres-pro-junaid-ali-ruk

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides expert guidance to optimize PostgreSQL queries, configure replication, and leverage advanced features like JSONB, extensions, and VACUUM tuning, reducing latency and operational risk.

Core Features & Use Cases

Query optimization: analyze slow queries with EXPLAIN ANALYZE and implement effective indexing and statistics strategies.
Replication & HA: design and implement streaming or logical replication for high availability and disaster recovery.
Advanced features & maintenance: guide usage of JSONB, extensions, and maintenance tasks with best practices across Postgres versions.

Quick Start

Load the PostgreSQL Pro guidance and performance references from the references directory to begin optimizing a live database.

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 EXPLAIN ANALYZE?▼

Use EXPLAIN ANALYZE to identify execution bottlenecks in slow PostgreSQL queries, then apply effective indexing and statistics strategies. This skill provides actionable code templates to reduce latency in production databases.

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

Design and implement streaming or logical replication to establish PostgreSQL high availability and disaster recovery. This skill delivers reference guidance and templates for configuring replication across Postgres environments.

How does VACUUM tuning improve PostgreSQL maintenance and performance?▼

VACUUM tuning improves PostgreSQL maintenance by reclaiming storage and updating query planner statistics. This skill provides best practices and maintenance templates to tune VACUUM processes across Postgres versions.

Can I use JSONB and Postgres extensions to handle advanced data features?▼

Yes, you can leverage JSONB and Postgres extensions to handle advanced data features. This skill offers reference guidance and code samples to implement these features while maintaining best practices across your database environment.

Do I need a specific Postgres version to use advanced replication and maintenance features?▼

No specific version is strictly required, as this skill applies maintenance and replication guidance across Postgres environments. It provides best practices and templates for tuning VACUUM and configuring replication across various Postgres versions.