# pgsql-mcp

> Use this tool when you need to manage and optimize PostgreSQL databases, as it provides comprehensive database management capabilities, including index tuning, query execution plans, and health checks, with a safe and configurable read-only mode for production use. It solves problems related to database performance, security, and reliability, and accepts inputs such as SQL queries and database credentials, producing outputs like execution plans and health check reports. It is ideal for use in database administration, development, and production environments where efficient and secure database management is crucial.

Canonical page: https://skillsregistry.net/skills/surajmandalcell-pgsql-mcp  
JSON: https://api.skillsregistry.net/v1/skills/surajmandalcell-pgsql-mcp

## Description

Enables interaction with PostgreSQL databases through comprehensive database management tools including index tuning, query execution plans, health checks, schema intelligence, and safe SQL execution with configurable read-only mode for production use.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/fwzju34xsy)
- **Repository:** <https://github.com/surajmandalcell/pgsql-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": "surajmandalcell-pgsql-mcp"
    }
  }
}
```

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