# PostgreSQL Explorer

> Use this tool when you need to inspect database schemas and execute safe queries on PostgreSQL databases without modifying the data. It provides read-only access to databases, automatically discovers table schemas, and exposes them as resources for analysis. Ideal for data analysis workflows, it connects to any PostgreSQL database via a connection string and executes SQL queries within READ ONLY transactions.

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

## Description

This PostgreSQL MCP server provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute safe queries. Developed by Anthropic, it connects to any PostgreSQL database via a connection string, automatically discovers table schemas, and exposes them as resources while providing a query tool that executes SQL within READ ONLY transactions. The implementation is designed for easy deployment via Docker or NPX, making it ideal for data analysis workflows where AI assistants need to explore database structure and content without risk of data modification.

## Trust

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

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/postgres-explorer)
- **Repository:** <https://github.com/danielrsnell/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": "postgres-explorer"
    }
  }
}
```

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