# PostgreSQL

> Use this tool when you need to interact with PostgreSQL databases through a standardized interface, enabling secure and validated data operations and schema manipulation. It solves problems of database connectivity and management for AI agents, providing a secure API for querying, creating, and modifying database tables and indexes. It accepts SQL statements as input and returns query results or operation outcomes, ideal for use cases where AI assistants require database access without direct driver interaction.

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

## Description

Postgres MCP is a server implementation that provides a standardized interface for AI agents to interact with PostgreSQL databases through a set of well-defined commands. Developed by Tyr Chen, it enables connection management, data operations (SELECT, INSERT, UPDATE, DELETE), and schema manipulation (CREATE/DROP tables and indexes) through a secure API that validates SQL statements before execution. The server uses sqlx for database connectivity and sqlparser for SQL validation, ensuring only allowed operations are performed. It's particularly useful for AI assistants that need to query databases, manage database schemas, or perform data operations without direct access to database drivers.

## Trust

- **Trust score (0–1):** 0.81
- **Verification tier:** verified
- **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:** [PulseMCP](https://www.pulsemcp.com/servers/tyrchen-postgres)
- **Repository:** <https://github.com/tyrchen/postgres-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": "tyrchen-postgres"
    }
  }
}
```

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