# MCP PostgreSQL Read-Only Server

> Use this tool when you need to securely access and query PostgreSQL databases without modifying data. It solves problems related to data exploration, reporting, and analytics by providing read-only access to databases, enabling users to execute SELECT queries and explore schemas. The tool accepts database connections and SQL queries as inputs and returns query results as outputs, ideal for use cases where data integrity and security are a priority.

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

## Description

Enables secure read-only access to PostgreSQL databases through SELECT queries only, with tools for exploring schemas, listing tables, and executing common queries while preventing any data modification operations.

## Trust

- **Trust score (0–1):** 0.99
- **Verification tier:** verified
- **Last scanned:** 2026-09-19

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/pxka1x5kno)
- **Repository:** <https://github.com/japentaca/mcp-postgres-readonly>

## 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": "japentaca-mcp-postgres-readonly"
    }
  }
}
```

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