skills.rest
junaid-ali-ruk
junaid-ali-rukCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/junaid-ali-ruk/auto-linkedin --skill postgres-pro-junaid-ali-ruk
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
dieu-donneedieu-donnee

postgres-pro

Identify and optimize slow PostgreSQL queries using EXPLAIN ANALYZE and VACUUM tuning.

Community
Advanced
manutejmanutej
61

postgresql-database-engineering

Optimize PostgreSQL queries and schemas with indexing, partitioning, replication, and VACUUM maintenance.

Community
Advanced
EstomEstom

postgres-pro

Optimize PostgreSQL queries, replication, and maintenance with EXPLAIN ANALYZE.

Community
Advanced
sempervinceresempervincere
2

supabase-postgres-best-practices

Provide Postgres query optimization and schema design best practices for Supabase.

Community
Advanced