# mcp-pgSQL

> Use this tool when you need to manage and optimize PostgreSQL databases through natural language interactions. It provides core functionality for SQL execution, metadata inspection, and performance diagnostics, solving problems related to database administration and troubleshooting. With natural language inputs and SQL outputs, it offers an intuitive interface for database management, ideal for use cases where ease of use and efficient diagnostics are crucial.

Canonical page: https://skillsregistry.net/skills/oscarbyron69-mcp-pgsql  
JSON: https://api.skillsregistry.net/v1/skills/oscarbyron69-mcp-pgsql

## Description

A local MCP server for PostgreSQL that provides tools for SQL execution, metadata inspection, performance diagnostics, and database management through natural language.

## Trust

- **Trust score (0–1):** 0.57
- **Verification tier:** scanned
- **Last scanned:** 2026-09-01

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/xwwptko2es)
- **Repository:** <https://github.com/OscarByron69/mcp-pgSQL>

## 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": "oscarbyron69-mcp-pgsql"
    }
  }
}
```

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