# mcp-postgresdb-readonly

> Use this tool when you need to access and analyze data in PostgreSQL databases without modifying it. It solves problems related to data querying, schema exploration, and metadata retrieval, providing read-only access to databases through various MCP tools. It takes database credentials as input and outputs query results, table metadata, and schema information, making it ideal for data analysis and exploration use cases.

Canonical page: https://skillsregistry.net/skills/nayzo-mcp-postgresdb-readonly  
JSON: https://api.skillsregistry.net/v1/skills/nayzo-mcp-postgresdb-readonly

## Description

Provides read-only access to PostgreSQL databases, enabling querying, schema exploration, and table metadata retrieval via MCP tools like query, list-tables, describe-table, list-schemas, and list-environments.

## Trust

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

## Facts

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

## Source

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

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