# postgres-mcp

> Use this tool when you need to analyze and optimize PostgreSQL database performance, execute queries, or inspect schema. It solves problems related to database debugging, query optimization, and schema exploration by providing EXPLAIN and execution tools. It accepts SQL queries and database connections as inputs and outputs execution plans, results, and schema information for MCP-compatible clients.

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

## Description

Exposes PostgreSQL query execution, EXPLAIN, and schema inspection tools to MCP-compatible clients like Claude Desktop.

## Trust

- **Trust score (0–1):** 0.68
- **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/hzimaszmfp)
- **Repository:** <https://github.com/RachelHuangZW/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": "rachelhuangzw-postgres-mcp"
    }
  }
}
```

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