# postgres-mcp

> postgres-mcp — rineshpk-postgres-mcp. Use this tool when you need to safely query and analyze PostgreSQL database workloads, enabling large language models (LLMs) to optimize performance while minimizing security risks. It provides a lightweight MCP server interface for LLMs to interact with PostgreSQL databases, accepting database queries and configuration inputs and generating optimized workload outputs. Ideal for use cases requiring secure and efficient database workload analysis and optimization.

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

## Description

A lightweight MCP server for PostgreSQL that enables LLMs to safely query, analyze, and optimize database workloads.

## Trust

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

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** container
- **Runtime environment:** vm
- **License:** MIT
- **Updated:** 2026-09-28

## Source

- **Source listing:** [GitHub](https://github.com/rineshpk/postgres-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": "rineshpk-postgres-mcp"
    }
  }
}
```

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