postgres-best-practices

Community

Optimize your Postgres database performance.

AuthorAratKruglik
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses common performance bottlenecks in PostgreSQL databases, helping users write more efficient queries, design better schemas, and configure their databases for optimal speed and stability.

Core Features & Use Cases

  • Query Optimization: Provides rules for indexing, query planning, and avoiding full table scans.
  • Schema Design: Offers best practices for data types, primary keys, and partitioning.
  • Connection Management: Guides on connection pooling, timeouts, and limits to prevent resource exhaustion.
  • Use Case: A developer is experiencing slow query times on their application's user data. They can use this Skill to identify missing indexes or inefficient query patterns and receive concrete SQL examples for improvement.

Quick Start

Use the postgres-best-practices skill to find rules for optimizing slow queries.

Dependency Matrix

Required Modules

None required

Components

scriptsreferencesassets

💻 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-best-practices
Download link: https://github.com/AratKruglik/claude-laravel/archive/main.zip#postgres-best-practices

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.