# Postgres MCP

> Official PostgreSQL Model Context Protocol Server for database interaction.

- Skill: `dokhacgiakhoa/postgres-mcp-2` (Agent Skill)
- Install (CLI): `npx skillmds@latest add dokhacgiakhoa/postgres-mcp-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/dokhacgiakhoa/postgres-mcp-2/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: AI & ML
- Author: Dokhacgiakhoa (https://skillmd.com/u/dokhacgiakhoa)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/dokhacgiakhoa/postgres-mcp-2

---


# PostgreSQL MCP Skill

## 🎯 Goal
Enable the AI Agent to inspect schemas and execute queries on PostgreSQL databases using the official Model Context Protocol standard.

## 🛠️ Tools

### `query`
Execute a unified SQL query.
- **sql**: The SQL query to execute (string)

### `get_schema`
Inspect the database schema.
- **table_name**: Optional table name to filter schema inspection (string)

### `analyze_query_performance`
Run `EXPLAIN ANALYZE` on a query to check performance.
- **sql**: The SQL query to analyze (string)

## 🚀 Usage Rules
1.  **Read-Only Preference**: Prefer `SELECT` queries unless explicitly instructed to modify data.
2.  **Transaction Safety**: For multiple write operations, ensure valid transaction logic (though often handled by the tool).
3.  **Schema Awareness**: Always run `get_schema` before constructing complex queries to ensure column names are correct.
4.  **Security**: Do not execute destructive queries (`DROP`, `TRUNCATE`) without explicit user plan approval.