# postgres_mcp

> postgres_mcp — fvanevski-postgres-mcp. Use this tool when you need to securely manage and execute SQL queries on self-hosted PostgreSQL instances, providing features like schema discovery, transaction control, and role hardening. It solves problems related to database security and access control, offering a controlled environment for query execution with optional human approval for write commands. The tool accepts SQL queries and database connections as inputs, and outputs execution results and security guidance.

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

## Description

A Python MCP 2.0 server for self-hosted PostgreSQL instances, providing schema/relation discovery, SQL query and controlled transactional execution tools with security features like read-only transactions, role hardening guidance, and optional human approval for write commands.

## Trust

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

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