# PostgreSQL

> Use this tool when you need to execute SQL queries, manage database tables, and inspect schemas in a PostgreSQL database through a standardized interface. It solves problems related to secure data access and analysis by providing AI models with controlled access to databases. Ideal for use cases requiring querying and analysis tasks, it accepts SQL queries as input and returns query results as output.

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

## Description

A PostgreSQL database server that enables AI models to execute SQL queries, manage tables, and inspect database schemas through a standardized interface. Built with TypeScript and the MCP SDK, it features prepared statement support, automatic connection management, and support for both PostgreSQL and MySQL-style parameter placeholders. The implementation is particularly valuable for developers who want to give AI assistants secure, controlled access to PostgreSQL databases for querying and analysis tasks.

## Trust

- **Trust score (0–1):** 0.89
- **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/antonorlov-postgres)
- **Repository:** <https://github.com/antonorlov/mcp-postgres-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": "antonorlov-postgres"
    }
  }
}
```

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