# PostgreSQL

> Use this tool when you need to securely access and manage PostgreSQL databases, solving problems such as data retrieval and manipulation, audit logging, and schema inspection. It takes database queries and credentials as inputs and returns query results, providing a secure interface for read and write operations. Ideal for use cases requiring reliable and secure database interactions, such as data analysis, application development, and data integration.

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

## Description

Provides read and write access to PostgreSQL databases via asyncpg and FastMCP. Includes schema inspection tools, audit logging, and support for stdio, SSE, and streamable-HTTP transports. Implements parameterized queries, schema allowlisting, and error sanitization for secure database access.

## Trust

- **Trust score (0–1):** 0.94
- **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/filipescordeiro2-postgres)
- **Repository:** <https://github.com/filipescordeiro2/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": "filipescordeiro2-postgres"
    }
  }
}
```

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