Requires Node 18+ on your system so npx can fetch the package on first run. Cursor reloads its MCP servers automatically the moment the file is saved — no restart needed. Paste the config below, then follow the reload step to register mcp-postgres-full-access.
~/.cursor/mcp.json.cursor/mcp.json (commit alongside your repo){
"mcpServers": {
"postgres-full": {
"command": "npx",
"args": [
"-y",
"mcp-postgres-full-access",
"postgresql://username:password@localhost:5432/database"
],
"env": {
"TRANSACTION_TIMEOUT_MS": "60000",
"MAX_CONCURRENT_TRANSACTIONS": "5",
"PG_STATEMENT_TIMEOUT_MS": "30000"
}
}
}
}