Query geo data from VS Code

Connect the DuckDB Geo MCP server to GitHub Copilot and explore spatial datasets with plain English.

01

Open the MCP configuration

Open the Command Palette, type the command below, and press Enter. VS Code will create and open the config file automatically.

⌘ Cmd + Shift + P  // Mac
Ctrl + Shift + P  // Windows / Linux

MCP: Open Workspace Configuration
02

Paste the server config

Replace any existing content in the file with the following, then save.

{
  "servers": {
    "duckdb-geo": {
      "url": "https://duckdb-mcp.nrp-nautilus.io/mcp"
    }
  }
}

When prompted, click Start to connect to the server.

03

Open Copilot Chat in Agent mode

MCP tools only work in Agent mode — not Ask or Edit.

⌘ Cmd + Ctrl + I  // Mac
Ctrl + Alt + I   // Windows / Linux
Use the dropdown at the top of the chat panel to switch from Ask to Agent.

Confirm you're connected

Option 1 Run MCP: List Servers from the Command Palette — duckdb-geo should appear with a running status.
Option 2 Look for the 🔧 tools icon in the Copilot Chat input. Click it to see the tools the server registered.
Option 3 Just ask the agent: "What tools do you have available?" — it will list the MCP tools if connected.

Starter prompts to try

What datasets are available on this server?
Show me the schema of all available tables.
How many wetland sites are in Southeast Asia?
Which protected areas have the highest biodiversity scores?
Run SHOW TABLES and describe each one.