# Postgres MCP Pro

> Use this tool when you need to manage and optimize PostgreSQL databases, as it solves problems related to performance, security, and scalability by providing comprehensive features such as index tuning, query analysis, and health monitoring. It takes database inputs and generates optimized SQL outputs, with a configurable interface for access control. Use it in development and production environments to ensure efficient and secure database operations.

Canonical page: https://skillsregistry.net/skills/bach-ai-tools-bach-postgres-mcp  
JSON: https://api.skillsregistry.net/v1/skills/bach-ai-tools-bach-postgres-mcp

## Description

Enables comprehensive PostgreSQL database management including index tuning, query plan analysis, health monitoring, schema-aware SQL generation, and safe SQL execution with configurable access control for both development and production environments.

## 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-04

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/ur7rjpvgpm)
- **Repository:** <https://github.com/BACH-AI-Tools/bach--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": "bach-ai-tools-bach-postgres-mcp"
    }
  }
}
```

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