# postgres-mcp

> postgres-mcp — yash-0620-postgres-mcp. Use this tool when you need to optimize and manage Postgres databases with automated index tuning, detailed explain plans, and health checks, while ensuring safe SQL execution for AI agents. It solves problems related to database performance, query optimization, and security, providing inputs such as SQL queries and database connections, and outputs like optimized execution plans and health status reports. Ideal for use cases requiring reliable and efficient database management in AI-driven applications.

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

## Description

A Postgres MCP server with index tuning, explain plans, health checks, and safe SQL execution for AI agents.

## Trust

- **Trust score (0–1):** 0.00
- **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/kfjm6lm00d)
- **Repository:** <https://github.com/Yash-0620/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": "yash-0620-postgres-mcp"
    }
  }
}
```

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