# PostgreSQL

> Use this tool when you need to interact with PostgreSQL databases to inspect schemas, execute queries, or manage credentials. It solves problems related to database administration, query execution, and credential management, providing a read-only interface with support for multiple databases and integration with AWS Secrets Manager. Ideal for use cases requiring efficient and portable database interaction, with inputs including database credentials and queries, and outputs including schema information and query results.

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

## Description

PostgreSQL provides a read-only MCP interface to PostgreSQL databases with 3 tools for schema inspection and query execution. The server supports multiple databases simultaneously and integrates with AWS Secrets Manager for credential management. Written in Go for performance and portability.

## Trust

- **Trust score (0–1):** 0.50
- **Verification tier:** unverified

## Facts

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

## Source

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

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