# PostgreSQL

> Use this tool when you need to manage and interact with PostgreSQL databases, solving problems related to data storage, querying, and analysis across various categories. It provides a comprehensive interface for core operations, data processing, and performance tuning, accepting SQL queries and database connections as inputs and producing results and reports as outputs. Use it in contexts requiring robust database management, data-driven applications, and secure data storage.

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

## Description

Comprehensive PostgreSQL integration providing database management capabilities across 9 categories including core operations, JSON processing, text handling, statistics, performance tuning, vector search, geospatial operations, backup, and monitoring. Features dual security modes, support for pgvector and PostGIS extensions, and passes CodeQL security scanning with strict type checking.

## Trust

- **Trust score (0–1):** 0.82
- **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:** [PulseMCP](https://www.pulsemcp.com/servers/neverinfamous-postgresql)
- **Repository:** <https://github.com/neverinfamous/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": "neverinfamous-postgresql"
    }
  }
}
```

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