# pgtriage

> pgtriage — pgtriage-pgtriage. Use this tool when you need to audit and optimize PostgreSQL performance, identify potential issues with indexing, queries, and configuration, and collect key metrics for informed decision-making. It takes PostgreSQL system views as input and returns structured findings, making it ideal for troubleshooting and performance tuning use cases. By applying deterministic checks, pgtriage helps solve problems related to query optimization, vacuum management, and connection issues.

Canonical page: https://skillsregistry.net/skills/pgtriage-pgtriage  
JSON: https://api.skillsregistry.net/v1/skills/pgtriage-pgtriage

## Description

Read-only PostgreSQL performance auditing via MCP. Collects metrics from PostgreSQL system views, applies deterministic checks for index, query, vacuum, configuration, and connection issues, and returns structured findings for MCP clients.

## Trust

- **Trust score (0–1):** 0.69
- **Verification tier:** scanned
- **Last scanned:** 2026-08-29

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-08-29

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/udzjg7xxj1)
- **Repository:** <https://github.com/pgtriage/pgtriage>

## 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": "pgtriage-pgtriage"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/pgtriage-pgtriage` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/pgtriage-pgtriage/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