# PostgreSQL MCP Server

> Use this tool when you need to interact with local PostgreSQL databases using natural language or SQL queries. It solves problems related to data management, querying, and schema exploration, enabling AI assistants to perform read-only queries and write operations such as table creation and data modification. The tool accepts natural language inputs and SQL queries, and outputs query results and database modifications.

Canonical page: https://skillsregistry.net/skills/aeiyannn-postgree-mcp  
JSON: https://api.skillsregistry.net/v1/skills/aeiyannn-postgree-mcp

## Description

Enables AI assistants to query and manage local PostgreSQL databases through SQL execution and schema exploration tools. It supports both read-only queries and write operations including table creation and data modification via natural language.

## Trust

- **Trust score (0–1):** 0.69
- **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:** [Glama](https://glama.ai/mcp/servers/l7ex1phgdq)
- **Repository:** <https://github.com/aeiyannn/postgree-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": "aeiyannn-postgree-mcp"
    }
  }
}
```

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