# PostgreSQL MCP

> Use this tool when you need to access and analyze PostgreSQL database schema and data in a secure and read-only manner. It solves problems related to data exploration, metadata discovery, and safe querying of PostgreSQL databases. The PostgreSQL MCP takes database connections as input and provides schema information, table metadata, and query results as output.

Canonical page: https://skillsregistry.net/skills/vallaksa-postgresql-mcp  
JSON: https://api.skillsregistry.net/v1/skills/vallaksa-postgresql-mcp

## Description

Read-only MCP server for PostgreSQL, enabling schema discovery, table metadata, and safe SELECT queries via READ ONLY transactions.

## Trust

- **Trust score (0–1):** 0.69
- **Verification tier:** scanned
- **Last scanned:** 2026-08-30

## Facts

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

## Source

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

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