# postgres-mcp

> postgres-mcp — gupta-akshay-postgres-mcp. Use this tool when you need to analyze and optimize PostgreSQL databases, as it provides AI-assisted query optimization, index recommendations, and health monitoring, accepting database connections as input and outputting actionable insights and recommendations. It solves problems related to database performance, query efficiency, and maintenance, making it ideal for database administrators and developers. Suitable for use cases involving large-scale database operations, it streamlines database management and improves overall system health.

Canonical page: https://skillsregistry.net/skills/gupta-akshay-postgres-mcp  
JSON: https://api.skillsregistry.net/v1/skills/gupta-akshay-postgres-mcp

## Description

PostgreSQL MCP server for AI-assisted database analysis, query optimisation, index recommendations, and health monitoring

## Trust

- **Trust score (0–1):** 0.86
- **Verification tier:** scanned
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** container
- **Runtime environment:** vm
- **License:** MIT
- **Updated:** 2026-09-28

## Source

- **Source listing:** [GitHub](https://github.com/gupta-akshay/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": "gupta-akshay-postgres-mcp"
    }
  }
}
```

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