# postgres-mcp-server

> postgres-mcp-server — arieffian-postgres-mcp-server. Use this tool when you need to safely query PostgreSQL databases from a Large Language Model (LLM), as it provides a secure interface with read-only default mode and session-enforced safety. It solves problems related to data access and security by allowing multi-connection aliases and controlled querying. The tool accepts database queries as input and returns query results as output, making it ideal for use cases where LLMs require access to PostgreSQL data.

Canonical page: https://skillsregistry.net/skills/arieffian-postgres-mcp-server  
JSON: https://api.skillsregistry.net/v1/skills/arieffian-postgres-mcp-server

## Description

An MCP server for safely querying PostgreSQL from an LLM, with read-only default mode, multi-connection aliases, and session-enforced safety.

## Trust

- **Trust score (0–1):** 0.68
- **Verification tier:** scanned
- **Last scanned:** 2026-08-29

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/s7q3i380ib)
- **Repository:** <https://github.com/arieffian/postgres-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": "arieffian-postgres-mcp-server"
    }
  }
}
```

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