PostgreSQL MCP Server for Claude Desktop
io.github.musaddiq-dev/postgresql-mcp-server
Python MCP server for PostgreSQL database inspection and querying
client:Claude Desktop
transport:stdio
runtime:pypi
Install PostgreSQL MCP Server in Claude Desktop
~/Library/Application Support/Claude/claude_desktop_config.json · windows: %APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"postgresql-mcp-server": {
"command": "uvx",
"args": [
"mdev-postgresql-mcp-server"
],
"env": {
"POSTGRES_HOST": "<POSTGRES_HOST>",
"POSTGRES_PORT": "<POSTGRES_PORT>",
"POSTGRES_USER": "<POSTGRES_USER>",
"POSTGRES_PASSWORD": "<POSTGRES_PASSWORD>",
"POSTGRES_DB": "<POSTGRES_DB>",
"POSTGRES_READ_QUERY_LIMIT": "<POSTGRES_READ_QUERY_LIMIT>"
}
}
}
}
Settings → Developer → Edit Config opens this file. Restart the app after saving. Claude Desktop docs