# Postgres MCP Server

> Use this tool when you need to integrate large language models (LLMs) with PostgreSQL databases, enabling controlled querying and analysis of data. It solves problems related to data access and manipulation, supporting use cases such as data retrieval, schema inspection, and optional write operations with built-in safety controls. The tool accepts SQL queries as input and returns query results, table schemas, or execution status as output.

Canonical page: https://skillsregistry.net/skills/ericzakariasson-pg-mcp-server  
JSON: https://api.skillsregistry.net/v1/skills/ericzakariasson-pg-mcp-server

## Description

Enables LLMs to query and analyze PostgreSQL databases through a controlled interface. Supports SQL query execution, table schema inspection, and optional write operations with safety controls.

## Trust

- **Trust score (0–1):** 0.67
- **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/bgfncrwul4)
- **Repository:** <https://github.com/ericzakariasson/pg-mcp-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": "ericzakariasson-pg-mcp-server"
    }
  }
}
```

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