# postgres-mcp

> Use this tool when you need to manage and analyze PostgreSQL databases with AI assistance. It solves problems related to schema exploration, stored procedure analysis, test data generation, and transaction management, providing a safe and efficient interface for database administration. The tool accepts database connections as input and outputs actionable insights and recommendations via Claude Desktop.

Canonical page: https://skillsregistry.net/skills/tsbr007-post-gres-mcp  
JSON: https://api.skillsregistry.net/v1/skills/tsbr007-post-gres-mcp

## Description

MCP server for PostgreSQL database management, enabling AI-assisted schema exploration, stored procedure analysis, test data generation, and safe transaction management via Claude Desktop.

## Trust

- **Trust score (0–1):** 0.67
- **Verification tier:** scanned
- **Last scanned:** 2026-08-31

## Facts

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

## Source

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

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