VS Code

How to use Postgres with VS Code

You want Postgres inside VS Code so it can map the database before querying it, answer a question from operational data, investigate an unexpected metric, and check data before building a report — without you copy-pasting between tabs. Here is the whole setup, once.

Create your Postgres gateway

The gateway is the thing VS Code connects to, and it is where you decide which Postgres tools an agent may use. You create it once and every client reuses it.

Create an Arcade account

Sign up and open the dashboard. The free tier is enough to follow this through.
Create an MCP Gateway and select your Postgres tools

In the dashboard, create a gateway and pick the Postgres tools you want to expose. The gateway is what your client connects to, and it is where tool access is decided.
Copy your gateway URL

Every client below needs it.
```
https://api.arcade.dev/mcp/<YOUR-GATEWAY-SLUG>
```

Create a Postgres gateway Opens the gateway builder in your Arcade dashboard.

Connect the gateway to VS Code

Add the server

VS Code 1.107.0 or higher. Command Palette → MCP: Add Server… → choose HTTP, paste your gateway URL, and name it something like mcp-arcade.
Start it and authenticate

Click Start next to the server in mcp.json or under Extensions → MCP Servers - Installed, then approve the Arcade sign-in and consent screens.
Try it out

Open the chat pane, switch to Agent mode, and ask it to use one of your Postgres tools.

Full VS Code guide in the docs steps verified 2026-08-13

Try these Postgres prompts

VS Code can now act on your Postgres account. Click a prompt to copy it.

Give the connection a read-only database credential so an agent can inspect schemas and query data without changing rows. Pair it with Contextual Access policies so the agent can explore approved data without gaining write access.

How to use Postgres with VS Code

Create your Postgres gateway

Create an Arcade account

Create an MCP Gateway and select your Postgres tools

Copy your gateway URL

Connect the gateway to VS Code

Add the server

Start it and authenticate

Try it out

Try these Postgres prompts

Ready to actually ship your agent?