# readonly-postgres-mcp

> Use this tool when you need to securely run analytical queries on a PostgreSQL database with limited access, as it provides a readonly server with SQL guardrails for safe data analysis and schema introspection, accepting SQL queries as input and returning query results as output. It solves problems related to data security and access control, allowing for restricted data exploration and discovery. Ideal for use cases where sensitive data protection is crucial, such as data science, reporting, and business intelligence applications.

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

## Description

Readonly PostgreSQL MCP server with SQL guardrails for analytical queries and schema introspection.

## 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/khxf1guxp9)
- **Repository:** <https://github.com/amar141989-dev/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": "amar141989-dev-readonly-postgres-mcp"
    }
  }
}
```

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