subnetmarco/pgmcp
NOASSERTIONAPI key required🏎️ 🏠 - Natural language PostgreSQL queries with automatic streaming, read-only safety, and universal database compatibility.
Install
npx -y subnetmarco-pgmcpRequired environment variables
OPENAI_API_KEYSet in your MCP configclaude_desktop_config.json
{
"mcpServers": {
"subnetmarco-pgmcp": {
"command": "npx",
"args": [
"-y",
"subnetmarco-pgmcp"
],
"env": {
"OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>"
}
}
}
}Add this to your Claude Desktop config file. Find it at ~/Library/Application Support/Claude/claude_desktop_config.json on macOS.
What this does
subnetmarco/pgmcp exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation. That makes it useful when you want Claude to reach into your databases without copy-pasting context every turn.
Requirements
This server needs the following environment variables to be set before it can run:
OPENAI_API_KEY
Set these via the env object in your MCP config (see claude_desktop_config.json snippet above).
Common use cases
- •Query structured data without writing SQL by hand
- •Let Claude read table schemas before answering data questions
- •Run read-only operational reports or sanity checks during incidents
More Go MCP servers
mindsdb/mindsdb
Connect and unify data across various platforms and databases with .
github/github-mcp-server
📇 ☁️ - Official GitHub server for integration with repository management, PRs, issues, and more.
googleapis/genai-toolbox
🏎️ ☁️ - Open source MCP server specializing in easy, fast, and secure tools for Databases.
mickaelkerjean/filestash
🏎️ ☁️ - Remote Storage Access: SFTP, S3, FTP, SMB, NFS, WebDAV, GIT, FTPS, gcloud, azure blob, sharepoint, etc.