# PostgreSQL Ops

> Use this tool when you need to interact with PostgreSQL databases, execute queries, and monitor performance. It provides direct database access through asyncpg and psycopg2 connections, offering features like query execution, database introspection, and performance analysis. Ideal for developers, data analysts, and database administrators seeking conversational database administration, ad-hoc query capabilities, and AI-assisted performance monitoring and troubleshooting.

Canonical page: https://skillsregistry.net/skills/call518-postgresql-ops  
JSON: https://api.skillsregistry.net/v1/skills/call518-postgresql-ops

## Description

PostgreSQL operations MCP server by JungJungIn that provides AI assistants with direct database access through asyncpg and psycopg2 connections, offering query execution, database introspection, and performance monitoring capabilities. The implementation includes specialized functions for PostgreSQL extensions like pg_stat_statements and pg_stat_monitor for query performance analysis, along with utility functions for formatting database results into human-readable tables with automatic byte and duration formatting. Built with Docker support and both stdio and HTTP transport options, it serves developers needing conversational database administration, data analysts requiring ad-hoc query capabilities, and database administrators who want AI-assisted performance monitoring and troubleshooting workflows.

## Trust

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

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/call518-postgresql-ops)
- **Repository:** <https://github.com/call518/mcp-postgresql-ops>

## 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": "call518-postgresql-ops"
    }
  }
}
```

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