# pgmcp

> pgmcp — sbamin-pgmcp. Use this tool when you need to securely query PostgreSQL databases with limited access and auditing capabilities. It solves problems related to data exposure and unauthorized access by providing a read-only interface with features like single-statement SELECT guard and row caps. The pgmcp tool takes database queries as input and returns query results as output, making it ideal for use cases requiring controlled and monitored database access.

Canonical page: https://skillsregistry.net/skills/sbamin-pgmcp  
JSON: https://api.skillsregistry.net/v1/skills/sbamin-pgmcp

## Description

Enables safe, read-only querying of PostgreSQL databases with defense-in-depth protections including single-statement SELECT guard, row caps, and per-identity audit logging.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/t58tm5m1yg)
- **Repository:** <https://github.com/sbamin/pgmcp>

## 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": "sbamin-pgmcp"
    }
  }
}
```

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