# PostgreSQL

> Use this tool when you need to interact with PostgreSQL databases for schema management and CRUD operations, solving problems such as database automation and safety validation. It accepts database queries and schema definitions as inputs and provides query results and validation feedback as outputs. Ideal for use cases requiring reliable and efficient database interactions, particularly in environments without Node.js or Python dependencies.

Canonical page: https://skillsregistry.net/skills/guoling2008-postgres  
JSON: https://api.skillsregistry.net/v1/skills/guoling2008-postgres

## Description

Go-MCP-Postgres is a ready-to-use MCP server for interacting with PostgreSQL databases, adapted from Zhwt's MySQL implementation. It provides tools for database schema management and CRUD operations with safety features like read-only mode and query plan validation. Written in Go with no external dependencies, it supports both stdio and SSE transport modes, includes multilingual support, and is particularly useful for database automation tasks without requiring Node.js or Python environments.

## Trust

- **Trust score (0–1):** 0.65
- **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:** [PulseMCP](https://www.pulsemcp.com/servers/guoling2008-postgres)
- **Repository:** <https://github.com/guoling2008/go-mcp-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": "guoling2008-postgres"
    }
  }
}
```

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