# PostgreSQL Pro Plus

> Use this tool when you need to optimize and analyze PostgreSQL databases with advanced health monitoring and query performance capabilities. It solves problems related to database performance, query optimization, and health monitoring, providing inputs such as database connections and query execution plans, and outputs including automated index recommendations and performance insights. Ideal for database administrators, developers, and teams managing production databases, it offers unrestricted and restricted access modes for flexible deployment.

Canonical page: https://skillsregistry.net/skills/cloud-thinker-ai-postgres-pro-plus  
JSON: https://api.skillsregistry.net/v1/skills/cloud-thinker-ai-postgres-pro-plus

## Description

This PostgreSQL MCP server provides AI assistants with advanced database analysis and optimization capabilities, built by Crystal Corp using Python with comprehensive health monitoring, query performance analysis, and index optimization tools. The implementation offers database health checks across multiple dimensions (connections, vacuum, sequences, replication, buffer cache, constraints), query execution plan analysis with hypothetical index testing via HypoPG extension, top query identification through pg_stat_statements, and automated index recommendations with duplicate detection and bloat analysis. Built with both restricted and unrestricted access modes, connection pooling, and Docker deployment support, it serves database administrators needing AI-powered PostgreSQL optimization, developers building data-intensive applications requiring performance insights, and teams managing production databases that need automated health monitoring and query optimization recommendations.

## 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/cloud-thinker-ai-postgres-pro-plus)
- **Repository:** <https://github.com/cloudthinker-ai/postgres-mcp-pro-plus>

## 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": "cloud-thinker-ai-postgres-pro-plus"
    }
  }
}
```

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