# readonly-postgres-mcp

> readonly-postgres-mcp — geolep-readonly-postgres-mcp. Use this tool when you need to securely provide read-only access to multiple PostgreSQL databases from a single process, enforcing access controls through PostgreSQL grants. It solves problems of data security and scalability by serving databases via local stdio or remote HTTP transports. Ideal for use cases requiring centralized, read-only data access with fine-grained permission control.

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

## Description

A read-only MCP server for PostgreSQL that serves multiple databases from one process, enforcing read-only access via PostgreSQL grants rather than SQL string matching, and supports both local stdio and remote HTTP transports.

## Trust

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

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