Skills
.Work. You
Rest

postgres-review

Community

Optimize PostgreSQL performance and reliability.

Software Engineering#postgresql#configuration#performance tuning#database optimization#sql review#index analysis
Authorahrav
Version1.0.0
Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: postgres-review
Download link: https://github.com/ahrav/Gossip-rs/archive/main.zip#postgres-review

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.