# PostgreSQL Multi-Schema

> Use this tool when you need to access and inspect complex PostgreSQL databases with multiple schemas, execute read-only queries, and maintain schema isolation. It solves problems of data discovery, schema navigation, and access control across multiple namespaces. The tool accepts database connections and schema specifications as inputs and provides read-only query results and metadata as outputs.

Canonical page: https://skillsregistry.net/skills/harjjotsinghh-postgres-multi-schema  
JSON: https://api.skillsregistry.net/v1/skills/harjjotsinghh-postgres-multi-schema

## Description

This MCP server provides read-only access to PostgreSQL databases with enhanced multi-schema support. It enables AI assistants to inspect database schemas across multiple namespaces, execute read-only queries, and maintain schema isolation. The server supports explicit schema specification, cross-schema discovery, and metadata security, making it ideal for scenarios requiring controlled access to complex database structures across multiple schemas.

## Trust

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

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/harjjotsinghh-postgres-multi-schema)
- **Repository:** <https://github.com/harjjotsinghh/mcp-server-postgres-multi-schema>

## 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": "harjjotsinghh-postgres-multi-schema"
    }
  }
}
```

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