# postgres-mcp-server

> postgres-mcp-server — allensandiego-postgres-mcp-server. Use this tool when you need to interact with PostgreSQL databases, providing AI assistants with schema discovery, catalog introspection, and read-only querying capabilities. It solves problems related to database exploration, data analysis, and safe data manipulation, offering optional write operations. The tool accepts database connections as input and outputs query results, schema information, and catalog data.

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

## Description

MCP server for PostgreSQL, providing schema discovery, catalog introspection, read-only querying, and optional safe write operations to AI assistants.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/z20dw8h3r0)
- **Repository:** <https://github.com/allensandiego/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": "allensandiego-postgres-mcp-server"
    }
  }
}
```

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