# mcp-server-postgres

> mcp-server-postgres — ofershap-mcp-server-postgres. Use this tool when you need to interact with PostgreSQL databases, enabling AI assistants to query, inspect schemas, and explain queries in a read-only safe environment. It solves problems related to database exploration, query optimization, and data analysis for local and development databases. The tool accepts database connections as input and provides query results and schema information as output.

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

## Description

Enables AI assistants to query PostgreSQL, inspect schemas, and explain queries, designed for local and development databases with read-only safety by default.

## Trust

- **Trust score (0–1):** 0.69
- **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/qdewv1rv21)
- **Repository:** <https://github.com/ofershap/mcp-server-postgres>

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

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