# Postgres MCP

> Run read-only SQL queries against a PostgreSQL database via CLI. Use when user needs to query, inspect, or retrieve data from a Postgres database.

- Skill: `makabakaxy/postgres-mcp` (Agent Skill, multi-file: 4 files)
- Install (CLI): `npx skillmds@latest add makabakaxy/postgres-mcp`
- Raw SKILL.md: https://api.skillmd.com/api/skills/makabakaxy/postgres-mcp/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: makabakaxy (https://skillmd.com/u/makabakaxy)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/makabakaxy/postgres-mcp

---


# postgres-mcp (via mcp2cli)

Run read-only SQL queries against a PostgreSQL database.

## Shortcuts

- `mcp2cli postgres <cmd>` (alias for `mcp2cli postgres-mcp`)

## Commands

### Query
| Command | Description | Example | Ref |
|---|---|---|---|
| `mcp2cli postgres query` | Run a read-only SQL query | `mcp2cli postgres query --sql 'SELECT * FROM users LIMIT 10'`<br>`mcp2cli postgres query --sql 'SELECT table_name FROM information_schema.tables WHERE table_schema='"'"'public'"'"''` | [ref](reference/query.md) |

## Discover Parameters

Append `--help` to any command for full parameter list:

    mcp2cli postgres query --help

> **Note**: Use Ref links in the Commands table above to view detailed parameter reference and more examples.

## User Notes

> **MUST READ** [users/skill.md](users/skill.md) for custom workflows and tips.
> **Config**: MCP server settings live in `~/.agents/mcp2cli/servers.yaml` - edit there to take effect.