# MCP-PostgreSQL-Ops

> MCP-PostgreSQL-Ops — zimmermann34-mcp-postgresql-ops. Use this tool when you need to analyze and optimize PostgreSQL database performance, detect bloat, and monitor locks and deadlocks. It provides 30+ tools for DBA tasks, including autovacuum and schema inspection, without requiring extensions, supporting PostgreSQL versions 12-18. Ideal for AI assistants managing PostgreSQL databases, it offers a comprehensive interface for inputting database credentials and outputting detailed performance metrics and recommendations.

Canonical page: https://skillsregistry.net/skills/zimmermann34-mcp-postgresql-ops  
JSON: https://api.skillsregistry.net/v1/skills/zimmermann34-mcp-postgresql-ops

## Description

🐘 Give AI assistants full PostgreSQL DBA superpowers — 30+ tools for performance analysis, bloat detection, lock/deadlock monitoring, autovacuum & schema inspection. No extensions required. PG 12-18.

## Trust

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

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** container
- **Runtime environment:** vm
- **Updated:** 2026-10-18

## Source

- **Source listing:** [GitHub](https://github.com/zimmermann34/MCP-PostgreSQL-Ops)

## 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": "zimmermann34-mcp-postgresql-ops"
    }
  }
}
```

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