# PostgreSQL MCP Server

> Use this tool when you need to access and query PostgreSQL databases in a secure and read-only manner, allowing for inspection of table schemas and execution of SQL queries without modifying the data. It solves problems related to data exploration, analysis, and retrieval, while ensuring data safety through read-only transactions. Ideal for use cases where data integrity is paramount, such as data science, research, and development environments.

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

## Description

Provides read-only access to PostgreSQL databases, allowing LLMs to inspect table schemas and execute SQL queries. It ensures data safety by running all operations within read-only transactions.

## Trust

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

## Facts

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

## Source

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

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