# Enhanced PostgreSQL

> Use this tool when you need to interact with PostgreSQL databases for both data analysis and management tasks, enabling read and write access to execute complex operations such as inserting, updating, and deleting data, as well as managing database schema objects. It solves problems related to data modification and database administration, providing a secure interface with proper transaction handling and parameterized queries to prevent SQL injection. It is ideal for AI assistants that require robust database interaction capabilities.

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

## Description

Enhanced PostgreSQL MCP Server provides both read and write access to PostgreSQL databases, extending the original read-only implementation by Anthropic. Developed by Gareth Cottrell, it enables LLMs to not only query database schemas and execute read operations but also modify data through insert, update, and delete operations, as well as manage database schema objects like tables, functions, triggers, and indexes. The server implements proper transaction handling with COMMIT/ROLLBACK mechanisms and uses parameterized queries for data modification operations to prevent SQL injection, making it suitable for AI assistants that need to interact with PostgreSQL databases for both data analysis and database management tasks.

## 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/garethcott-enhanced-postgres)
- **Repository:** <https://github.com/garethcott/enhanced-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": "garethcott-enhanced-postgres"
    }
  }
}
```

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