# pg-mcp

> Use this tool when you need to interact with PostgreSQL databases securely, enabling AI assistants to query, inspect schemas, and retrieve database structures. It solves problems of database exploration and interaction, providing read-only protection and supporting multiple connections. This tool is ideal for use cases requiring secure and controlled database access, with inputs including database credentials and queries, and outputs including query results and database metadata.

Canonical page: https://skillsregistry.net/skills/shedyhs-pg-mcp  
JSON: https://api.skillsregistry.net/v1/skills/shedyhs-pg-mcp

## Description

Enables AI assistants to query PostgreSQL databases, inspect schemas, and retrieve complete DDL with built-in read-only protection. It supports multiple database connections and allows for secure database interaction and exploration via the Model Context Protocol.

## Trust

- **Trust score (0–1):** 0.97
- **Verification tier:** verified
- **Last scanned:** 2026-09-19

## Facts

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

## Source

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

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