skills.rest
Axel-DaMage
Axel-DaMageCOMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

Analyze PostgreSQL EXPLAIN output and manage JSONB, replication, and VACUUM tasks.

2|Updated Jun 29, 2026
Search Tags:#query optimization#database management#advanced features#PostgreSQL#performance monitoring
One-click install
npx skills add https://github.com/Axel-DaMage/opencode-config --skill postgres-pro-axel-damage
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/Axel-DaMage/opencode-config/tree/main/skills/postgres-pro
Command: npx skills add https://github.com/Axel-DaMage/opencode-config --skill postgres-pro-axel-damage

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires postgresql, pg_stat_statements, jsonb, replication, and includes scripts (resource) and references (resource) components.

What problem does it solve?

The postgres-pro Skill streamlines the complex process of PostgreSQL database management and advanced feature implementation, empowering users with deep database insights, optimized query execution, and enhanced data security.

Core Features & Use Cases

  • Advanced Query Optimization: Perform in-depth EXPLAIN analysis for precise performance tuning.
  • Database Feature Implementation: Setup and manage JSONB, replication, and advanced indexing with confidence.
  • Monitoring and Maintenance: Track database health with pg_stat views and efficiently handle VACUUM and autovacuum tasks.
  • Use Case: When you need to optimize a complex query, set up JSONB data storage, configure replication, or tune the VACUUM process for a high-performance PostgreSQL deployment.

Quick Start

Run the EXPLAIN ANALYZE query on a slow-running query to identify bottlenecks.

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 analysis?▼

PostgreSQL query optimization uses EXPLAIN ANALYZE to identify execution bottlenecks. Running this on slow queries exposes scan methods and join overhead, enabling precise performance tuning through advanced indexing and execution plan adjustments.

What is the best way to configure PostgreSQL replication and JSONB storage?▼

Configuring PostgreSQL replication and JSONB storage requires advanced database feature implementation. Setting up JSONB enables semi-structured data storage, while replication ensures high availability across multiple database nodes for robust deployments.

How does pg_stat_statements work for PostgreSQL performance monitoring?▼

pg_stat_statements tracks PostgreSQL execution statistics for performance monitoring. Querying pg_stat views reveals query frequency and execution time, providing comprehensive database health tracking to pinpoint inefficient operations requiring optimization.

When should I tune autovacuum and VACUUM processes in PostgreSQL?▼

PostgreSQL VACUUM and autovacuum tuning is needed when dead tuples accumulate and degrade performance. Adjusting these maintenance processes reclaims storage and prevents transaction ID wraparound, ensuring robust database health during heavy write operations.

Do I need pg_stat_statements and replication extensions to manage advanced PostgreSQL features?▼

Managing advanced PostgreSQL features requires the pg_stat_statements extension for performance monitoring and replication setup for high availability. These dependencies provide the necessary infrastructure for in-depth query optimization and robust database maintenance.

Why does my PostgreSQL query performance degrade without proper indexing and maintenance?▼

PostgreSQL query performance degrades without advanced indexing and regular maintenance due to inefficient execution plans and bloat. Utilizing EXPLAIN analysis and tuning VACUUM processes mitigates these constraints, restoring optimized query execution.

Related Skills

Explore More Software Engineering Skills→
bobmatnycbobmatnyc
20

PostgreSQL Performance Optimization

Analyze PostgreSQL 15+ queries, indexes, and configuration using EXPLAIN ANALYZE.

Community
Advanced
duwscanduwscan

postgres-pro

Analyze PostgreSQL query execution plans and design indexes.

Community
Advanced
Chengxufeng1994Chengxufeng1994

postgresql-optimization

Analyzes PostgreSQL queries with EXPLAIN ANALYZE and implements indexing strategies.

Community
Advanced
Thanh-aperoThanh-apero
1

databases

Guide MongoDB and PostgreSQL schema design, query optimization, and performance tuning.

Community
Advanced