# PostgreSQL

> PostgreSQL — ahmedmustahid-postgres. Use this tool when you need to access and query PostgreSQL databases through natural language interfaces, enabling data analysis and exploration without requiring direct database access or SQL expertise. It solves problems of data querying and schema introspection, providing read-only transaction safety and supporting both HTTP and stdio transport modes. With inputs of SQL queries and outputs of query results, use it in contexts where conversational database interaction is necessary, such as data analysis workflows.

Canonical page: https://skillsregistry.net/skills/ahmedmustahid-postgres  
JSON: https://api.skillsregistry.net/v1/skills/ahmedmustahid-postgres

## Description

This PostgreSQL MCP server by Ahmed Mustahid provides AI assistants with direct database access through both HTTP and stdio transport modes, enabling natural language SQL querying with built-in read-only transaction safety. The implementation exposes database schema introspection through dedicated resources that list tables and column information, while offering a query tool that executes SQL commands within read-only transactions to prevent accidental data modification. Built with TypeScript and featuring Docker containerization with separate HTTP and stdio configurations, it's particularly valuable for data analysis workflows where users need to explore database structures and query PostgreSQL databases through conversational interfaces without requiring direct database access or SQL expertise.

## Trust

- **Trust score (0–1):** 0.79
- **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/ahmedmustahid-postgres)
- **Repository:** <https://github.com/ahmedmustahid/postgres-mcp-server>

## 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": "ahmedmustahid-postgres"
    }
  }
}
```

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