# Postgres MCP Pro

> Postgres MCP Pro — it-romanov-noterp-postgres-mcp. Use this tool when you need to optimize and analyze the performance of your PostgreSQL database, as it provides database health analysis, index tuning, and query plan optimization to improve overall database efficiency. It solves problems related to slow query execution, inefficient indexing, and database downtime, making it suitable for both development and production environments. With inputs including database connections and SQL queries, it outputs optimized query plans and health analysis reports.

Canonical page: https://skillsregistry.net/skills/it-romanov-noterp-postgres-mcp  
JSON: https://api.skillsregistry.net/v1/skills/it-romanov-noterp-postgres-mcp

## Description

An open-source MCP server for PostgreSQL that provides database health analysis, index tuning, query plan optimization, and safe SQL execution, suitable for both development and production environments.

## Trust

- **Trust score (0–1):** 0.00
- **Verification tier:** scanned
- **Last scanned:** 2026-08-30

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-08-30

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/ijdyoltok1)
- **Repository:** <https://github.com/it-romanov/noterp-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": "it-romanov-noterp-postgres-mcp"
    }
  }
}
```

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