# PostgreSQL MCP Server

> Use this tool when you need to provide large language models (LLMs) with read-only access to PostgreSQL databases, enabling them to inspect database schemas and execute queries. It solves problems related to data access and integration, allowing LLMs to retrieve specific data without modifying the underlying database. The PostgreSQL MCP Server takes database queries as input and returns query results as output, ideal for use cases where LLMs require data-driven insights or training data.

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

## Description

A Model Context Protocol server that provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only queries.

## Trust

- **Trust score (0–1):** 0.98
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

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

## Source

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

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