# postgres-mcp

> Use this tool when you need to interact with a local PostgreSQL database to perform SQL queries, inspect schema, or execute CRUD operations. It solves problems related to data management, retrieval, and manipulation, enabling efficient data access and manipulation. The tool accepts SQL queries and database credentials as inputs and returns query results and schema information as outputs.

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

## Description

Enables Claude to interact with a local PostgreSQL database through SQL queries, schema inspection, and CRUD operations.

## Trust

- **Trust score (0–1):** 0.60
- **Verification tier:** unverified

## Facts

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

## Source

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

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