# PostgreSQL Advanced

> Use this tool when you need to manage complex database operations with advanced transaction management and safety features. It provides full read-write database access, automatic transaction handling, and configurable safety limits for concurrent transactions, solving problems related to data integrity and consistency. Ideal for applications requiring explicit user confirmation of changes and transactional integrity, such as database administration workflows and AI-assisted database control.

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

## Description

Advanced PostgreSQL MCP server by Syahiid Kamil that provides full read-write database access with sophisticated transaction management and safety features. The implementation offers separate tools for read-only queries, write operations (DML/DDL/DCL/TCL), and maintenance commands, with all write operations automatically wrapped in transactions that require explicit commit or rollback decisions. Built with TypeScript using connection pooling, automatic transaction timeout monitoring, and stuck transaction cleanup, it includes comprehensive schema exploration tools, table metadata access, and configurable safety limits for concurrent transactions. Designed for AI assistants requiring complete database control with built-in safeguards, database administration workflows, and applications where transactional integrity and explicit user confirmation of changes are critical.

## 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-29

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/postgres-advanced)
- **Repository:** <https://github.com/syahiidkamil/mcp-postgres-full-access>

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

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