# mcp-postgres

> Use this tool when you need to access and analyze data stored in PostgreSQL databases, and want to execute SQL queries, list tables, or describe table structures to inform your decision-making or problem-solving processes. It provides an interface for AI agents to input SQL queries and receive output results, enabling exploration and insight generation from database contents. Ideal for use cases requiring data retrieval, analysis, or reporting from PostgreSQL databases.

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

## Description

Enables AI agents to query and explore PostgreSQL databases with tools for executing SQL queries, listing tables, and describing table structures.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/gp77uudmpb)
- **Repository:** <https://github.com/mgcrea/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": "mgcrea-mcp-postgres"
    }
  }
}
```

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