# PostgreSQL

> Use this tool when you need to manage and interact with PostgreSQL databases, solving problems such as data storage, querying, and migration. It provides a standardized interface for executing SQL queries, inspecting schemas, and analyzing query plans, accepting inputs like SQL queries and database configuration variables. It is ideal for use cases requiring reliable and efficient database operations, outputting results like query execution plans and table listings.

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

## Description

Provides PostgreSQL database operations through a standardized interface. Supports SQL query execution, table listing, schema inspection, query execution plan analysis via EXPLAIN, and DDL migration capabilities. Connects to PostgreSQL using standard environment variables for host, user, and database configuration.

## Trust

- **Trust score (0–1):** 0.65
- **Verification tier:** scanned
- **Last scanned:** 2026-09-02

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/chu2bard-postgres)
- **Repository:** <https://github.com/chu2bard/pgmcp>

## 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": "chu2bard-postgres"
    }
  }
}
```

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