# PostgreSQL

> Use this tool when you need to optimize and troubleshoot PostgreSQL database performance, identify slow queries, and analyze database health metrics in real-time. It provides valuable insights and recommendations for database administrators and developers to improve query execution plans and maintain healthy databases. With features like hypothetical index testing and buffer cache analysis, it supports read-only safety and is ideal for use cases requiring database tuning and analysis.

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

## Description

PostgreSQL MCP is a database tuning and analysis tool that provides real-time insights into PostgreSQL performance. It offers tools for analyzing query execution plans, identifying slow queries, monitoring database health metrics, and recommending index optimizations. The server implements features like hypothetical index testing, transaction health monitoring, and buffer cache analysis, making it valuable for database administrators and developers who need to optimize query performance, troubleshoot bottlenecks, or maintain healthy PostgreSQL databases. Built with Python 3.12 and packaged as a Docker container, it supports both PostgreSQL 15 and 16 with a focus on read-only safety through restricted access modes.

## 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-05-27

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/crystaldba-postgres)
- **Repository:** <https://github.com/crystaldba/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": "crystaldba-postgres"
    }
  }
}
```

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