# postgres-explorer

> postgres-explorer — mathewsls-mcp-postgresql. Use this tool when you need to safely explore and query a PostgreSQL database without modifying its data. It solves problems such as discovering database schema, retrieving specific data, and executing read-only queries, by providing a list of available tables and executing SELECT statements. The tool takes database connections as input and outputs query results, making it ideal for data analysis, troubleshooting, and development tasks.

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

## Description

Enables safe read-only exploration and querying of a PostgreSQL database, listing tables and executing SELECT statements.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/chxi23awld)
- **Repository:** <https://github.com/mathewsls/mcp-postgresql>

## 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": "mathewsls-mcp-postgresql"
    }
  }
}
```

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