skills.rest
VoTruongDanh
VoTruongDanhCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

postgres-expert

Optimize PostgreSQL queries, JSONB indexing, configuration, and replication setups.

Updated Jan 15, 2026
Search Tags:#query optimization#indexing#postgresql#performance tuning#database administration#jsonb
One-click install
npx skills add https://github.com/VoTruongDanh/Sentiment --skill postgres-expert-votruongdanh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/VoTruongDanh/Sentiment/tree/main/.agent/skills/postgres-expert
Command: npx skills add https://github.com/VoTruongDanh/Sentiment --skill postgres-expert-votruongdanh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses complex PostgreSQL query optimization, JSONB operations, indexing, and administrative challenges, helping database administrators and developers improve performance and reliability.

Core Features & Use Cases

  • Query Optimization: Fine-tune slow-running queries using EXPLAIN and index strategies.
  • JSONB Management: Efficiently query and index JSONB data for fast retrieval.
  • System Tuning & Maintenance: Suggest configuration settings, perform vacuum analysis, and manage replication setups.
  • Use Case: A developer needs to optimize complex queries involving JSONB data stored in a large table to reduce latency and improve throughput.

Quick Start

Use the PostgreSQL environment detection commands to identify version and configuration details, then analyze slow queries with EXPLAIN and improve index usage accordingly.

Frequently Asked Questions about postgres-expert

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

FAQPage Schema
How do I optimize slow PostgreSQL queries using EXPLAIN?▼

To optimize slow PostgreSQL queries, you analyze execution plans using EXPLAIN to identify bottlenecks and apply targeted index strategies. This Skill provides expert guidance on fine-tuning queries to significantly reduce latency and improve database throughput.

What is the best way to index and query JSONB data in PostgreSQL?▼

Indexing JSONB data in PostgreSQL involves applying specialized index strategies to ensure fast retrieval of nested values. This Skill helps you efficiently manage, query, and index JSONB data within large tables to minimize performance overhead.

Can I use this for PostgreSQL configuration tuning and vacuum analysis?▼

Yes, this Skill supports PostgreSQL configuration tuning and vacuum analysis to maintain high performance and stability. It evaluates environment metrics and suggests optimal configuration settings tailored for database administrators.

How do I set up PostgreSQL replication for high availability?▼

Setting up PostgreSQL replication involves configuring primary and standby nodes to ensure data redundancy and high availability. This Skill guides database administrators through managing replication setups and applying best practices for stable environments.

Why does my PostgreSQL database experience high latency on complex queries?▼

High latency on complex PostgreSQL queries often results from missing indexes, inefficient execution plans, or suboptimal configurations. This Skill helps you analyze environment metrics and apply query optimization best practices to resolve performance bottlenecks.

Related Skills

Explore More Software Engineering Skills→
ComposioHQComposioHQ
1.9k

perf-baseline-manager

Store and compare performance baselines as single JSON files per version.

Official
Basic
ScotterMonkScotterMonk
37

db-postgres

Analyze PostgreSQL and Supabase query execution plans and index strategies.

Community
Advanced
proyecto26proyecto26
42

distributed-search

Architects distributed search systems with indexing pipelines, sharding strategies, and BM25 ranking models.

Official
Advanced
L3DigitalNetL3DigitalNet
6

mariadb

Administer MariaDB and MySQL databases via direct command execution.

Official
Advanced