# PostgreSQL

> Use this tool when you need to securely explore and analyze database content without modifying it. It solves problems such as accidental data modifications and limited database visibility, providing outputs including query results, table listings, and schema inspections through inputs like SELECT queries and search filters. Ideal for data analysis and exploration use cases, it offers a read-only interface to PostgreSQL databases.

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

## Description

Read-only PostgreSQL MCP server designed for secure database exploration through six core tools: direct SELECT queries, table listing, schema inspection, sample data retrieval, row counting with optional filtering, and cross-table column search. Built with asyncpg for efficient async database connections and includes robust safety measures that block all write operations (INSERT, UPDATE, DELETE) while supporting complex read queries including CTEs. Ideal for data analysts, engineers, and AI assistants who need to explore and analyze database content without risk of accidental modifications.

## Trust

- **Trust score (0–1):** 0.93
- **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:** [PulseMCP](https://www.pulsemcp.com/servers/avantifellows-postgres)
- **Repository:** <https://github.com/avantifellows/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": "avantifellows-postgres"
    }
  }
}
```

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