# pg-logical-mcp

> Use this tool when you need to diagnose and manage PostgreSQL logical replication issues, such as slot WAL retention and walsender lag, to ensure efficient database operations. It solves problems like stuck subscriptions and provides remediation tools for safe AI-driven operations. The tool accepts inputs like replication slot and subscription data, and outputs diagnostic reports and remediation recommendations.

Canonical page: https://skillsregistry.net/skills/esauro-pg-logical-mcp  
JSON: https://api.skillsregistry.net/v1/skills/esauro-pg-logical-mcp

## Description

Diagnoses and manages PostgreSQL logical replication including slot WAL retention, walsender lag, stuck subscriptions, and provides gated remediation tools for safe AI-driven operations.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/jgi7dsd59y)
- **Repository:** <https://github.com/esauro/pg-logical-mcp>

## 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": "esauro-pg-logical-mcp"
    }
  }
}
```

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