postgres-mcp (via mcp2cli)
Run read-only SQL queries against a PostgreSQL database.
Shortcuts
mcp2cli postgres <cmd>(alias formcp2cli 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.