# postgres-mcp-server

> Use this tool when you need to safely query and inspect PostgreSQL databases without modifying them. It provides a local MCP server with read-only access, solving problems related to data analysis and debugging while preventing unintended write operations. Ideal for use cases where data integrity is crucial, such as testing, development, and data exploration environments.

Canonical page: https://skillsregistry.net/skills/bysonte-postgres-mcp-server  
JSON: https://api.skillsregistry.net/v1/skills/bysonte-postgres-mcp-server

## Description

Local MCP server for safe querying and inspecting PostgreSQL databases, with write and maintenance operations disabled by default.

## 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/bku9jj4nvr)
- **Repository:** <https://github.com/bysonte/postgres-mcp-server>

## 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": "bysonte-postgres-mcp-server"
    }
  }
}
```

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