# postgres-mcp-js

> Use this tool when you need to provide secure and structured access to your PostgreSQL database for AI assistants, enabling automated health checks, index tuning, and lock analysis. It solves problems related to database performance, security, and maintenance by offering a safe interface for AI-driven optimization and monitoring. The postgres-mcp-js server takes database queries as input and outputs optimized performance metrics and recommendations.

Canonical page: https://skillsregistry.net/skills/shubham4038-postgres-mcp-js  
JSON: https://api.skillsregistry.net/v1/skills/shubham4038-postgres-mcp-js

## Description

A Model Context Protocol (MCP) server for PostgreSQL that provides safe, structured access to your database for AI assistants, enabling health checks, index tuning, lock analysis, and more.

## Trust

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

## Facts

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

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/n46fco1xvo)
- **Repository:** <https://github.com/shubham4038/postgres-mcp-js>

## 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": "shubham4038-postgres-mcp-js"
    }
  }
}
```

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