skills.rest
ahrav
ahravCOMMUNITY
Explore all skills by this author →
GitHub

postgres-review

Review PostgreSQL schemas, queries, indexes, and configuration using database metrics.

1|Updated Feb 12, 2026
Search Tags:#postgresql#configuration#performance tuning#database optimization#sql review#index analysis
One-click install
npx skills add https://github.com/ahrav/Gossip-rs --skill postgres-review
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-review
Source: https://github.com/ahrav/Gossip-rs/tree/main/.claude/skills/postgres-review
Command: npx skills add https://github.com/ahrav/Gossip-rs --skill postgres-review

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps you identify and resolve performance bottlenecks, security vulnerabilities, and operational inefficiencies in your PostgreSQL databases.

Core Features & Use Cases

  • Performance Tuning: Analyzes query plans, indexes, and configuration for speed improvements.
  • Schema & Index Auditing: Detects missing indexes, inefficient data types, and bloat.
  • Configuration Review: Recommends optimal settings for memory, I/O, and WAL.
  • Migration Safety: Assesses DDL operations for potential downtime and lock contention.
  • Use Case: A critical application is experiencing slow response times. Use this Skill to pinpoint the exact queries, indexes, or configuration issues causing the slowdown and receive actionable recommendations.

Quick Start

Use the postgres-review skill to analyze the performance of the 'production' PostgreSQL database.

Frequently Asked Questions about postgres-review

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

FAQPage Schema
How do I find and fix slow PostgreSQL queries?▼

Slow PostgreSQL queries are identified by running EXPLAIN ANALYZE and reviewing query plans, indexes, and configuration. This Skill connects to your database to gather concrete metrics from pg_stat_* views, pinpointing exact performance bottlenecks and providing actionable tuning recommendations.

What is the best way to audit PostgreSQL indexes and schema bloat?▼

Auditing PostgreSQL schema bloat involves calculating table and index statistics to detect inefficient data types and missing indexes. This Skill analyzes your database structure using bloat calculations and pg_stat_* views to identify wasted space and recommend optimizations for database reliability.

How do I check if a database migration will cause lock contention?▼

Checking database migration safety requires assessing DDL operations for potential downtime and lock contention. This Skill audits your migration scripts to identify operations that could block production traffic, ensuring schema changes are applied without causing availability issues.

Can I optimize PostgreSQL configuration settings for memory and WAL?▼

Optimizing PostgreSQL configuration requires analyzing memory, I/O, and WAL settings against actual database workloads. This Skill reviews your current server configuration and recommends optimal parameters based on concrete evidence gathered from your live database environment.

When do I need PostgreSQL partitioning for performance tuning?▼

PostgreSQL partitioning is needed when large tables cause query performance degradation and maintenance overhead. This Skill reviews your partitioning strategy by analyzing query plans and table statistics, recommending structural changes to improve scan speeds and data management.

Does PostgreSQL performance tuning require access to the live production database?▼

PostgreSQL performance tuning requires connecting to the actual database to gather concrete evidence from EXPLAIN ANALYZE and pg_stat_* views. This Skill relies on live metrics rather than static schema files to provide accurate, actionable recommendations backed by real workload data.

Related Skills

Explore More Software Engineering Skills→
gemini-cli-extensionsgemini-cli-extensions
42

cloud-sql-postgres-monitor

Fetch PromQL metrics, EXPLAIN plans, and active queries for Cloud SQL PostgreSQL.

Official
Intermediate
curiositechcuriositech
181

postgresql-optimization

Analyze EXPLAIN ANALYZE output and tune PostgreSQL indexes and configuration.

Official
Advanced
Sir-chawakornSir-chawakorn
9

db-migration-safety

Evaluates database migration scripts for lock risks and destructive SQL operations.

Community
Advanced
odeciojuniorodeciojunior

sql-server-toolkit

Route SQL Server tasks to specialist agents for diagnostics, tuning, and review.

Community
Intermediate