Read-only database access with schema inspection and query execution for PostgreSQL databases
POSTGRES_CONNECTION_STRINGnpx @getmcp/cli add postgresConfig file: ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres"
],
"env": {
"POSTGRES_CONNECTION_STRING": ""
}
}
}
}