# PostgreSQL

> Use this tool when you need to securely manage and interact with PostgreSQL databases, solving problems such as data protection, audit logging, and multi-database connection management. It provides a comprehensive interface for query execution, schema introspection, and transaction-based batch execution, with inputs including SQL queries and database connections, and outputs including query results and audit logs. Use it in contexts requiring robust database security, such as enterprise applications or sensitive data storage.

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

## Description

A PostgreSQL MCP server implementation built in C# that provides secure database operations through comprehensive safety guards, audit logging, and multi-database connection management. Features include query execution with automatic LIMIT enforcement, schema introspection, table management, role administration, backup/restore operations via pg_dump/pg_restore, and transaction-based batch execution. The implementation emphasizes security with configurable safety checks for critical operations, dry-run modes, confirmation requirements for destructive actions, and detailed audit trails with multi-instance support.

## 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/eax3010-postgres)
- **Repository:** <https://github.com/eax3010/postgres-mcp>

## 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": "eax3010-postgres"
    }
  }
}
```

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