# PostgreSQL MCP Server

> Use this tool when you need to securely access and explore PostgreSQL databases, validate queries, and optimize performance, providing AI assistants with read-only access to database schema and data. It solves problems related to database security, query optimization, and data exploration, offering a comprehensive interface for schema analysis and performance tuning. Ideal for use cases requiring controlled database access and optimization, with inputs including database connections and queries, and outputs including schema information, query validation results, and performance metrics.

Canonical page: https://skillsregistry.net/skills/abdou-ghonim-mcp-postgres  
JSON: https://api.skillsregistry.net/v1/skills/abdou-ghonim-mcp-postgres

## Description

A Model Context Protocol server that provides AI assistants with secure, read-only access to PostgreSQL databases while offering comprehensive tools for schema exploration, query validation, and performance optimization.

## Trust

- **Trust score (0–1):** 0.76
- **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/ezwib7zpk2)
- **Repository:** <https://github.com/abdou-ghonim/mcp-postgres>

## 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": "abdou-ghonim-mcp-postgres"
    }
  }
}
```

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