skills.rest
thepradip
thepradipCOMMUNITY
Explore all skills by this author →
GitHub

postgres-expert

Optimize PostgreSQL workloads with query, index, and administration guidance.

Updated Mar 12, 2026
Search Tags:#indexing#database#performance-tuning#query-optimization#postgres#schema-design
One-click install
npx skills add https://github.com/thepradip/openfangclaw --skill postgres-expert-thepradip
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/thepradip/openfangclaw/tree/main/crates/openfang-skills/bundled/postgres-expert
Command: npx skills add https://github.com/thepradip/openfangclaw --skill postgres-expert-thepradip

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL tuning and administration can be complex, leading to slow queries, inefficient schemas, and brittle maintenance processes. This Skill provides expert guidance to diagnose and optimize PostgreSQL workloads end-to-end.

Core Features & Use Cases

  • Expert guidance on query optimization, index selection, and plan analysis with EXPLAIN (ANALYZE, BUFFERS)
  • Schema design recommendations balancing normalization with read performance, plus maintenance and monitoring best practices
  • Practical strategies for partitioning, vacuuming, and configuration tuning across OLTP and analytical workloads

Use cases include accelerating slow reporting queries, scaling high-transaction systems, and designing robust schemas for evolving data needs.

Quick Start

Provide a slow or problematic query and receive an optimization plan with index recommendations and configuration tweaks.

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

PostgreSQL query optimization uses EXPLAIN (ANALYZE, BUFFERS) plan analysis to diagnose slow performance and recommend indexes. This Skill provides expert guidance on interpreting execution plans and selecting B-tree, GIN, GiST, or BRIN indexes to accelerate problematic queries.

What's the best way to design PostgreSQL schemas for mixed OLTP and analytical workloads?▼

PostgreSQL schema design for mixed workloads balances normalization with read performance. This Skill provides expert recommendations on partitioning strategies and schema structures tailored for high-transaction systems and reporting queries across evolving data needs.

How do I configure VACUUM and ANALYZE routines for production PostgreSQL databases?▼

VACUUM and ANALYZE routines maintain production PostgreSQL health by reclaiming storage and updating planner statistics. This Skill offers expert maintenance strategies and configuration tuning to keep operational administration robust across various workloads.

When do I need BRIN or GIN indexes instead of standard B-tree in PostgreSQL?▼

BRIN and GIN indexes optimize specific PostgreSQL data patterns like large sorted tables and full-text search better than standard B-tree. This Skill provides expert index selection guidance based on your workload and plan analysis.

Can I safely make PostgreSQL configuration changes in a production environment?▼

Production PostgreSQL configuration changes require safe guardrails to prevent downtime. This Skill delivers expert-level recommendations for tuning and maintenance tasks with built-in safety checks for production database environments.

Why does PostgreSQL performance degrade with high-transaction systems and how do I tune it?▼

PostgreSQL performance degrades in high-transaction systems due to inefficient schemas, missing indexes, or poor configuration. This Skill diagnoses these bottlenecks and provides expert tuning for scaling high-transaction OLTP workloads.

Related Skills

Explore More Software Engineering Skills→
ginkidaginkida
20

postgres-expert

Diagnose PostgreSQL performance bottlenecks using EXPLAIN plan analysis.

Community
Advanced
NguyenvanleNguyenvanle

supabase-postgres-best-practices

Optimize Postgres performance with Supabase best practices for querying, indexing, and partitioning.

Community
Advanced
manutejmanutej
61

postgresql-database-engineering

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

Community
Advanced
Khoatran1999Khoatran1999

databases

Design schemas, optimize queries, and manage maintenance for MongoDB and PostgreSQL.

Community
Advanced