skills.rest
duwscan
duwscanCOMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

Analyze PostgreSQL query execution plans and design indexes.

Updated Feb 12, 2026
Search Tags:#query optimization#database#postgresql#sql#replication#performance tuning#dba
One-click install
npx skills add https://github.com/duwscan/skills-graph --skill postgres-pro-duwscan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/duwscan/skills-graph/tree/main/.agents/skills/postgres-pro
Command: npx skills add https://github.com/duwscan/skills-graph --skill postgres-pro-duwscan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you optimize PostgreSQL performance, configure advanced features, and manage your database effectively, ensuring reliability and speed.

Core Features & Use Cases

  • Query Optimization: Analyze slow queries using EXPLAIN ANALYZE and implement effective indexing strategies.
  • Advanced Features: Configure and utilize PostgreSQL extensions like PostGIS, pgvector, and TimescaleDB.
  • Replication & Maintenance: Set up streaming or logical replication and tune database maintenance tasks like VACUUM and ANALYZE.
  • Use Case: You have a PostgreSQL query that is running too slowly. Use this Skill to analyze the query plan, identify bottlenecks, and receive recommendations for index creation or query rewriting.

Quick Start

Use the postgres-pro skill to analyze the performance of the following SQL query: SELECT * FROM users WHERE created_at < NOW() - INTERVAL '1 day';

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 execution plans?▼

PostgreSQL replication can be set up using either streaming or logical replication strategies. This Skill facilitates configuring these replication methods to ensure database reliability and high availability across different server instances.

Can I use PostgreSQL extensions like PostGIS and pgvector for advanced features?▼

Yes, you can configure and utilize PostgreSQL extensions like PostGIS, pgvector, and TimescaleDB. This Skill supports implementing these advanced features, including JSONB operations, to handle complex data types and spatial or vector workloads.

What is the best way to tune PostgreSQL configuration and maintenance tasks?▼

The best way to tune PostgreSQL configuration is by adjusting database parameters and managing maintenance tasks. This Skill helps tune VACUUM, ANALYZE, and monitor performance using pg_stat views to ensure speed and reliability.

When do I need different PostgreSQL index types like GIN or BRIN?▼

You need different PostgreSQL index types like GIN or BRIN when default indexes do not meet performance requirements. This Skill designs appropriate indexing strategies based on query execution plans to optimize specific database workloads.

Does this Skill support monitoring PostgreSQL performance with pg_stat views?▼

Yes, this Skill supports monitoring PostgreSQL performance using pg_stat views. It helps you tune database maintenance tasks and configuration parameters based on the statistics gathered from these monitoring views.

Related Skills

Explore More Software Engineering Skills→
chatermchaterm
50

sql-optimization

Analyze SQL execution plans and optimize indexes for MySQL and PostgreSQL queries.

Community
Intermediate
hotriluanhotriluan
3

databases

Design, query, and administer MongoDB and PostgreSQL databases.

Community
Intermediate
jayantrohila57jayantrohila57

drizzle-orm

Define TypeScript database schemas and write type-safe SQL queries.

Community
Intermediate
AndyAnh174AndyAnh174

database-optimizer

Optimize relational and cloud database performance through index tuning and query rewriting.

Community
Advanced