VS Code HubSpot Integrations MCP Resource/Redshift SQL RPC
How to: VS Code HubSpot Integrations MCP Redshift SQL RPC
Add HubSpot Integrations MCP to VS Code
-
01
Open .vscode/mcp.json and merge this in. Keep any servers already there.
{
"servers": {
"hubspot-integrations-mcp": {
"type": "http",
"url": "https://n6k96b1ql7.execute-api.us-west-2.amazonaws.com/prod/"
}
}
}-
02
Save the file and restart VS Code.
-
03
Redshift SQL RPC is surfaced wherever your client lets you attach context. It is context to attach, not an action to run.
-
04
If it does not appear, check that HubSpot Integrations MCP is connected and that you are looking at its resources rather than its tools.
Requires agent mode. MCP: Open User Configuration puts the same block in every workspace. VS Code docs
Same resource, other clients
Read from the server itself, by connecting to it and calling resources/list on 24 September 2026.
A listing does not declare its resources, so asking is the only way to know them, and this
is what the server actually offers rather than what its listing claims. Names only are
stored; connect the server for each resource's type and contents.