# PostgreSQL MCP Server

> Use this tool when you need to interact with PostgreSQL databases securely, perform complex queries, or analyze query performance. It enables AI assistants to inspect database schemas, execute queries, and retrieve results, making it ideal for data analysis, reporting, and database administration tasks. By leveraging this tool, AI agents can provide data-driven insights and automate database-related workflows.

Canonical page: https://skillsregistry.net/skills/longgoll-mcp-postgresql-server  
JSON: https://api.skillsregistry.net/v1/skills/longgoll-mcp-postgresql-server

## Description

Enables AI assistants to safely interact with PostgreSQL databases, perform queries, inspect schemas, and analyze query performance.

## Trust

- **Trust score (0–1):** 0.70
- **Verification tier:** verified
- **Last scanned:** 2026-08-31

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/p4ig962ekn)
- **Repository:** <https://github.com/longgoll/mcp-postgreSql-server>

## 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": "longgoll-mcp-postgresql-server"
    }
  }
}
```

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