# postgres-aiops

> postgres-aiops — aiops-tools-postgres-aiops. Use this tool when you need to automate and optimize PostgreSQL database administration tasks, such as identifying and resolving slow queries, bloat, and blocking locks, with features like audit logging and budget guards. It provides a governed interface for DBA operations, including index management, vacuum and analyze, and replication lag monitoring. Ideal for use cases requiring robust database performance management and compliance tracking.

Canonical page: https://skillsregistry.net/skills/aiops-tools-postgres-aiops  
JSON: https://api.skillsregistry.net/v1/skills/aiops-tools-postgres-aiops

## Description

Governed PostgreSQL DBA operations — slow-query, bloat, and blocking-lock RCA, index management, vacuum/analyze, and replication lag, with  unbypassable audit logging (MCP + CLI), budget/runaway guards, dry-run, and undo/rollback.

## Trust

- **Trust score (0–1):** 0.67
- **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/sm5z869czy)
- **Repository:** <https://github.com/AIops-tools/Postgres-AIops>

## 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": "aiops-tools-postgres-aiops"
    }
  }
}
```

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