# postgres-mcp-server

> postgres-mcp-server — jtapia-puma-postgres-mcp-server. Use this tool when you need to interact with PostgreSQL databases using SQL queries or inspect database schemas. It solves problems related to data retrieval, manipulation, and analysis by providing an interface for AI assistants to execute queries and retrieve results. The tool accepts SQL queries as input and returns query results or schema information as output, making it ideal for use cases that require database integration and data-driven decision making.

Canonical page: https://skillsregistry.net/skills/jtapia-puma-postgres-mcp-server  
JSON: https://api.skillsregistry.net/v1/skills/jtapia-puma-postgres-mcp-server

## Description

Enables AI assistants to execute SQL queries and inspect PostgreSQL database schemas via MCP tools.

## Trust

- **Trust score (0–1):** 0.70
- **Verification tier:** verified
- **Last scanned:** 2026-08-30

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/c4usvedb5r)
- **Repository:** <https://github.com/jtapia-puma/postgres-mcp-server>

## 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": "jtapia-puma-postgres-mcp-server"
    }
  }
}
```

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