postgres_query

MCP tool from MCP Server by LeszczynskiKarol

Run psql queries via SSH (sudo -u postgres) on a host from hosts.json

How to use it

Project documentation lists postgres_query for the MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

FULL MCP SERVER LISTING

Other tools in MCP Server (11)

aws_cli

Run any aws <command> using your local AWS CLI profile

book_chunk

Read one chunk from a directory created by booksplit

book_note

Manage JSON notes for iterative work on long documents

book_split

Split a large text file into ~3000-word chunks

github_api

Make REST API requests to GitHub using your Personal Access Token

local_exec

Run any shell command on the local machine (cmd.exe on Windows, /bin/sh elsewhere)

pm2_status

Show pm2 list and optional logs on a remote server

sftp_download

Stream a file from a remote host to the local filesystem (uses the persistent SSH pool). Essential when working from Claude.ai web — the cloud sandbox has no native scp

sftp_upload

Stream a local file to a remote host. Optional POSIX mode flag (e.g. 0755). Parent dir must exist on remote

ssh_exec

SSH into any host using a key defined in hosts.json

write_file

Write text content to a local file (overwrite or append). Full UTF-8, no shell quoting issues — preferred over localexec for any non-trivial file write