database mcp postgres for Claude Desktop
io.github.arifulislamat/database-mcp-postgres
MCP server for PostgreSQL. Read-only by default, row caps, timeouts, secrets never logged.
client:Claude Desktop
transport:stdio
runtime:npm
Install database mcp postgres in Claude Desktop
~/Library/Application Support/Claude/claude_desktop_config.json · windows: %APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"database-mcp-postgres": {
"command": "npx",
"args": [
"-y",
"@database-mcp/postgres"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DATABASE": "<POSTGRES_DATABASE>"
}
}
}
}
Settings → Developer → Edit Config opens this file. Restart the app after saving. Claude Desktop docs