# pgverdict

> pgverdict — svaca33-pgverdict. Use this tool when you need to optimize Postgres database performance by identifying hotspots, analyzing query plans, and detecting inefficient indexes. It solves problems related to slow query execution, resource bottlenecks, and ineffective indexing, providing evidence-backed recommendations for improvement. The tool takes database performance data as input and outputs actionable insights and suggestions for optimization.

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

## Description

Postgres performance MCP server that analyzes hotspots, explains query plans, and detects dead-weight indexes. It aims to produce evidence-backed recommendations through a verification loop.

## Trust

- **Trust score (0–1):** 0.66
- **Verification tier:** scanned
- **Last scanned:** 2026-09-03

## Facts

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

## Source

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

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

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