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.

makabakaxy e46f72b 4 files · 1.7 KB Updated

File contents

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'mcp2cli postgres query --sql 'SELECT table_name FROM information_schema.tables WHERE table_schema='"'"'public'"'"'' ref

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 for custom workflows and tips. Config: MCP server settings live in ~/.agents/mcp2cli/servers.yaml - edit there to take effect.

makabakaxy/mcp2cli/tree/main/presets/postgres-mcp/0.1.0/skills commit e46f72b0bc

Frequently asked questions

npx skillmds@latest add makabakaxy/postgres-mcp