# postgres-mcp

> Use this tool when you need to safely explore and interact with PostgreSQL database schemas, with features like guarded queries and selectable access modes. It solves problems related to database management, security, and data protection by providing a controlled environment for read and write operations. The tool accepts database connections and queries as input and returns query results and schema information as output, making it ideal for use cases that require secure and controlled database access.

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

## Description

A self-hostable PostgreSQL MCP server for exploring database schemas and running guarded read/write queries with selectable access modes (readonly, readwrite, admin), plus a dry-run confirm workflow for safety.

## Trust

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

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