> ## Documentation Index
> Fetch the complete documentation index at: https://midplane.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect VS Code to Postgres over MCP

> Add the gateway to VS Code so GitHub Copilot can query Postgres: sign in, then choose which databases it may read or write.

[Midplane](https://midplane.ai/docs/index.md) is a gateway between AI agents and your Postgres databases.
GitHub Copilot in VS Code queries your data through it, never holds a
connection string, and every statement it sends is checked against your policy
before it runs.

You need a running gateway ([get started](https://midplane.ai/docs/get-started.md)).

**1. Add the gateway**

On the project's **Agents** page, under **Connect an agent**, pick **VS
Code** and click **Add to VS Code**. VS Code opens and asks to install
`midplane`, in your user profile.

> **Or add it by hand, for one workspace**
>
> In `.vscode/mcp.json`, with the gateway's URL from that card:
>
> ```json theme={null}
> {
>   "servers": {
>     "midplane": {
>       "type": "http",
>       "url": "<gateway URL>"
>     }
>   }
> }
> ```

**2. Sign in**

Start `midplane`, and allow the sign-in.

**3. Choose what it may reach**

Set each database to **None**, **Read** or **Read + write**, and **Allow**.

**4. Try it**

Ask Copilot, in agent mode, which tables it can see. Its statement shows
up in the project's **Query log**.

> [!TIP]
>
> You're set: Copilot can answer questions from your data, and only what your
> policy allows runs. Masked columns stay masked, writes that need approval
> wait for a person, and every statement is in the audit log.

To cut it off, **Revoke** it under **Connected agents** on the **Agents** page.
It has to sign in again within 15 minutes.

## If it doesn't work

* **The consent page says it wants access, with no databases**: you aren't a
  member of the gateway's project, or the gateway isn't registered. Ask an
  owner of the organization.
* **The `localhost` URL does not resolve**: see
  [troubleshooting](https://midplane.ai/docs/troubleshooting.md#the-localhost-url-does-not-resolve).

*Tested by* `apps/gateway/test/auth.test.ts` for the gateway's side; the
client's steps by hand.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.