# PostgreSQL MCP Server

> Use this tool when you need to interact with PostgreSQL databases using natural language, converting questions into executable SQL queries. It solves problems of complex query formulation and data retrieval, providing a user-friendly interface for non-technical users. The tool takes in natural language questions as input and outputs validated query results, making it ideal for ad-hoc data analysis and exploration.

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

## Description

Enables natural language interaction with PostgreSQL databases, converting questions to safe SQL queries and executing them with result validation.

## Trust

- **Trust score (0–1):** 0.49
- **Verification tier:** scanned
- **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/zo2bwg2cu0)
- **Repository:** <https://github.com/lastfore/pg-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": "lastfore-pg-mcp"
    }
  }
}
```

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