# postgres-mcp

> postgres-mcp — leon-achteresch-postgres-mcp. Use this tool when you need to manage and optimize PostgreSQL databases across multiple instances, as it enables schema exploration, safe SQL execution, and performance analysis through EXPLAIN and index recommendations. It solves problems related to database health, query optimization, and security through health checks and controlled execution. The tool accepts database connections as input and provides actionable insights and recommendations as output.

Canonical page: https://skillsregistry.net/skills/leon-achteresch-postgres-mcp  
JSON: https://api.skillsregistry.net/v1/skills/leon-achteresch-postgres-mcp

## Description

MCP server for PostgreSQL that enables schema exploration, safe SQL execution, EXPLAIN analysis, health checks, and index recommendations across multiple databases.

## Trust

- **Trust score (0–1):** 0.68
- **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/kkf7o7bz34)
- **Repository:** <https://github.com/Leon-Achteresch/postgres-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": "leon-achteresch-postgres-mcp"
    }
  }
}
```

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