# postgres-mcp

> Use this tool when you need to safely interact with PostgreSQL databases, enabling read-only queries, schema exploration, and performance analysis to solve data access and optimization problems. It accepts database connections and query inputs, producing output in the form of query results, schema information, and performance metrics. Ideal for use cases requiring data inspection, debugging, and performance tuning in a secure and controlled manner.

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

## Description

Enables safe interaction with PostgreSQL databases through read-only queries, schema exploration, and performance analysis.

## Trust

- **Trust score (0–1):** 0.70
- **Verification tier:** verified
- **Last scanned:** 2026-08-31

## Facts

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

## Source

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

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