Skills
.Work. You
Rest

postgresql-optimization

Community

Tune PostgreSQL for peak performance.

Software Engineering#performance#indexing#postgresql#sql#query tuning#database optimization
AuthorAratKruglik
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses slow database queries and performance bottlenecks in PostgreSQL, ensuring efficient data retrieval and application responsiveness.

Core Features & Use Cases

  • Query Tuning: Analyzes and optimizes slow-running SQL queries using EXPLAIN ANALYZE.
  • Indexing Strategies: Recommends and implements optimal indexing for faster data access.
  • Configuration Tuning: Adjusts PostgreSQL parameters like shared_buffers and work_mem for better resource utilization.
  • Maintenance: Schedules and manages essential tasks like VACUUM and ANALYZE.
  • Use Case: When your e-commerce application experiences slow product searches, this Skill can identify the problematic queries, suggest appropriate indexes, and tune the database configuration to speed up search results significantly.

Quick Start

Use the postgresql-optimization skill to analyze and tune the performance of the 'products' table.

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: postgresql-optimization
Download link: https://github.com/AratKruglik/claude-laravel/archive/main.zip#postgresql-optimization

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 223,000+ vetted skills library on demand.