# pg-readonly-mcp

> pg-readonly-mcp — les-k-pg-readonly-mcp. Use this tool when you need to enforce read-only access to a Postgres database, preventing accidental or malicious modifications. It solves the problem of ensuring data integrity by blocking write statements and refusing connections with write privileges. Ideal for use cases requiring strict data protection, such as auditing, logging, or testing environments.

Canonical page: https://skillsregistry.net/skills/les-k-pg-readonly-mcp  
JSON: https://api.skillsregistry.net/v1/skills/les-k-pg-readonly-mcp

## Description

A read-only Postgres MCP server that parses SQL to block write statements and prevents bypasses by refusing connections with write privileges.

## Trust

- **Trust score (0–1):** 0.69
- **Verification tier:** scanned
- **Last scanned:** 2026-09-03

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/tf08qm80an)
- **Repository:** <https://github.com/les-k/pg-readonly-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": "les-k-pg-readonly-mcp"
    }
  }
}
```

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