# postgres-perf

> Use this tool when you need to optimize and fine-tune PostgreSQL database performance, solving issues like slow queries, inefficient indexing, and suboptimal configuration. It provides best practices and expert guidance to improve database reliability, speed, and scalability. Input includes database metrics and configuration, outputting actionable recommendations for improvement.

Canonical page: https://skillsregistry.net/skills/kjaylee-postgres-perf  
JSON: https://api.skillsregistry.net/v1/skills/kjaylee-postgres-perf

## Description

PostgreSQL performance optimization and best practices.

## Trust

- **Trust score (0–1):** 0.60
- **Verification tier:** unverified

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** instructions
- **Runtime environment:** llm
- **Category:** database
- **Updated:** 2026-05-18

## Source

- **Source listing:** [ClawHub](https://clawskills.sh/skills/kjaylee-postgres-perf)

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "kjaylee-postgres-perf"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/kjaylee-postgres-perf` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/kjaylee-postgres-perf/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt