# postgres-mcp

> Use this tool when you need to optimize and manage PostgreSQL databases, as it provides index tuning, explain plans, and health checks to improve performance and ensure safe SQL execution. It solves problems related to database query optimization, performance monitoring, and security. The tool accepts SQL queries as input and outputs optimized execution plans and health check results.

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

## Description

A Postgres MCP server with index tuning, explain plans, health checks, and safe sql execution.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/d1ryxn87c6)
- **Repository:** <https://github.com/mirenqinggege/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": "mirenqinggege-postgres-mcp"
    }
  }
}
```

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